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

- Solid 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

📌 Senior Executive - Data Analyst (Chennai)
🏢 EXL
📍 Chennai