At Collective Health, we’re 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. Our team enables reliable, governed, and scalable data flows that support analytics, data science, and external reporting across the company. 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.As a Staff Data Engineer, you’ll lead the technical strategy and execution for the ingestion and modeling layer of our data platform.
You will work hands-on to design, build, and optimize data pipelines and dimensional models, while also setting technical direction and mentoring a small team of 2–4 data engineers. 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.
What you'll do:
- 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.
To be successful in this role, you'll need:
- 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.
- A collaborative mindset with the ability to influence and guide peers through technical leadership, not management.
- Experience in healthcare or other regulated data environments is a plus, but not required.
Pay Transparency Statement
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.#LI-hybridThe actual pay rate offered within the range will depend on factors including geographic location, qualifications, experience, and internal equity. In addition to the salary, you will be eligible for stock options and benefits like health insurance, 401k, and paid time off. Learn more about our benefits at https://jobs.collectivehealth.com/benefits/.San Francisco, CA Pay Range$194,670—$243,500 USDLehi, UT Pay Range$155,500—$194,000 USDPlano, TX Pay Range$171,000—$213,500 USD
Why Join Us?
- Mission-driven culture that values innovation, collaboration, and a commitment to excellence in healthcare
- Impactful projects that shape the future of our organization
- Opportunities for professional development through internal mobility opportunities, mentorship programs, and courses tailored to your interests
- Flexible work arrangements and a supportive work-life balance
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Collective Health is committed to providing support to candidates who require reasonable accommodation during the interview process. If you need assistance, please contact recruiting-accommodations@collectivehealth.com.
Privacy Notice
For more information about why we need your data and how we use it, please see our privacy policy: https://collectivehealth.com/privacy-policy/.
