> Markdown version of [/jobs/ext/1249842-engineer-ii-business-intelligence](https://www.wearedevelopers.com/jobs/ext/1249842-engineer-ii-business-intelligence). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Engineer II, Business Intelligence - **Company:** Ensemble Health Partners - **Location:** Highland Heights, OH, United States (Remote available) - **Salary:** $84,500.0 - $126,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Big Data, Code Review, Databases, Data Cleansing, Extract Transform Load (ETL), Data Mining, Relational Databases, Data Intelligence, Scrum Methodology, Systems Development Life Cycle, Power BI, SQL Databases, Azure Data Factory, Databricks - **Published:** July 12, 2026 - **Apply:** https://www.careerjet.com/job/us3a1731c6c87431f5dc2f95a0ae215a18/eaa ## About the Role Preferred Knowledge, Skills and Abilities * 3-5 Years of related experience * Bachelors Degree or Equivalent Experience * 3+ years experience with relational databases and SQL experience. * Must have the ability to write complex, highly-optimized queries for data cleansing across large volumes of data. * 3+ years experience developing Power BI reports (with M, SQL, DAX language proficiency). * 3+ years of healthcare experience required, Revenue Cycle experience preferred * 1+ years of knowledge and/or experience with ETL and Azure data warehouse concepts and processes (Experience with Azure Databricks is a plus.) * Strong communication, organizational, planning, problem solving, analytical, judgment, and research skills. * Advanced SQL concepts and validation review between data source and report output. * Strong communication, organizational, planning, problem solving, analytical, judgment, and research skills. * Must be inquisitive and demonstrate openness to innovation including AI to explore better processes and ways to alleviate friction and improve patient and client experiences. * This is a remote position; however, candidates must be willing and able to travel to and work onsite at client, temporary, or corporate office locations as business needs require. ## Description The BI Engineer II designs, implements, and maintains systems used to collect and analyze business intelligence data. The selected Engineer will create dashboards, databases, and other platforms that allow for efficient collection and evaluation of BI data. Essential job Functions: * Ability to manage big data and creating solutions for reporting requirements provided by stakeholders. * Problem solving and completing root cause analysis on production bugs. * Following standard SDLC process and agile practices within a team. * Develop internal and external partnerships to provide opportunity for efficient solutions to various data, system, and application uses. * Drive the development and analysis of data, reporting automation, Dashboarding, and business intelligence programs. * Develop a deep understanding of systems and processes in order to extract insights from existing data leveraging agile practices to ensure the highest possible quality of delivery. * Actively review new bugs reported and complete grooming and sprint planning. * Complete bug root cause analysis and work with other teams as needed to resolve issues and completes documentation and notification to the bug reporter at least twice per week. * Subject matter expert (SME) of report data modeling as well as being knowledgeable about what each field is used for and is able to determine appropriate uses of data fields to create reporting. * Explain reports to team members regarding the subject matter of each report as well as the architecture used to put it together. * Collect, organize, and disseminate significant amounts of information with attention to detail and accuracy through Power BI report development. * Responsible for the data mining, manipulation and delivery to key stakeholders and executives in accordance with priorities and deadlines. * Ability to form key relationships with and deliver professional, customer focused service to key stakeholders and executives. * Leads the evaluation of what current and future data needs are and translates needs to stakeholders and product owners to support all lines of business. * Identifies report requirements and determine how the desired results can be achieved. * Responsible for developing and maintaining strategic reports out of multiple databases and systems. * Responsible for developing and maintaining strategic reports out of multiple databases and systems. * Completing systems validation for client data which identifies discrepancies in data totals or PK's. * Works with team members as mentor and provides opportunities of open collaboration to problem solve or optimize reports. * Practical application experience with Dax Studio and Performance Analyzer and can optimize reporting based on analysis findings. * Completing code review / peer review of completed work by co-developers and providing feedback identifying issues or required report updates to meet the requirements ahead of the report moving to UAT. * Presenting and/or publishing completed reports in accordance with publishing guidelines., This document is not an exhaustive list of all responsibilities, skills, duties, requirements, or working conditions associated with the job. Associates may be required to perform other job related duties as required by their supervisor, subject to reasonable accommodation. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)