Senior Executive - Data Analyst

Job description

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