Senior Executive - Data Analyst

EXL; Chennai District; On-site; INR 800,000 - 1,400,000; Full time

Job summary

EXL in Chennai, India, is seeking a skilled BI/ETL Developer to design and deliver reporting solutions using SSRS, SSIS, and Power BI. You will transform business needs into technical specifications and implement robust data pipelines.

The role emphasizes data modeling, KPI-driven dashboards, and performance tuning to ensure accurate and timely insights. Collaboration with stakeholders is essential across DEV, QA, PROD environments.

Qualifications

• Strong experience in SSRS and SSIS for reporting and data integration.
• Proficient in Power BI desktop and service for dashboards.
• Advanced SQL skills including stored procedures and query tuning.
• Knowledge of data warehousing concepts and data modeling.
• Experience with DAX, Power Query, and deployment pipelines.

Responsibilities

• Develop and maintain SSRS reports (tabular, matrix, drill-through).
• Design interactive Power BI dashboards and reports.
• Implement data visualization best practices and KPI indicators.
• Optimize reports for performance and usability.
• Develop and maintain SSIS packages for ETL processes.
• Extract data from SQL Server and other sources; transform and load to reporting databases.
• Schedule and monitor SSIS jobs for data refresh.
• Design and maintain data models; create DAX measures and relationships.
• Collaborate with stakeholders to gather requirements and translate to specs.
• Deploy reports across DEV, QA, PROD environments and maintain documentation.

Skills

SSRS

SSIS

Power BI

SQL

Data modeling

DAX

Power Query

Deployment pipelines

Data warehousing

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