About the job
At Counsel Health, we pride ourselves on our robust data infrastructure, which includes a cloud warehouse, ETL pipelines, and event tracking systems. We are now seeking an Analytics Engineer to transform this data into meaningful insights.
In this pivotal role, you will be responsible for developing and managing the semantic layer of our data, creating and maintaining the essential analytics data models that the organization relies on to convert raw data into actionable insights. You will become the go-to expert for answering critical questions like, "How do we measure this?"
Key Responsibilities
Own the Semantic Layer: Design and sustain data models that articulate our core business metrics—ranging from clinical outcomes to revenue and resource utilization. You will establish the definitive sources of truth for Counsel's primary metrics, ensuring their reliable application across the organization.
Orchestrate & Monitor: Execute dbt orchestration with integrated alerting, CI/CD pipelines, and data quality testing to proactively identify issues before they impact dashboards.
Build Reverse ETL Pipelines: Develop data flows that transport clean, structured data back to production systems, including cohort definitions, marketing intelligence, and operational features that rely on well-modeled warehouse data.
Manage Data Compliance: Enforce and oversee access controls for PHI data, guaranteeing that the data layer complies with HIPAA regulations while remaining user-friendly.
Qualifications
Minimum of 3 years of experience in analytics engineering, data analytics, or a related data role.
Proficiency in SQL and dbt.
Familiarity with BigQuery or similar cloud data warehouses (such as Snowflake or Redshift).
Experience in a regulated industry (healthcare, fintech, insurance, government) with demonstrated capability in managing sensitive data and access controls; familiarity with HIPAA is advantageous.
Experience with data orchestration tools (e.g., Paradigm, dbt Cloud, Airflow) and integrating analytics data back into production systems.
Who You Are
A Context Engineer: You think in terms of business entities and stakeholder inquiries, not just tables and joins, translating ambiguous requirements into well-structured data.

