Jobs · Information Technology · New York

Analytics Engineer

Counsel Health · New York, NY · 1 wk ago
HybridInformation Technology$185k–$210k/yrFull-time

About the role

We've built a strong data foundation: a cloud warehouse, ETL pipelines, and event tracking are all in place. Now we need someone to make that data mean something.

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

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 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

Qualifications

  • Thinks in business entities and stakeholder questions, not just tables and joins, and turns fuzzy requirements into clean, well-modeled data
  • Treats dbt as a primary tool, writing clean, modular, well-tested transformations, with strong opinions about how a dbt project should be organized
  • Comfortable managing orchestration, environments, and reverse ETL pipelines without hand-holding, even without being a dedicated data engineer
  • Doesn't just model data, but asks why someone needs it and how it drives a patient or business outcome
  • Finds energy in creating structure in ambiguous, fast-moving environments, and can synthesize needs from multiple stakeholders into a clear data strategy

Skills

  • SQL
  • dbt
  • BigQuery or comparable cloud data warehouses (Snowflake, Redshift)
  • Data orchestration tooling (Paradigm, dbt Cloud, Airflow, or similar)
  • Access controls for PHI, HIPAA compliance

Benefits

  • Impact: Be at the forefront and contribute to groundbreaking, AI-driven healthcare experiences, directly interface with execs at the world's leading tech & healthcare orgs
  • Growth: Significant opportunities for broad ownership and professional development within our rapidly scaling startup
  • Compensation: Competitive salary + equity
  • Benefits: Comprehensive healthcare, vision + dental, 401K, Unlimited PTO, Parental Leave

Pay

$185K - $210K

Schedule

Hybrid, Boston - hybrid, or East Coast - remote

Similar jobs

Analytics Engineer

Traffic TechChicago, IL· 3 wk ago
Information Technologyapply on jobs.jobvite.com

Analytics Engineer

The Hillman GroupCincinnati, OH· 1 wk ago
Information Technologyapply on jobs.dayforcehcm.com

Analytics Engineer

CeligoUnited States· 6 days ago
RemoteInformation Technology$120k–$140k/yrapply on job-boards.greenhouse.io

Analytics Engineer

DoorDashSeattle, WA· 1 wk ago
Information Technology$118k–$173k/yrapply on job-boards.greenhouse.io

Analytics Engineer

PodiumLehi, UT· 2 wk ago
Information Technology$100/hrapply on job-boards.greenhouse.io

Analytics Engineer

Total Quality LogisticsCincinnati, OH· 5 mo ago
Information Technology$85k–$125k/yrapply on tql.avature.net