Staff Data Engineer, Data Warehouse

United StatesHybrid

Responsibilities

Build and maintain reliable pipelines that ingest, transform, and deliver healthcare data across the organization. - Design warehouse data models.
Create scalable schemas and data structures that support analytics, reporting, and evidence generation. - Lead data transformation strategy.
Establish frameworks and standards that improve consistency, maintainability, and performance. - Ensure data quality and trust.
Implement validation, reconciliation, monitoring, and alerting processes across critical datasets. - Support clinical data integration initiatives.
Improve query efficiency, storage utilization, and processing costs as data volumes grow. - Partner with stakeholders on data requirements.
Develop tooling and processes that increase reliability and reduce manual intervention. - Mentor data engineers and analysts.

Pivotal Health combines software, data, and service into a seamlessly integrated, AI-driven platform that simplifies these complex reimbursement workflows.
experience building production data pipelines and warehouse solutions. - Deep expertise in SQL and modern data transformation frameworks and Python. -
Experience working with large-scale analytical databases and cloud data platforms. - Strong understanding of data modeling, ETL/ELT design, and data lifecycle management. -
Experience supporting business-critical reporting or analytical workloads. - Proven ability to improve data reliability and operational maturity. - Comfortable navigating ambiguity and helping define solutions where
Experience working with healthcare data, claims data, or clinical records. - Familiarity with healthcare interoperability standards such as FHIR or HL7. -
Experience supporting machine learning or LLM-enabled data workflows.

ABOUT PIVOTAL HEALTH Pivotal Health is the leading technology platform that helps healthcare providers get paid fairly in an increasingly complex reimbursement landscape.
Today, many providers face persistent underpayment from health insurance companies, despite delivering high-quality care.
Benefits Include: - Competitive compensation, including equity - Full health, dental, and vision coverage - Retirement savings plan through 401(k) - Flexible time off - Opportunities for company-wide connection and events Ready to Make an Impact? We’re building something meaningful; and we want you on the team.
Bring your ideas, curiosity, and drive, and let’s transform healthcare reimbursement together.
Equal Employment Opportunity Pivotal Health is an Equal Opportunity Employer.

While processes like IDR (Independent Dispute Resolution) were designed to promote fairness, they’re often administrative-heavy, time-consuming, and difficult to navigate without the right tools.
We help providers efficiently dispute underpaid claims, reduce administrative burden, and recover the reimbursement they’re entitled to; without adding more work to already stretched teams.
Our full-service IDR solution is just the starting point.
We’re building solutions that enable providers to operate with clarity, control, and confidence across the reimbursement journey.
ABOUT THE ROLE Pivotal Health is building a clinical data platform to generate stronger evidence on behalf of providers.
As our data footprint grows, we need dedicated data engineering leadership to build reliable pipelines, trusted datasets, and scalable warehouse infrastructure.
This role exists to ensure that data becomes a strategic asset rather than a collection of disconnected systems.
As a Staff Data Engineer, you will help design and implement data pipelines, warehouse models, transformation frameworks, and operational processes that support analytics and evidence generation.
You will work closely with software engineers, analytics teams, and business stakeholders to ensure data is accurate, accessible, and actionable.
This role is well suited for someone who enjoys turning complex data ecosystems into simple, reliable platforms.