Analytics Engineer, Care Operations

AndHealth•Columbus, OH

47d

About The Position

The Analytics Engineer will serve as the dedicated data partner to the Care Delivery team, turning raw clinical and operational data into trusted metrics, dashboards, governed models, and data products. The role is embedded close to Care Delivery and combines hands-on work with dbt and SQL with stakeholder engagement, including translating data findings for leaders and helping them decide what to do next. The work supports how AndHealth delivers care to patients managing chronic conditions. The Analytics Engineer will own their assigned care operations domain end to end, from metric definitions in the semantic layer through reporting and dashboards, and will help make data reliable and accessible for analysts, stakeholders, partners, and patients’ care teams.

Requirements

Bachelor’s degree in Computer Science, Economics, Engineering, Mathematics, or a related quantitative field, or equivalent practical experience.
At least 6 years of data analysis or related experience, including significant experience partnering directly with business stakeholders.
Ability to turn ambiguous business questions into concrete, governed metric definitions and lead stakeholder discovery conversations.
Strong analytical skills, including interrogating data, identifying anomalies, tracing issues to their source, and communicating findings to technical and non-technical audiences.
Strong SQL proficiency, including complex queries, CTEs, window functions, and performance-optimized transformations across large datasets.
Comfort working with a dimensionally modeled warehouse, including facts, dimensions, mart layers, and staging, intermediate, and mart transformations.
Experience creating reporting systems and visualizations, with advanced experience in Excel and other data systems.
Comfort working alongside ETL/ELT pipelines and partnering with data or software engineers on ingestion.
Advanced data modeling experience, including designing non-trivial dbt/SQL models that encode business logic.
Comfort working in ambiguous, fast-moving environments with competing priorities.

Nice To Haves

Hands-on experience with dbt Core or Cloud.
Experience with a BI tool such as Omni, Looker, Metabase, or similar, especially defining governed metrics and data products.
Familiarity with healthcare data, such as clinical, pharmacy, billing, or claims data from EHRs, TPAs, or pharmacy operating systems.
Experience with R, Python, or another scripting language in data analysis work.

Responsibilities

Translate business decisions into governed metrics by working with stakeholders to understand their decisions and data needs.
Partner with stakeholders across several teams to generate actionable insights that improve AndHealth’s value to partners and patients.
Build internal and external reporting and dashboards covering pharmacy and care operations, including what is happening, why, and potential next steps.
Develop the semantic layer in dbt, including governed metric definitions, curated datasets, and self-service data products.
Partner with Data and Software Engineering as a consumer of raw data; flag upstream data quality issues and gaps, and help shape staging transformations.
Build a testing suite across the data platform, including schema tests, data quality checks, anomaly detection, and SLA monitoring.
Partner with the client management team to develop the value story for quarterly business reviews.
Become a care operations domain expert and translate business logic into accurate, scalable dbt data models.
Identify data quality issues, gaps in coverage, and opportunities to improve the reliability and usability of the data platform.