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

Were 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 Youll 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 Counsels 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 Youll 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: Youre not a data engineer but you can manage orchestration environments and reverse ETL pipelines without hand-holding.

• Product-Minded: You dont just model data you ask why someone needs it and how it drives a patient or business outcome.

• Thrives in Ambiguity: Were 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.

Location for this role:

NYC - hybrid Boston - hybrid East Coast - remote

Why Counsel

Counsel Health is on a mission to multiply the worlds healthcare capacity. Were building the first fully-vertical AI-native medical group from the ground up with custom AI tools that make our in-house physicians 10x faster and smarter backed by over $35M from a16z and top-tier VCs and on pace to 5x revenue this year.

The infrastructure is built. The data warehouse is running. The company is growing. Whats missing is the person who makes the data layer actually work who turns raw tables into the trusted models that power every dashboard every data product and every strategic decision. Youll be the first dedicated analytics hire which means you define the standards choose the patterns and shape how Counsel Health uses data for years to come.

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

Our Values

• Patients come first.
  We are clinicians 1st technologists 2nd. We act with patient trust/safety at the center of every decision.

• Innovate with optimism.
  We are optimistic as we build the future of care delivery from first principles. Challenge the status quo when needed no sacred cows.

• Right answer wins.
  Debate openly and pick the strongest path. We optimize for the company not functions. We win and lose as a team.

• Simplicity over complexity.
  We choose clear elegant solutions and avoid adding complexity that does not serve patients or the team.

• Do fewer things well.
  We focus and hold ourselves to the highest bar and pursue excellence in those areas.

About Counsel

Counsels mission is to multiply the worlds healthcare capacity. We believe in a future in which every person has a personalized AI-enabled doctor always in their pocket. To accomplish this were building the first fully-vertical AI-native medical group from the ground up. Weve redesigned the entire clinical stack with custom AI tools that make our in-house physicians 10x faster and smarter. learn more on our blog

Since our founding in 2023 we have formed partnerships with leading healthcare organizations and are on track to serve hundreds of thousands of patients on our platform within the next year. We have raised over $35M from a16z Google Ventures Pear VC and other top-tier VC firms.

Our team combines deep expertise in medicine (Harvard Mt. Sinai Mass General UCSF) and technology (Google DeepMind NVIDIA MIT Stripe) and were looking for exceptional people to join us as we scale.

Join us as we build the future of AI in healthcare!

Recruitment Fraud Notice
Counsel Health only communicates with candidates using official @ email addresses. We will never ask for payment or financial information during the interview process. If you receive suspicious outreach claiming to be from Counsel Health please contact us at .

#LI-PINJOB

Required Experience:

IC