Junior Programmer Analyst

Jobtailor; India; On-site; INR 600,000 - 900,000; Full time

Job summary

EXL is looking for an experienced professional to develop and maintain SSRS reports while designing interactive dashboards using Power BI. The role encompasses ETL processes, data modeling, and stakeholder collaboration.

The ideal candidate should have a robust background in data visualization best practices, data validation, and deployment of reports. Familiarity with SQL Server, SSIS packages, and DAX is essential.

Qualifications

• Experience with developing and maintaining SSRS reports.
• Proficiency in data transformation and ETL processes using SSIS.
• Strong knowledge of Power BI for dashboards and reports.

Responsibilities

• Develop and maintain SSRS reports and interactive dashboards.
• Implement ETL processes and perform data cleansing.
• Collaborate with stakeholders to gather reporting requirements.

Skills

SSRS reporting

Power BI

ETL processes

SSIS

Data modeling

Data analysis

DAX

Stakeholder collaboration

Tools

SQL Server

APIs

Flat files

Job description

Key Responsibilities

1. 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

2. 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

3. 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

4. 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

5. 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