Engineer II, Business Intelligence

Ensemble Health Partners; Hyderabad; Hybrid; INR 1,800,000 - 2,800,000; Full time

Benefits offered by this job

Healthcare coverage for associates and

Immediate family coverage

Paid time off

Retirement benefits

Recognition and wellness programs

Market competitive pay

Job summary

Ensemble Health Partners India is seeking an Engineer II, Business Intelligence in Hyderabad (Hybrid). You will design, develop, and maintain enterprise-grade Power BI reports and dashboards, collaborating with stakeholders to translate business requirements into scalable analytics solutions.

The role emphasizes ETL pipelines with Azure Data Factory and Databricks, data modeling, and QA/UAT, with mentoring for junior BI engineers.

Qualifications

• 2+ years of experience developing Power BI reports and dashboards in an enterprise environment.
• 2+ years of experience with relational databases and advanced T-SQL development.
• 2+ years of experience with Azure Data Factory, Azure Databricks, or equivalent cloud data technologies.
• 2+ years of experience designing and implementing ETL/ELT solutions.
• Experience building scalable semantic models and optimized reporting solutions.
• Experience troubleshooting and resolving production reporting and data issues.
• Healthcare Revenue Cycle Management experience preferred.

Responsibilities

• Design, develop, and maintain enterprise-grade Power BI reports, dashboards, and analytical solutions.
• Collaborate with stakeholders, product owners, and cross-functional teams to gather and translate business requirements into scalable reporting solutions.
• Develop, test, deploy, monitor, and continuously improve reporting pipelines and data integration processes.
• Build and optimize ETL processes using Azure Data Factory, Databricks, SQL, and related technologies.
• Automate data collection, transformation, validation, and distribution processes to improve operational efficiency.
• Perform data validation, reconciliation, and User Acceptance Testing (UAT) to ensure report accuracy and quality.
• Investigate production issues, perform root cause analysis, and implement sustainable solutions.
• Develop and maintain strategic reports utilizing data from multiple systems, databases, and platforms.
• Complete code reviews and peer reviews to ensure adherence to development standards and best practices.
• Publish and maintain reporting solutions in accordance with organizational governance and publishing guidelines.
• Identify opportunities for automation, process improvement, and self-service reporting capabilities.
• Provide technical guidance and mentorship to junior BI engineers and analysts.

Skills

Power BI

SQL

Azure Data Factory

Azure Databricks

Python

Data modeling

Spark SQL

Agile/DevOps

ETL design

Tools

Azure Data Factory

Azure Databricks

Job description

Thank you for considering a career at Ensemble Health Partners India! Ensemble Health Partners - The single solution for a frictionless revenue cycle with the purpose of redefining the possible in healthcare by empowering people to be the difference. Our India Office is an extension of Ensemble’s team and culture designed to augment and enhance our talent and skill base in Revenue Cycle Management in addition to our long-standing presence in technology. Leveraging our platform of services, technology, business intelligence and analytics, our teams are creating and maintaining innovative products and systems to help our revenue cycle operators achieve the most efficient, ideal outcomes for our clients. Our teams are certified in revenue cycle best practices and are supporting end-to-end RCM operations. We are at the forefront of innovation using cutting-edge technology to drive meaningful impact in the Revenue Cycle Management landscape. As a leading player in the industry, we offer an environment that fosters growth, creativity, and collaboration, where your expertise will be valued, and your contributions will make a difference.

The Opportunity:

Job Title: Engineer II, Business Intelligence Experience: 3 - 6 Years Job Location: Hyderabad (Hybrid) Position Summary: We are seeking a highly motivated Business Intelligence Engineer II to join our Business Intelligence team. This role is responsible for designing, developing, and maintaining scalable reporting and analytics solutions that enable data-driven decision-making across the organization. The ideal candidate will possess strong expertise in Power BI, SQL, Azure Data Services, and data engineering concepts, along with the ability to collaborate with stakeholders, understand business requirements, and deliver high-quality reporting solutions. This role will also support production issue resolution, data validation, report optimization, and continuous improvement initiatives while serving as a technical mentor to junior team members.

Key Responsibilities:

• Design, develop, and maintain enterprise-grade Power BI reports, dashboards, and analytical solutions.
• Collaborate with stakeholders, product owners, and cross-functional teams to gather and translate business requirements into scalable reporting solutions.
• Develop, test, deploy, monitor, and continuously improve reporting pipelines and data integration processes.
• Build and optimize ETL processes using Azure Data Factory, Databricks, SQL, and related technologies.
• Automate data collection, transformation, validation, and distribution processes to improve operational efficiency.
• Perform data validation, reconciliation, and User Acceptance Testing (UAT) to ensure report accuracy and quality.
• Investigate production issues, perform root cause analysis, and implement sustainable solutions.
• Develop and maintain strategic reports utilizing data from multiple systems, databases, and platforms.
• Complete code reviews and peer reviews to ensure adherence to development standards and best practices.
• Publish and maintain reporting solutions in accordance with organizational governance and publishing guidelines.
• Identify opportunities for automation, process improvement, and self-service reporting capabilities.
• Provide technical guidance and mentorship to junior BI engineers and analysts.
• Participate actively in Agile ceremonies including sprint planning, grooming, estimation, and retrospectives.
• Communicate project status, risks, dependencies, and delivery timelines effectively to stakeholders.

