Senior BI Analyst: Data Modeling & Power BI Lead

Bloom Healthcare

Denver (CO)

On-site

USD 120,000 - 160,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Hybrid work flexibility
Lakewood-based role

Job summary

Bloom Healthcare is seeking a Senior BI Analyst to turn data into trusted insights supporting the business. You will own the path from modeled data to data-driven decisions, building dbt models, defining semantic models in Snowflake, and delivering Power BI dashboards.

You will work with stakeholders to understand needs, ensure data quality, and collaborate with data engineering to maintain clean, well-documented data across a compliant analytics stack.

Qualifications

  • Bachelor's degree in math, biostatistics, engineering, or another data intensive field (Master’s preferred).
  • 8+ years of experience in BI, analytics, or related role.
  • Strong SQL skills (CTEs, window functions, 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 (star schemas, facts, and dimensions).
  • Experience with dbt or SQL-based transformations, or a strong SQL-based modeling foundation.
  • Familiarity with Snowflake or similar cloud data warehouse.
  • Clear communication with non-technical audiences.
  • Attention to detail and validating results before sharing them.

Responsibilities

  • Consult with stakeholders to clarify needs, define success metrics, and translate requirements into reporting and analysis plans.
  • Train and support end users to explore data confidently.
  • Identify efficiency opportunities and propose new reporting solutions when gaps exist.
  • Develop and maintain dbt models turning raw data into clean, documented datasets.
  • Create and maintain semantic models in Snowflake defining metrics and relationships.
  • Improve test coverage and pipeline monitoring for accurate data.
  • Build and maintain Power BI dashboards to show key metrics.
  • Use SQL to answer ad-hoc questions and provide quick insights.
  • Interpret results in context and present findings to influence decisions.

Skills

SQL proficiency
Stakeholder communication
Attention to detail
Data storytelling
Analytical mindset

Education

Bachelor's degree in Math, Biostatistics, Engineering, or related field

Tools

Power BI
dbt
Snowflake
ETL/ELT pipelines
Python

Job description

Bloom Healthcare is seeking a Senior BI Analyst to turn data into trusted insights supporting the business. You will own the path from modeled data to data-driven decisions, building dbt models, defining semantic models in Snowflake, and delivering Power BI dashboards.

You will work with stakeholders to understand needs, ensure data quality, and collaborate with data engineering to maintain clean, well-documented data across a compliant analytics stack.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior BI Analyst: Data Modeling, Snowflake & Power BI Lead
Senior BI Analyst: Data Modeling, Snowflake & Power BI Lead

Bloom Healthcare • Lakewood (CO)

Hybrid
USD 120,000 - 160,000
Hybrid work flexibility
Lakewood-based role
Senior Business Intelligence Analyst
Senior Business Intelligence Analyst

Bloom Healthcare • Lakewood (CO)

Hybrid
USD 120,000 - 160,000
Hybrid work flexibility
Lakewood-based role
Senior BI Analyst — Data Strategy & Insights Leader
Senior BI Analyst — Data Strategy & Insights Leader

Bloomberg Industry Group • Arlington (VA)

On-site
USD 140,000 - 180,000
Senior BI Engineer - Snowflake, Power BI & AI Analytics
Senior BI Engineer - Snowflake, Power BI & AI Analytics

CrossCountry Consulting LLC • New York (NY)

On-site
USD 130,000 - 185,000
Health coverage
401(k) with company match
Parental leave
+2
Senior Power BI & Financial Analytics Analyst
Senior Power BI & Financial Analytics Analyst

CloudBigD • Oklahoma

On-site
USD 90,000 - 120,000
Senior BI Engineer — Snowflake & Power BI Expert
Senior BI Engineer — Snowflake & Power BI Expert

CrossCountry Consulting • New York (NY)

On-site
USD 130,000 - 185,000
Healthcare options
401(k) with company matching
Parental and maternity leave policies
+2
Healthcare BI Developer - Power BI & Analytics
Healthcare BI Developer - Power BI & Analytics

Salt Dental Partners • United States

Remote
USD 110,000 - 150,000
401k match
Life insurance
PTO
+2
Senior Data Analyst - Remote, Power BI & Data Modeling
Senior Data Analyst - Remote, Power BI & Data Modeling

Navitus Health Solutions, LLC • Iowa City (IA)

Remote
USD 90,000 - 130,000
Health insurance
Dental insurance
Vision insurance
+9
Senior SQL & BI Analyst - Healthcare Data & Dashboards
Senior SQL & BI Analyst - Healthcare Data & Dashboards

Health Business Solutions • United States

Remote
USD 80,000 - 110,000
Senior BI Engineer & Data Solutions Lead
Senior BI Engineer & Data Solutions Lead

Mathematica, Inc. • Princeton (NJ)

On-site
USD 105,000 - 135,000