Analytics Engineer, Care Operations

Francisco Partners; Columbus (OH); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical Insurance

Dental & Vision

401k

Job summary

AndHealth is seeking an Analytics Engineer to partner with the Care Delivery team, turning raw clinical and operations data into trusted metrics and dashboards. You will own metrics end-to-end from semantic layer definitions to daily dashboards, partnering with leadership to translate business decisions into measurable insights.

The role emphasizes dbt modeling, governance, and data quality, with collaboration across data, engineering, and product teams.

Qualifications

• 6+ years of data analysis or related experience with significant experience partnering directly with business stakeholders.
• Ability to translate ambiguous business questions into governed metric definitions.
• Strong SQL skills with complex queries, CTEs, window functions, and optimized transformations.

Responsibilities

• Translate business decisions into metrics and define governed metrics.
• Partner with multiple teams to generate actionable insights for partners and patients.
• Build dashboards and reports to visualize trends, drivers, and recommended actions across care operations and pharmacy.
• Develop the semantic layer in dbt with defined metrics and curated datasets for self-serve data products.
• Collaborate with Data and Software Engineering to flag data quality issues and shape transformations.
• Create a thorough testing suite across the data platform including schema tests and SLA monitoring.
• Support quarterly business reviews with value storytelling for clients.
• Become a domain expert in care operations and translate business logic into scalable dbt models.
• Proactively identify data quality gaps and opportunities to improve data reliability.

Skills

SQL proficiency

dbt experience

Data modeling

Stakeholder collaboration

Python/R

Education

Bachelor's degree (CS/Engineering/Math)

Tools

dbt

Looker

Excel

Job description

Analytics Engineer, Care Operations

Full Time - Exempt

Columbus, Ohio

AndHealth is on a mission to radically improve access and outcomes for the most challenging chronic health conditions, with the goal of making world-class specialty care accessible and affordable to all. We partner with health systems, community health centers, and independent practices to remove barriers to care to ensure all people have access to the care they deserve.

None of that happens without good data. Every model we build, every intervention we design, and every conversation our care teams have with a partner is only as strong as the data behind it. That's where you come in.

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-serve 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.

We are an equal opportunity and affirmative action employer. We embrace diversity and are committed to creating an inclusive environment for all employees. Applicants will be considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, disability, or veteran status.