Analytics Engineer

Counsel Health; New York (NY); On-site; USD 90,000 - 110,000; Full time

Benefits offered by this job

Competitive salary

Equity options

401k

Unlimited PTO

Free snacks and lunch

Job summary

A healthcare technology organization located in New York is seeking an experienced Analytics Engineer to define and manage the semantic data layer. You will build and maintain data models, run orchestration and ETL processes, and ensure data compliance with HIPAA standards. The ideal candidate has at least 3 years of experience in analytics, deep knowledge of SQL and dbt, and familiarity with cloud data warehouses like BigQuery. Competitive salary and benefits offered including unlimited PTO and professional development opportunities.

Qualifications

• 3+ years of experience in analytics engineering or data analytics.
• Deep expertise in SQL and dbt.
• Experience with BigQuery or comparable cloud data warehouses.
• Experience in a regulated industry managing sensitive data.

Responsibilities

• Own the semantic layer by building and maintaining core analytics data models.
• Run dbt orchestration with alerting, CI/CD, and data quality testing.
• Build reverse ETL pipelines for operational data flows.
• Implement access controls for PHI data to meet HIPAA compliance.

Skills

SQL

dbt

Data orchestration tools

Data compliance (HIPAA)

BigQuery or comparable cloud data warehouses

Job description

At Counsel Health, 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.

We're looking for an Analytics Engineer who will own the semantic layer of our data, building and maintaining the core analytics data models that the rest of the company will use to turn raw data into insights. You will be the person the company trusts to answer "how do we measure this?".

What You’ll Do

• Own the Semantic Layer: Build and maintain data models that define our core business metrics — from clinical outcomes to revenue to utilization. You will own the sources of truth for Counsel’s core metrics and ensure they can be reliably used throughout the company.
• 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.

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

Who You Are

• A Context Engineer: You think in business entities and stakeholder questions, not just tables and joins. You translate fuzzy requirements into clean, well‑modeled data.
• dbt + SQL Native: dbt is your primary tool. You write clean, modular, well‑tested transformations and you have strong opinions about how a dbt project should be organized.
• Infrastructure‑Comfortable: You're not a data engineer, but you can manage orchestration, environments, and reverse ETL pipelines without hand‑holding.
• Product‑Minded: You don't just model data — you ask why someone needs it and how it drives a patient or business outcome.
• Thrives in Ambiguity: We're a fast‑moving company with evolving data needs. You feel energized by creating structure in ambiguous environments, and you are comfortable synthesizing needs from multiple stakeholders into a clear data strategy.

What We Offer

• Impact: Be at the forefront of AI‑augmented care delivery, tackling some of the most ambitious challenges in healthcare.
• Growth: Professional development and leadership opportunities within a rapidly expanding tech‑enabled care delivery organization.
• Exposure: Gain hands‑on experience in scaling a fast‑growing healthcare technology company and directly interface with executives at the world’s leading healthcare organizations.
• Compensation: Competitive salary and equity options.
• Benefits: Competitive healthcare, vision, and dental, 401k, unlimited PTO, snacks and free lunch at the office.