Engineer II, Business Intelligence

Ensemble Health Partners

BI Engineer II building enterprise Power BI reports and Azure data pipelines. Enabling data-driven decisions through scalable analytics, validation, optimization, and automation.

Posted 8/23/2026full-timeRemote • 🇮🇳 IndiaJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Power BI report development, advanced DAX, and SQL for data processing and automation. Proficient in ETL design, Azure Data Factory, and Agile methodologies, with strong analytical and communication skills.

Highest-signal resume keywords

Power BI Report DevelopmentAdvanced DAXSQL DevelopmentAzure Data FactoryETL Design Patterns

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Power BISQLDAXETLData ModelingAzure DatabricksPythonSpark SQLData ValidationPerformance Tuning

Soft Skills

Analytical SkillsProblem-SolvingCommunicationCollaborationTime Management

Tools & Technologies

Azure Data FactoryAzure DatabricksAzure DevOpsGitVisual Studio CodePowerShell

Certifications & Qualifications

Microsoft Azure Certifications

Industry Keywords

Healthcare Revenue Cycle ManagementData Warehouse DesignAgile DevelopmentSDLCData Integration

Tech Stack

Tools & technologies

AzureCloudETLPythonSDLCSparkSQL

About the role

Key responsibilities & impact

Design, develop, and maintain enterprise-grade Power BI reports, dashboards, and analytical solutions
Collaborate with stakeholders, product owners, and cross-functional teams to 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
Perform data validation, reconciliation, and User Acceptance Testing to ensure report accuracy and quality
Investigate production issues, perform root cause analysis, and implement sustainable solutions
Develop and maintain strategic reports using data from multiple systems, databases, and platforms
Complete code reviews and peer reviews
Publish and maintain reporting solutions according to governance and publishing guidelines
Identify opportunities for automation, process improvement, and self-service reporting
Provide technical guidance and mentorship to junior BI engineers and analysts
Participate in Agile ceremonies including sprint planning, grooming, estimation, and retrospectives
Communicate project status, risks, dependencies, and delivery timelines to stakeholders

Requirements

What you’ll need

3–6 years of experience stated for the role
Strong experience in Power BI report development, including advanced DAX and semantic model design
Proficiency in SQL development, including 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 in a fast-paced environment
Preferred: Microsoft Azure Certifications related to Data Engineering, Analytics, or Power Platform
Preferred: Experience with API development, integration, and data consumption
Preferred: Knowledge of healthcare revenue cycle management and healthcare analytics
Preferred: Experience with Azure DevOps, Git, and CI/CD practices
Preferred: Familiarity with Visual Studio Code and PowerShell scripting
Preferred: Experience with performance tuning and optimization for large-scale datasets
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
Experience conducting data validation, reconciliation, and quality assurance activities
Healthcare Revenue Cycle Management experience preferred

Benefits

Comp & perks

Full-time employment