Business Intelligence Analyst

Bloom Healthcare•Lakewood, CO

1d•$105,000 - $135,000•Onsite

About The Position

The Business Intelligence Analyst turns data into trusted insights supporting all areas of the business. The role owns the path from modeled data to data-driven decision-making: developing dbt models, defining governed semantic models in Snowflake, delivering Power BI dashboards, and answering ad-hoc questions. It works at the intersection of analytics and data modeling, collaborating with business stakeholders to understand their needs and with data engineering to ensure underlying data is clean, documented, and consistent. The analyst consults with stakeholders to define needs and measures of success, supports end users in exploring data, and identifies opportunities for efficiency and improved reporting. The role develops and maintains tested, documented dbt models and Snowflake semantic models; builds Power BI dashboards; analyzes questions using SQL; communicates findings and data limitations; monitors data quality; investigates discrepancies; and documents metrics, models, and dashboards. The position is based onsite in Lakewood, Colorado, with some remote work available. Bloom Healthcare offers a competitive compensation package, with a base salary range of $105,000–$135,000 annually depending on qualifications and experience.

Requirements

Bachelor’s degree in Math, Biostatistics, Engineering, or another data-intensive field.
At least 5 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, including 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 the ability to explain what data can and cannot show.
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 (ACO) concepts, including quality measures, attribution, risk adjustment, and value-based care reporting.
Experience with ELT/ETL pipelines and 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 success measures, and translate requirements into reporting and analysis plans.
Train and support end users so they can confidently explore data independently.
Identify opportunities to improve efficiency through analysis and recommend reporting solutions where gaps exist.
Develop and maintain dbt models that turn raw data into clean, tested, well-documented datasets.
Create and maintain Snowflake semantic models that clearly define metrics, relationships, and business context; test them against business questions and refine them.
Improve test coverage and pipeline monitoring to ensure data accuracy for stakeholders.
Build and maintain Power BI dashboards that deliver key metrics to the intended audiences.
Use SQL to answer ad-hoc questions, investigate trends, and analyze anomalies.
Interpret results in context and present findings to influence decisions, including explaining limitations in the data.
Trace data discrepancies through the pipeline and work with data engineering to resolve root causes.
Document metric definitions, models, and dashboards to promote consistent use of data.