Analytics Engineer

Counsel Health
New York, Boston
Workplace: HybridFull timeUSD 185,000 - 210,000 annuallyFunction: Data Analytics & Business IntelligenceExperience: 3+ yearsSkills: ["Turning ambiguous requirements into clean models","Stakeholder-focused thinking","Writing clean modular transformations","Managing data environments and pipelines","Synthesizing data strategy from multiple stakeholders"]

Own the semantic layer by building and maintaining the core data models that power clinical outcomes, revenue, and utilization metrics. Serve as the first dedicated analytics hire, setting standards and shaping how the company uses data. Run dbt orchestration with CI/CD and quality testing, build reverse ETL pipelines to production systems, and implement PHI access controls to keep the data layer HIPAA-compliant.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Counsel Health
Counsel Health
2 months ago

Analytics Engineer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 16 hours agoStatus: Live

Job Summary

Own the semantic layer by building and maintaining the core data models that power clinical outcomes, revenue, and utilization metrics. Serve as the first dedicated analytics hire, setting standards and shaping how the company uses data. Run dbt orchestration with CI/CD and quality testing, build reverse ETL pipelines to production systems, and implement PHI access controls to keep the data layer HIPAA-compliant.
Location: New York, Boston
Workplace: Hybrid
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence
Seniority: Mid level

Key Responsibilities

  • •Build and maintain data models defining core business metrics and sources of truth.
  • •Run dbt orchestration with integrated alerting, CI/CD pipelines, and data quality testing.
  • •Stand up reverse ETL pipelines feeding clean, modeled data back into production systems.
  • •Implement and maintain access controls for PHI to keep the data layer HIPAA-compliant.
  • •Set standards and patterns for how the company uses data as the first dedicated analytics hire.

Pay and Benefits

Salary: USD 185,000 - 210,000 annually
Equity and Bonus:Equity
Perks:Health InsuranceVisionDental401kPaid LeaveParental Leave

Key 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 HIPAA familiarity a plus.
  • •Experience with data orchestration tooling (Paradigm, dbt Cloud, Airflow, or similar) and integrating analytics data back into production systems.
Experience:3+ yearsHealthcareRegulated industryAnalytics engineering
Skills:Turning ambiguous requirements into clean modelsStakeholder-focused thinkingWriting clean modular transformationsManaging data environments and pipelinesSynthesizing data strategy from multiple stakeholders
Tech Stack:SQLDbtBigQuerySnowflakeRedshiftParadigmDbt CloudAirflowETLReverse ETLCI/CD

Company Brief

Counsel Health
AI-enabled, physician-supervised virtual care company that provides an enterprise-grade front door to healthcare for payers, employers, and partners, combining medical AI with in-house physicians to deliver immediate, personalized medical guidance and reduce high-cost claims.
Industry: HealthTech
Company Size: Small (11 to 50 employees)
Growth: Growth Stage Startup
Funding: Series A
Headquarters: San Francisco, United States
Founded: 2023
WebsiteLinkedIn