
Carrum
is hiring
Principal Business Intelligence Analyst
About Our Company
Healthcare is unreasonably complex and costly. At Carrum Health, we’re applying a common sense approach to simplify the payment model and produce greater value for employers and their employees. We do so by directly connecting progressive self-insured employers to top-quality regional healthcare providers through the industry’s first comprehensive bundled payment solution. Our innovative platform reimagines how care is paid for and delivered, improving the value of health benefits for employers and their members.
Job Description & Responsibilities
You’re excited about this opportunity because you will...
You automate before you manually do it twice - If you find yourself running the same query or building the same report more than once, you build a pipeline and collaborate with engineers. Manual work at scale a a problem you fix, not a workflow you accept
You own accuracy personally - The analysis you produce informs employer decisions and executive strategy. You validate your work before it ships., document our logic, and flag uncertainty rather than hiding it
You think in systems, not outputs - A one-off analysis is the last resort. You collaborate to build data models and reporting infrastructure that answer categories of questions, not single requests
You are resourceful and self-directed - You do not wait to be fully briefed before making progress. You find the data, make reasonable assumptions, document them and deliver something useful while iterating towards perfect
You communicate what the data means, not what it says - You translate complex analytical outputs into clear business narratives for stakeholders who need to make decisions, not just consume numbers
Requirements
We’re excited about you because…
5+ years in business intelligence, analytics engineering, or data analytics, with a strong bias toward building automated, scalable solutions rather than one-off analysis.
Expert-level SQL: you write complex, optimized queries across large datasets, build reusable CTEs and modular logic, and think in terms of data models rather than query outputs.
Advanced Tableau skills: you build dashboards that people actually use, with attention to performance, usability, and visual clarity, not just technical correctness.
Hands-on experience with Snowflake and at least one other cloud warehouse or query engine such as Athena, BigQuery, or Redshift.
Real experience working with healthcare claims data: you understand CPT codes, diagnosis codes, episode structures, and the data quality challenges that come with claims, and you know how to work around them.
Python proficiency for analytics automation: you can write scripts to automate report generation, data validation, and pipeline orchestration without needing an engineer to do it for you.
A strong instinct for data quality and a track record of building validation checks, anomaly detection, and documentation into your work rather than treating them as afterthoughts.
Exceptional attention to detail and ability to manage interconnected numerical datasets
Strong organizational skills with ability to manage multiple projects simultaneously
Bachelor's degree in Business, Analytics, Statistics, or related field
Entrepreneurial and resourceful qualities — As an early member of a startup, we need people who can find creative ways to make a big impact quickly and without much direction.
Experience handling deadlines, keeping many balls in the air, and prioritizing work in a fast-paced, dynamic environment.
Passion for collaborating cross-functionally with sales, operations, client success, data, and product teams to ideate, complete projects, and drive impactful results.
What we offer
Other benefits:
Stock option plan
Flexible schedules and remote work
Chicago and San Francisco offices available
Self-managed vacation days, within reason
Paid parental leave
Health, vision, and dental insurance
401K retirement plan


.jpg)
.jpeg)
.jpeg)
.jpeg)



