Analytics Engineer, Care Operations

Full Time - Exempt

Columbus, Ohio

About the role

We're looking for an Analytics Engineer to be the dedicated data partner to our Care Delivery team - the people on the front lines of getting patients into care and keeping them there. You'll take raw clinical and operations data and turn it into something a care leader can actually use: a trusted number on a dashboard, a governed metric everyone agrees on, a model that surfaces a problem before it becomes a crisis.

This is an embedded data partner role that sits close to Care Delivery. You'll be just as comfortable deep in a dbt model or a gnarly SQL query as you are in a room with a VP, translating what the data means and what to do about it. If you like owning a domain end to end - from the metric definition in the semantic layer to the dashboard a leader checks every morning - this role is for you.

Impact

The dashboards and data products you build will directly shape how AndHealth delivers care to thousands of patients managing chronic, often life-altering conditions. When you catch a data quality issue before it reaches a report, you're protecting the integrity of decisions that affect real people's access to care. When you build the semantic layer that lets an analyst self-serve a trusted metric instead of waiting on you, you're multiplying the entire team's ability to act. This isn't dashboards for dashboards' sake - it's the infrastructure that lets Care Operations see what's working, fix what isn't, and prove the value we bring to the partners and patients who depend on us.

What you'll do:

• Translate business decisions into metrics - work with stakeholders to understand the decision they're trying to make, help them articulate what they need, and define the governed metric that answers it.
• Partner with stakeholders from several teams to generate actionable insights that improve AndHealth's value to our partners and patients.
• Build internal and external reporting and dashboards that visualize what's happening, why it's happening, and what we should do next across pharmacy and care operations.
• Develop the semantic layer in dbt - defining governed metric definitions, curated datasets, and self-service data products that analysts and stakeholders can consume directly.
• Partner with Data and Software Engineering as a key consumer of the raw data - flagging upstream data quality issues and gaps, and helping shape staging transformations so data arrives in a usable form.
• Build a thorough testing suite across the data platform: schema tests, data quality checks, anomaly detection, and SLA monitoring so stakeholders can trust what they see.
• Partner with the client management team to build the value story for quarterly business reviews.
• Become a domain expert in your assigned area (care operations), translating business logic into accurate, scalable dbt data models.
• Proactively identify data quality issues, gaps in coverage, and opportunities to improve the reliability and usability of the data platform.

Education & Licensure Requirements:

• Bachelor's degree in Computer Science, Economics, Engineering, Mathematics, or a related quantitative field, or equivalent practical experience.

Other Skills or Qualifications:

• 6+ years of data analysis or related experience with significant experience partnering directly with business stakeholders.
• Proven ability to turn ambiguous business questions into concrete, governed metric definitions - comfortable leading the discovery conversation with stakeholders rather than just executing a spec.
• Strong analytical instincts - able to interrogate data, identify anomalies, trace them to their source, and communicate findings clearly to technical and non-technical audiences.
• Strong SQL proficiency - complex queries, CTEs, window functions, and performance-optimized transformations across large datasets.
• Hands-on experience with dbt (Core or Cloud) - preferred.
• Comfortable working within a dimensionally modeled warehouse - facts and dimensions, mart layers, and why transformations are separated into staging, intermediate, and mart layers - even if you haven't owned that architecture from the ground up.
• Experience creating reporting systems and visualizations; advanced experience with Excel and other data systems.
• Comfort working alongside ETL/ELT pipelines and partnering with data or software engineers on ingestion.
• Experience with a BI tool (Omni, Looker, Metabase, or similar), especially defining governed metrics and data products - preferred.
• Familiarity with healthcare data (clinical, pharmacy, billing, or claims from EHRs, TPAs, or pharmacy operating systems) - preferred.
• Advanced data modeling experience - designing non-trivial dbt/SQL models that encode real business logic.
• Experience with R or Python or another scripting language in data analysis work - preferred.
• Comfort working in ambiguous, fast-moving environments with competing priorities.

Here's what we'd like to offer you:

• Equal investment and support for our people and patients.
• A fun and ambitious growing environment with a culture that takes on important things, takes risks, and learns quickly.
• The ability to demonstrate creativity, innovation, and conscientiousness, and find joy in working together.
• A team of highly skilled, incredibly kind, and welcoming employees, every one of whom has something unique to offer.
• We know that the overall success of our business is a collaborative effort, and we strive to provide ongoing opportunities for our employees to learn and grow, both personally and professionally.
• Full-time employees are eligible to participate in our benefits package which includes Medical, Dental, Vision Insurance, Paid time off, Short- and Long-Term Disability, 401k match and more.