Analytics Engineer
Counsel Health
full-time
Posted on:
Location Type: Hybrid
Location: New York City • New York • United States
Visit company websiteExplore more
About the role
- 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
- 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
- Competitive healthcare, vision, and dental
- 401K
- Unlimited PTO
- Snacks and free lunch at the office
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