Senior Business Intelligence Analyst

Bloom Healthcare•Lakewood, CO

5d•$120,000 - $160,000•Hybrid

About The Position

The Senior Business Intelligence Analyst turns organizational data into trusted insights that support business decision-making. The role owns the process from data modeling through reporting and analysis, including building dbt models, defining governed semantic models in Snowflake, delivering Power BI dashboards, and responding to ad-hoc questions. The analyst works with business stakeholders to understand their needs and with data engineering to ensure underlying data is clean, documented, and consistent. The position also involves enabling end users to explore data confidently, improving reporting and analytical efficiency, maintaining reliable data pipelines and definitions, and communicating findings—including data limitations—in ways that inform decisions. The role is based onsite in Lakewood, Colorado, with some remote work available as part of the stated hybrid flexibility.

Requirements

Bachelor’s degree in Math, Biostatistics, Engineering, or another data-intensive field.
At least 8 years of experience in business intelligence, analytics, or a related role.
Strong SQL skills, including CTEs, window functions, and query optimization on a cloud data warehouse.
Hands-on experience building and maintaining Power BI dashboards, including data modeling and DAX.
Experience with dimensional modeling concepts such as star schemas, facts, and dimensions.
Experience with dbt or a comparable transformation framework, or a strong foundation in SQL-based modeling and willingness to learn quickly.
Familiarity with Snowflake or a similar cloud data warehouse.
Clear communication with non-technical audiences, including explaining what data can and cannot tell us.
Attention to detail and a habit of validating results before sharing them.

Nice To Haves

Master’s degree.
Experience with healthcare data and knowledge of population health and Accountable Care Organization concepts, including quality measures, attribution, risk adjustment, and value-based care reporting.
Experience with ELT/ETL pipelines and how data flows from source systems into a warehouse.
Python for analysis, automation, or data manipulation.
Experience with Git-based workflows and version control for analytics code.
Exposure to semantic layers, metric definitions, or AI-assisted analytics tools.

Responsibilities

Consult with stakeholders to clarify needs, define measures of success, and translate requirements into reporting and analysis plans.
Train and support end users in exploring data independently.
Identify opportunities to improve efficiency through analysis and recommend reporting solutions to address gaps.
Develop and maintain dbt models that transform raw data into clean, tested, and well-documented datasets.
Create and maintain Snowflake semantic models that clearly define metrics, relationships, and business context for users and AI tools; test them against business questions and refine them.
Improve test coverage and pipeline monitoring to help ensure data accuracy.
Build and maintain Power BI dashboards that provide key metrics to their intended audiences.
Use SQL to answer ad-hoc questions, investigate trends, and analyze anomalies.
Interpret and present results in context, communicate limitations in the data, and influence decisions.
Trace data discrepancies through the pipeline and work with data engineering to address root causes.
Document metric definitions, models, and dashboards to promote consistent use of data.
Support adoption and regular use of accurate dashboards, consistent metric definitions, trusted ad-hoc analysis, and tested, documented models.