About The Role

What You’ll Be Working On

• Primarily focus on architecting our data infrastructure layer that drives our financial, clinical, and AI applications
• Build robust batch and streaming ingestion pipelines that unify data from diverse internal and external systems into a consistent, ontology-driven data model
• Maintain dbt-driven SQL models that unify datasets from our product, integrations, financial operations and clinical data, leveraging ontologies (e.g. SNOMED CT, ICD, HL7 FHIR)
• Design data pipelines that handle diverse sets of structured (e.g. SQL, APIs) and unstructured (e.g., documents, notes, embeddings) datasets
• Future-proof the data platform to anticipate and support evolving needs including:
  • AI workflows such as NLP, embeddings, knowledge graphs, and retrieval-augmented generation
  • Financial workflows for accounting tracking and observability
  • Clinical and support workflows that allow non-technical teams to self-service data

Examples of projects you may work on

• Build real-time PHI-scrubbed operational dashboards to support clinical and support teams; allowing non-technical users to self-service data using AI-supported tooling
• Set up change data capture (CDC) to store historical data and allow engineers and analysts to time travel back to a past state of the system
• Build reverse ETL infrastructure to bring analytically derived data into our core application to drive patient engagement
• Improve our financial modeling, marketing data analysis, customer acquisition and user retention metrics
• Analyze our LLM performance & latency metrics and model how this impacts costs, user experience, and potential caching strategies

Requirements

• 5+ years of experience in data engineering building high-performance data pipelines
• Previously pioneered self-service analytics & business intelligence tooling (e.g. Hex, Sigma, Looker) for a diverse set of stakeholders
• Operational experience with data storage platforms (e.g. Databricks, Iceberg, or Snowflake) and analytical query engines (e.g. Athena or Presto)
• Managed job orchestration (e.g. Dagster, Airflow) and semantic data modeling (dbt, SQL)
• 2+ years working in highly regulated industries such as healthcare or financial services, including implementing row-level security and data masking for PHI/PII use cases
• Deep familiarity with row and columnar data warehouses (e.g. PostgreSQL, BigQuery, Snowflake)
• Opinionated about data architecture, data modeling, and analytics in a fast-growing environment

You are a great fit if

• Hands-on experience architecting data platforms from day 0 in a fast-paced, high-growth environment
• Extensive work with healthcare data and standards (e.g. HL7 FHIR, CDS, ICD-10)
• Experience with our tech stack: AWS, Google Cloud, PostgreSQL, FHIR servers
• Ability to flex into data infrastructure, semantic modeling, and operational analytics
• Knowledge of medical statistics and eagerness to learn more
• Comfortable working across teams on multi-stakeholder projects and thriving in collaborative environments

What we offer

• Impact: Contribute to AI-driven healthcare experiences and interface with execs at leading tech & healthcare organizations
• Growth: Significant opportunities for broad ownership and professional development
• Compensation: Competitive salary + equity
• Benefits: Comprehensive healthcare, vision + dental, 401K, Unlimited PTO, Parental Leave

Our Values

• Patients come first. We act with patient trust and safety at the center of every decision.
• Innovate with optimism. Challenge the status quo when needed.
• Right answer wins. Debate openly and pick the strongest path; optimize for the company.
• Simplicity over complexity. Choose clear, elegant solutions.
• Do fewer things, well. Focus and pursue excellence in those areas.

About Counsel