Business Intelligence Engineer II

Ensemble Health Partners; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

Ensemble Health Partners is seeking a skilled Power BI Engineer to design, develop, and maintain enterprise-grade BI reports and dashboards. You will translate complex business requirements into scalable analytics solutions and collaborate with stakeholders across departments.

Applicants should have 2+ years of experience with Power BI, SQL, Azure Data Factory, and Azure Databricks, plus strong data modeling and ETL/ELT design experience. Healthcare analytics experience is a plus.

Qualifications

• 2+ years of experience building Power BI reports in enterprise environments.
• 2+ years of SQL development and complex query optimization.
• Experience with Azure Data Factory, Databricks, or equivalent cloud data technologies.
• Experience designing and implementing ETL/ELT solutions.
• Knowledge of data modeling and SDLC methodologies.
• Strong Python or Spark SQL for data processing.

Responsibilities

• Design, develop, and maintain enterprise-grade Power BI reports, dashboards, and analytical solutions.
• Collaborate with stakeholders to translate business requirements into scalable reporting solutions.
• Build and optimize ETL processes using Azure Data Factory, Databricks, and SQL.
• Automate data collection, transformation, validation, and distribution processes.
• Perform data validation, reconciliation, and User Acceptance Testing (UAT).
• Investigate production issues and perform root cause analysis.
• Provide technical guidance and mentorship to junior BI engineers.
• Participate in Agile ceremonies including sprint planning and retrospectives.

Skills

Power BI

SQL

Python

Spark SQL

Data modeling

ETL/ELT design

Tools

Azure Data Factory

Azure Databricks

CI/CD

Git

Visual Studio Code

Job description

Responsibilities

• Design, develop, and maintain enterprise-grade Power BI reports, dashboards, and analytical solutions
• Collaborate with stakeholders to translate business requirements into scalable reporting solutions
• Build and optimize ETL processes using Azure Data Factory, Databricks, and SQL
• Automate data collection, transformation, validation, and distribution processes
• Perform data validation, reconciliation, and User Acceptance Testing (UAT)
• Investigate production issues and perform root cause analysis
• Provide technical guidance and mentorship to junior BI engineers
• Participate in Agile ceremonies including sprint planning and retrospectives

Requirements

• 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
• Strong proficiency in SQL development and complex query optimization
• Experience with Python or Spark SQL for data processing
• Knowledge of data modeling principles and dimensional modeling
• Strong understanding of ETL design patterns and SDLC methodologies

Preferred Qualifications

• Microsoft Azure Certifications (Data Engineering, Analytics, or Power Platform)
• Experience with healthcare revenue cycle management and healthcare analytics
• Experience with Azure DevOps, Git, and CI/CD practices
• Knowledge of API development and integration
• Familiarity with PowerShell scripting and Visual Studio Code