Programmer Analyst

Key Responsibilities

• Reporting & Visualization
• Develop and maintain SSRS reports (tabular, matrix, drill-through, and parameterized reports)
• Design interactive dashboards and reports using Power BI
• Implement data visualization best practices (KPI cards, trend analysis, RAG indicators)
• Optimize reports for performance and usability
• Data Integration & ETL
• Develop and maintain SSIS packages for ETL processes
• Extract data from multiple sources (SQL Server, APIs, flat files)
• Perform data transformation, cleansing, and loading into reporting databases
• Schedule and monitor SSIS jobs for regular data refresh
• Data Modeling & Analysis
• Design and maintain data models for Power BI
• Create DAX measures, calculated columns, and data relationships
• Perform data validation and ensure accuracy of reporting metrics
• Stakeholder Collaboration
• Gather reporting requirements from business users, QA, and leadership
• Convert business needs into technical specifications
• Provide insights and recommendations based on data analysis
• Deployment & Maintenance
• Deploy reports across environments (DEV, QA, PROD)
• Troubleshoot issues related to report generation, data accuracy, and performance
• Maintain documentation for reports, dashboards, and ETL processes

🔹 Required Skills Technical Skills

• Strong experience in: - SSRS (SQL Server Reporting Services)
• SSIS (SQL Server Integration Services)
• Power BI (Desktop & Service)
• Proficiency in: - SQL (Stored Procedures, Joins, Performance tuning)
• Data modeling concepts
• DAX functions and Power Query
• Experience with: - Report deployment pipelines
• Data warehousing concepts