Counsel Health Logo

Counsel Health

Analytics Engineer

Reposted 15 Hours Ago
Hybrid
Boston, MA, USA
185K-210K Annually
Mid level
Hybrid
Boston, MA, USA
185K-210K Annually
Mid level
Owner of the semantic layer: build and maintain core data models and metrics, run dbt orchestration with CI/CD and testing, implement reverse ETL pipelines, and enforce PHI access controls to keep data HIPAA-compliant.
The summary above was generated by AI
About Counsel

Counsel’s mission is to multiply the world's healthcare capacity. We believe in a future in which every person has a personalized, AI-enabled doctor always in their pocket. To accomplish this, we’re building the first fully-vertical, AI-native medical group from the ground up. We’ve 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 (MIT, Google, DeepMind, NVIDIA, Stripe, Meta) — and we’re looking for exceptional people to join us as we scale.


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

-----------------------------------------------------

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.

We're looking for an Analytics Engineer to own the semantic layer, building and maintaining the core data models the rest of the company relies on to turn raw data into insight. You'll be the person everyone trusts to answer "how do we measure this?"

You'll be our first dedicated analytics hire, which means you set the standards, choose the patterns, and shape how Counsel uses data for years to come. The infrastructure is built, the warehouse is running, and the company is growing. What's missing is the person who makes the data layer actually work, turning raw tables into the trusted models that power every dashboard, every data product, and every strategic decision.

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

Role location:

NYC - hybrid, Boston - hybrid, or East Coast - remote

What We Offer
  • 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

-----------------------------------------------------

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

Counsel’s mission is to multiply the world's healthcare capacity. We believe in a future in which every person has a personalized, AI-enabled doctor always in their pocket. To accomplish this, we’re building the first fully-vertical, AI-native medical group from the ground up. We’ve 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 we’re 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 @
counselhealth.com 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 [email protected].

#LI-PINJOB

Recruitment Fraud Notice. Counsel Health only communicates with candidates using official @counselhealth.com 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 [email protected].

 

Counsel Health participates in E-Verify. All newly hired employees are processed through the E-Verify system to confirm employment eligibility.

Similar Jobs

2 Days Ago
In-Office or Remote
United States
150K-300K Annually
Senior level
150K-300K Annually
Senior level
Healthtech • Social Impact • Telehealth
Build Sailor Health’s foundational data platform from scratch. Responsibilities include developing Snowflake and dbt pipelines integrating EHR, CRM, and communications data; creating data-powered web applications; automating clinical and billing workflows with Python; analyzing therapy transcripts and patient data using AI and machine learning; tracking clinical outcomes; and designing scalable data architectures in collaboration with clinicians, engineers, founders, and other teams.
Top Skills: DbtFhirGraphQLPythonRest ApisSnowflakeSQL
11 Days Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
150K-190K Annually
Senior level
150K-190K Annually
Senior level
Marketing Tech • Real Estate • Software • PropTech • SEO
Build and scale the analytics foundation: own dbt projects and Snowflake warehouse, create trusted datasets and semantic layers for AI, build ELT pipelines from APIs, implement testing/observability and CI/CD, design reconciliation models, enable stakeholder self-service, and partner cross-functionally to drive data-driven decisions across GTM, Product, Finance, People, and Operations.
Top Skills: BigQueryCi/CdDbtDbt Semantic LayerGitMixpanelPosthogPythonRedshiftSalesforceSnowflakeSnowflake CortexSQL
17 Days Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
140K-160K Annually
Senior level
140K-160K Annually
Senior level
AdTech • Agency • Artificial Intelligence • Digital Media • Marketing Tech • Social Media • PropTech
Own Silver and Gold medallion-layer modeling and semantic layer governance using dbt and SQL. Improve warehouse performance and cost, standardize BI tooling, collaborate with stakeholders to produce trusted metrics, troubleshoot data quality, and evolve analytics platform.
Top Skills: Ai-Assisted Development ToolsBigQueryCubeDataformDbtDbt Semantic LayerFivetranGitHexLightdashLookerLookmlMetabaseMetricflowOmniPrefectPythonReverse EtlSigmaSnowflakeSQLSqlmeshTableau

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account