Hybrid BI Analyst: Data Insights & Dashboards

Bloom Healthcare; Lakewood (CO); On-site; USD 105,000 - 135,000; Full time

Benefits offered by this job

Hybrid work flexibility (Lakewood)

Comprehensive medical, dental, and视ion

Employer-sponsored 401(k)

Generous paid time off and CME/profess

Job summary

Bloom Healthcare in Lakewood, CO is seeking a Business Intelligence Analyst to turn data into trusted insights that support all areas of the business. You will own the full path from modeled data to data-driven decisions, building dbt models, defining governed Snowflake semantic models, delivering Power BI dashboards, and answering ad-hoc questions.

You will partner with business stakeholders and collaborate with the data engineering team to ensure data is clean, documented, and consistent,

Qualifications

• Bachelor's degree in math, biostatistics, engineering, or another data-intensive field; Master’s preferred.
• 5+ years of experience in business intelligence, analytics, or a related role.
• Strong SQL skills (required), including CTEs, window functions, and query optimization on a cloud data warehouse.
• Hands-on experience building and maintaining Power BI dashboards (required), 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 a 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 the data can and can't tell us.
• Attention to detail and a habit of validating results before sharing them.

Responsibilities

• Partner with the business to clarify needs, define success metrics, and turn requirements into clear reporting and analysis plans.
• Train and support end users so they can explore data on their own with confidence.
• Spot opportunities to improve efficiency through analysis, and recommend new reporting solutions when you see a gap.
• Develop and maintain dbt models that turn raw data into clean, tested datasets.
• Create and maintain semantic models in Snowflake defining metrics and business context for AI tools.
• Improve test coverage and pipeline monitoring to ensure data accuracy.
• Build and maintain Power BI dashboards and answer ad-hoc SQL questions quickly and accurately.
• Present results with context and note data limitations.
• Trace discrepancies back through the pipeline and fix root causes with data engineering.
• Document metric definitions, models, and dashboards to ensure consistency.

Skills

SQL skills

Power BI

Dimensional modeling

Communication

Attention to detail

Education

Bachelor's degree in math, biostatistics, engineering or data-intensive field

Master’s degree preferred

Tools

dbt

Snowflake

Python

Git

DAX

ETL/ELT

Job description

Bloom Healthcare in Lakewood, CO is seeking a Business Intelligence Analyst to turn data into trusted insights that support all areas of the business. You will own the full path from modeled data to data-driven decisions, building dbt models, defining governed Snowflake semantic models, delivering Power BI dashboards, and answering ad-hoc questions.

You will partner with business stakeholders and collaborate with the data engineering team to ensure data is clean, documented, and consistent,