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