Analytics Engineer

Counsel Health

Analytics Engineer responsible for core business metrics data modeling and orchestration at Counsel Health. Collaborating across teams to ensure data compliance and reliability in healthcare technology.

Posted 4/15/2026full-timeNew York City • New York • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

AirflowAmazon RedshiftBigQueryCloudETLSQL

About the role

Key responsibilities & impact

Own the Semantic Layer: Build and maintain data models that define our core business metrics — from clinical outcomes to revenue to utilization.
Orchestrate & Monitor: Run dbt orchestration with integrated alerting, CI/CD pipelines, and data quality testing to catch issues before they reach dashboards.
Build Reverse ETL Pipelines: Stand up the data flows that feed clean, modeled data back into production systems — population cohort definitions, marketing intelligence, and operational features that depend on well-modeled warehouse data.
Own Data Compliance: Implement and maintain access controls for PHI data, ensuring the data layer meets HIPAA requirements while remaining accessible.

Requirements

What you’ll need

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 proven ability to manage sensitive data and access controls. HIPAA familiarity is a plus.
Experience with data orchestration tooling (Paradigm, dbt Cloud, Airflow, or similar), and integrating analytics data back into production systems

Benefits

Comp & perks

Competitive healthcare, vision, and dental
401K
Unlimited PTO
Snacks and free lunch at the office

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdbtdata modelingdata quality testingReverse ETLCI/CD pipelinesdata orchestrationdata analyticsanalytics engineeringdata flows