Collective Health is transforming how employers and their people engage with their health benefits by seamlessly integrating cutting-edge technology, compassionate service, and world-class user experience design. The Data Engineering Platform team is responsible for building the foundational data systems that power Collective Health’s operations and insights. The Data Ingestion & Modeling team focuses specifically on transforming raw data into robust, trusted data warehouse models that serve as the single source of truth for downstream use.
Requirements
- 12+ years of experience as a data engineer or analytics engineer, with deep experience designing and building data warehouse models.
- Expertise in modern ELT pipelines, data modeling (especially dimensional models), and warehouse technologies like Snowflake, Databricks, or BigQuery.
- Strong proficiency in SQL and at least one programming language (e.g., Python or Scala).
- Experience working with orchestration tools such as Airflow or DBT to manage pipeline workflows.
- A strong sense of data governance, data quality, and testing best practices.
- Experience in healthcare or other regulated data environments is a plus, but not required.
Responsibilities
- Lead technical design and implementation of ingestion and transformation pipelines from various source systems into our centralized data warehouse.
- Develop, maintain, and evolve dimensional models (facts and dimensions) to support analytics, reporting, and data science.
- Partner with data analysts, product managers, and domain experts to ensure models are aligned with business needs and definitions.
- Review code, mentor teammates, and raise the bar on engineering quality and operational reliability.
- Own and improve the team’s ELT workflows, including orchestration, testing, observability, and CI/CD practices.
- Drive consistency and reuse across domains through shared data modeling patterns, frameworks, and tools.
- Help prioritize technical debt and contribute to long-term architecture decisions in collaboration with other data platform leads.
Other
- This is a key technical leadership role—not a people management role—that will shape how we transform raw data into clean, analytics-ready datasets.
- You’ll report to the Director of Data Engineering Platforms and work closely with peers across analytics, product, and operations to deliver data solutions that matter.
- A collaborative mindset with the ability to influence and guide peers through technical leadership, not management.
- This is a hybrid position based out of one of our offices: San Francisco, CA, Plano, TX, or Lehi, UT. Hybrid employees are expected to be in the office two days per week.
- Mission-driven culture that values innovation, collaboration, and a commitment to excellence in healthcare
