Design, build, and maintain SSRS reports, SSIS ETL packages, and Power BI dashboards. Perform data modeling, DAX/Power Query transformations, SQL tuning, data validation, deployments across DEV/QA/PROD, and collaborate with stakeholders to convert requirements into actionable reports and insights.
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
🔹 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
- Soft Skills
- Strong analytical and problem-solving skills
- Good communication with business stakeholders
- Ability to handle multiple reporting requests simultaneously
-
- 🔹 Preferred Qualifications
- Experience in Healthcare / Audit / Claims domain (highly relevant for your work context)
- Exposure to Azure / Databricks / Cloud data platforms
- Experience with automation (Power Automate / scheduling tools)
-
- 🔹 Sample Deliverables (Role Expectations)
- Operational SSRS reports (e.g., productivity, inventory, audit reports)
- Power BI dashboards for leadership (RAG status, KPIs)
- SSIS packages for automated data pipelines
- Monthly/weekly performance reporting insights
-
- 🔹 Experience Range
-
- 🔹 Tools & Technologies
- SQL Server, SSRS, SSIS
- Power BI (Desktop + Service)
- Excel (Advanced)
- Optional: Azure Data Factory, Databricks
Candidates should have a Bachelor’s or Master’s degree in Engineering or a related discipline, with a strong foundation in programming concepts, data structures, and problem‑solving. Basic knowledge of Microsoft technologies, exposure to Azure cloud services, and familiarity with Agile methodologies are preferred. Good communication skills, analytical thinking, willingness to learn new technologies, and the ability to work effectively with cross‑functional and geographically distributed teams are essential.
EXL Chennai, Tamil Nadu, IND Office
Chennai, India
Similar Jobs
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Perform clinical data monitoring and management activities: data review, query management, investigate logic checks, and ensure database design quality through documentation, testing, validation, and implementation of data collection tools. Act as first point of contact for CTMS issues, follow SOPs, collaborate to resolve TMF/document discrepancies, and contribute to process improvements and project work.
Top Skills:
ChatgptCtmsElectronic Documentation Management SystemsMicrosoft CopilotMicrosoft Office SuiteWeb-Based Data Management Systems
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
The Associate Manager - Indirect Taxation at Pfizer will manage GST compliance, audits, reconciliations, and indirect tax matters, serving as the key operational owner and ensuring adherence to regulations.
Top Skills:
CustomsEouExcelGstGst Compliance ToolsMmSap (Fi-CoSd)
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Lead platform reliability and operations for enterprise AI agent platforms: build and operate cloud-native infrastructure, observability (metrics, logs, traces), IaC (Terraform), CI/CD, incident response, SLO/SLAs, cost and security optimization, and mentor engineers to improve platform resilience and developer experience.
Top Skills:
BashDockerGithub ActionsGoogle Cloud Platform (Gcp)GrafanaKubernetesLangfuseLangsmithLinux/UnixAzureOpentelemetryPythonTerraformTypescript
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
