Skip to content
Counsel HealthCounsel HealthNew York, NY

Analytics Engineer

Own the semantic layer by building and maintaining core dbt data models that serve as the single source of truth for business metrics, dashboards, and reverse ETL pipelines in a HIPAA-compliant environment. First analytics hire at a fast-growing AI-native healthcare company.

185k – 210k
Hybrid3+ YOEData Analytics

About the role

What You'll Do

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

What You'll Bring

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

Who You Are

  • 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.
  • Feels energized by creating structure in ambiguous, fast-moving environments, and can synthesize needs from multiple stakeholders into a clear data strategy.

What We Offer

  • Competitive salary + equity.
  • Comprehensive healthcare, vision + dental, 401K, Unlimited PTO, Parental Leave.

Skills

SQLdbtBigQuerySnowflakeRedshiftAirflowHIPAAReverse EtlCI/CDData ModelingPhi Access Controls

Similar roles

Data Analytics jobs
Thatch

Analytics Engineer

ThatchUnited States

Own data models, metrics, and dashboards that leadership, growth, finance, and operations rely on. Build dbt models, design BI dashboards, and enable self-serve analytics in a production environment.

160k – 190k
RemoteData Analytics
OpenAI

Analytics Engineer, Safety Systems

OpenAISan Francisco, CA

Build and maintain canonical safety datasets and self-serve dashboards that enable Engineering, Research, and Data Science teams to independently analyze safety metrics and inform product decisions.

210k – 260k
Hybrid5+ YOEData Analytics
Komodo Health

Manager, Analytics Services

Komodo HealthSan Francisco, CA +1

Manages team of analytics consultants delivering AI-enabled healthcare analytics projects, ensures client satisfaction through project execution and stakeholder collaboration. Requires 5-7 years in healthcare analytics, people management experience, and AI fluency.

152k – 195k
Remote5+ YOEData Analytics
Fivetran

Marketing Business Analyst

FivetranOakland, CA +1

Analyzes B2B marketing performance, owns ROI reporting, pipeline insights, and experimentation to optimize spend and drive revenue. Requires 5+ years in marketing/GTM analytics, strong SQL/BI skills, and SaaS metrics knowledge.

151k – 188k
Hybrid5+ YOEData Analytics
Shepherd

GTM Analytics & Strategy

ShepherdSan Francisco, CA

Analyzes GTM data across sales, pipeline, and operations to drive strategy, growth levers, and performance insights. Partners with leadership using SQL, BI tools, and Salesforce to deliver dashboards and recommendations. Requires 5+ years in analytics.

150k – 205k
On-site5+ YOEData Analytics