Senior Business Intelligence Engineer

Become a part of our caring community

The Senior Business Intelligence Engineer supports reporting, data engineering, dashboard development, Power Platform solutions, and ad hoc analytics for the team. This role uses internal and external data to deliver actionable insights and scalable solutions for business partners.

The position works on moderately complex to complex assignments requiring strong SQL, Power BI, Power BI Desktop, Power BI Report Builder, PowerApps, Power Automate, and Databricks data engineering skills, along with the ability to operate effectively in ambiguous environments. Experience with Python/PySpark, healthcare data, and AI/ML development in Databricks is preferred.

The Senior Business Intelligence Engineer develops and supports the tools, datasets, pipelines, reports, dashboards, applications, and automated workflows used to collect, integrate, analyze, and present data for actionable business insights.

This role will maintain and enhance reporting capabilities, support recurring and ad hoc business needs, and contribute to Databricks modernization and emerging AI/ML initiatives.

The Senior Business Intelligence Engineer will

Maintain and enhance data pipelines, reporting datasets, dashboard refresh processes, and recurring analytics assets.

Partner with business and technical stakeholders to understand needs and translate ambiguous requests into scalable data, reporting, application, and workflow automation solutions.

Research source systems, data definitions, ownership, and lineage to support intake requests and solution development.

Write complex SQL queries to extract, transform, summarize, and analyze data.

Build and maintain dashboards, paginated reports, and analytical products using Power BI, Power BI Desktop, and Power BI Report Builder.

Develop and support PowerApps solutions that improve business workflows and user access to insights.

Develop and support Power Automate flows to streamline business processes, notifications, approvals, and reporting-related automation.

Build and support data engineering solutions in Databricks, including pipelines, transformations, workflows, and automation.

Support modernization efforts as data processes continue to expand within Databricks.

Contribute to emerging AI/ML and generative AI use cases, including solutions leveraging structured and unstructured data.

Use sound judgment to determine technical approach and deliver solutions with limited direction.

Undergraduate degree

Minimum 5 years of SQL experience, including writing complex queries to extract, transform, summarize, and analyze data from multiple sources

Minimum 2 years of experience utilizing Databricks data engineering, including building and maintaining pipelines, workflows, and data transformation processes

Experience developing dashboards, semantic models, and paginated reports using Power BI, Power BI Desktop, and Power BI Report Builder or similar BI tools

Experience building or supporting solutions in PowerApps

Experience building or supporting workflow automation solutions using Power Automate

Demonstrated analytical experience, including the ability to work through ambiguous business requests, perform data discovery, and develop actionable solutions

Strong verbal and written communication skills, with the ability to collaborate effectively across technical and non-technical stakeholders

Work-At-Home Requirements

At minimum, a download speed of 25 mbps and an upload speed of 10 mbps is recommended; wireless, wired cable or DSL connection is suggested