Required Skills:

• Strong experience in Power BI report development, including advanced DAX and semantic model design.
• Proficiency in SQL development with experience writing complex and optimized queries.
• Experience with Azure Data Factory, Azure Databricks, and Azure Data Platform services.
• Knowledge of data modeling principles, dimensional modeling, and data warehouse design.
• Experience with Python, Spark SQL, or similar technologies for data processing and automation.
• Strong understanding of ETL design patterns and best practices.
• Practical knowledge of SDLC methodologies, Agile development practices, and DevOps concepts.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent written and verbal communication skills.
• Ability to manage multiple priorities and work effectively in a fast-paced environment.

Preferred Knowledge, Skills, and Abilities:

• Microsoft Azure Certifications related to Data Engineering, Analytics, or Power Platform.
• Experience with API development, integration, and data consumption.
• Knowledge of healthcare revenue cycle management and healthcare analytics.
• Experience with Azure DevOps, Git, and CI/CD practices.
• Familiarity with Visual Studio Code and PowerShell scripting.
• Experience with performance tuning and optimization techniques for large-scale datasets.
• Ability to establish effective working relationships with technical and non-technical stakeholders.
• Demonstrated ability to communicate technical concepts to business audiences.

Required Experience:

• 2+ years of experience developing Power BI reports and dashboards in an enterprise environment.
• 2+ years of experience with relational databases and advanced T-SQL development.
• 2+ years of experience working with Azure Data Factory, Azure Databricks, or equivalent cloud data technologies.
• 2+ years of experience designing and implementing ETL/ELT solutions.
• Experience building scalable semantic models and optimized reporting solutions.
• Experience troubleshooting and resolving production reporting and data issues.
• Experience conducting data validation, reconciliation, and quality assurance activities.
• Healthcare Revenue Cycle Management experience preferred.

Why Choose Ensemble India?

People First, Last + Always We believe in putting people at the heart of everything. Our culture is rooted in collaboration, growth and innovation—where your contributions are valued, your voice is heard and your potential is nurtured.

A Place to Thrive Whether you're just starting out or looking to grow your career, Ensemble India is a place where you can do your best work and be your best self. We offer structured career paths, paid professional certifications, tuition reimbursement and mentorship opportunities to help you advance.

Comprehensive Total Rewards

We support the physical, emotional and financial well-being of you and your family. Our Total Rewards package include:

• Healthcare coverage for associates and their immediate families including parents
• Paid time off plans
• Retirement benefits
• Recognition and wellness programs
• Market competitive pay rates

Inclusive Culture

Our organization is deeply committed to fostering a positive environment and culture where we celebrate and reward merit and contribution and where every associate feels valued, included, and empowered to succeed.

Purpose-Driven Impact

We proudly partner with local communities through philanthropic initiatives—from school supply drives to health awareness campaigns—because giving back is part of who we are.

Ensemble Health Partners is an equal employment opportunity employer. It is our policy not to discriminate against any applicant or employee based on race, color, sex, sexual orientation, gender, gender identity, religion, national origin, age, disability, military or veteran status, genetic information or any other basis protected by applicable federal, state, or local laws. Ensemble Health Partners also prohibits harassment of applicants or employees based on any of these protected categories.

Ensemble Health Partners is a leading provider of technology-enabled revenue cycle management solutions for health systems, including hospitals and affiliated physician groups. They offer end-to-end revenue cycle solutions as well as a comprehensive suite of point solutions to clients across the country. Our India Office is an extension of Ensemble’s team and culture designed to augment and enhance our talent and skill base in Revenue Cycle Management in addition to our long-standing presence in technology. Leveraging our platform of services, technology, business intelligence and analytics, our teams are creating and maintaining innovative products and systems to help our revenue cycle operators achieve the most efficient, ideal outcomes for our clients. Our teams are certified in revenue cycle best practices and are supporting end-to-end RCM operations. We are at the forefront of innovation using cutting-edge technology to drive meaningful impact in the Revenue Cycle Management landscape. As a leading player in the industry, we offer an environment that fosters growth, creativity, and collaboration, where your expertise will be valued, and your contributions will make a difference.