Analytics Engineer

Responsibilities

• Build and maintain data models defining core business metrics like clinical outcomes, revenue, and utilization
• Own the semantic layer and sources of truth for the entire company
• Run dbt orchestration with integrated alerting, CI/CD pipelines, and data quality testing
• Stand up reverse ETL pipelines to feed modeled data back into production systems
• Implement and maintain HIPAA-compliant access controls for PHI

Requirements

• 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, or government)
• Experience with data orchestration tooling (dbt Cloud, Airflow, or similar)

Preferred Qualifications

• Familiarity with HIPAA regulations
• Proven ability to manage sensitive data and access controls

Benefits

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

About the Company

Counsel is building the first fully-vertical, AI-native medical group. We are redesigning the clinical stack with custom AI tools to multiply healthcare capacity, backed by over $35M from a16z, Google Ventures, and Pear VC.