Note: The job is a remote job and is open to candidates in USA. Counsel Health is on a mission to multiply the world's healthcare capacity by building an AI-native medical group. They are seeking an Analytics Engineer to own the semantic layer and build data models that transform raw data into insights, playing a crucial role in shaping how the company utilizes data.

Responsibilities

• Build and maintain the data models that define our core business metrics, from clinical outcomes to revenue to utilization, and own the sources of truth the whole company relies on
• Run dbt orchestration with integrated alerting, CI/CD pipelines, and data quality testing that catches issues before they reach a dashboard
• Stand up reverse ETL pipelines that feed clean, modeled data back into production systems, including population cohort definitions, marketing intelligence, and operational features
• Implement and maintain access controls for PHI, keeping the data layer HIPAA-compliant while staying accessible to the people who need it

Skills

• 3+ years of experience in analytics engineering, data analytics, or a hybrid data role
• Deep expertise in SQL and dbt
• Experience with BigQuery or comparable cloud data warehouses (Snowflake, Redshift)
• Experience working in a regulated industry (healthcare, fintech, insurance, government) with a proven ability to manage sensitive data and access controls, HIPAA familiarity a plus
• Experience with data orchestration tooling (Paradigm, dbt Cloud, Airflow, or similar) and integrating analytics data back into production systems

Benefits

• Equity
• Comprehensive healthcare, vision + dental
• 401K
• Unlimited PTO
• Parental Leave

Company Overview