Develop and maintain SSRS reports, Power BI dashboards, and SSIS ETL packages. Design data models, create DAX measures, perform data cleansing and validation, optimize report performance, deploy across environments, and collaborate with stakeholders to translate requirements and deliver reporting 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 Pune, Mahārāshtra, IND Office
Pune, India
Similar Jobs
Information Technology • Database • Consulting
Support design, development, testing, deployment, and maintenance of secure full-stack web applications using .NET/C#, JavaScript/React, and SQL. Participate in Agile ceremonies, assist with UI/UX and testing, contribute to data integration and Azure cloud migration, use Git for version control, document work, and engage in knowledge sharing and mentoring.
Top Skills:
.NetAsp.NetAzure App ServicesAzure Data FactoryAzure SynapseC#CSSDatabricksEntity FrameworkGitHTMLJavaScriptJqueryAzureMvcOauthReactRestful ApisRole-Based Access ControlSQLSQL ServerSsoWeb Api
Information Technology • Database • Consulting
Support design, development, testing, deployment, and maintenance of full‑stack web applications using .NET/C#, JavaScript/React, and SQL Server. Participate in Agile ceremonies, assist with UI/UX and testing, support cloud migrations to Azure, contribute to data integration/reporting, use Git for version control, and produce technical documentation while learning and mentoring peers.
Top Skills:
.NetAsp.NetAzure App ServicesAzure Data FactoryAzure SynapseC#CSSDatabricksEntity FrameworkGitHTMLJavaScriptJqueryAzureMvcOauthReactRestful ApisSQLSQL ServerSsoWeb Apis
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Perform day-to-day accounting and bookkeeping for real estate funds and SPVs, prepare monthly/quarterly NAV packs and reconciliations, support valuation updates, transaction accounting, investor reporting, cash reconciliations, audit requests, and client deliverables. Maintain accurate records, workpapers, and assist with onboarding and fund transitions while using Yardi Voyager and macro-enabled Excel workbooks.
Top Skills:
Excel (Macros/Vba)MS OfficeYardi Voyager
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
