Staff Software Engineer, Data Warehouse

United StatesHybrid

Responsibilities

Design and evolve the systems that support storage, transformation, governance, and access across clinical datasets. - Build scalable data infrastructure.
Develop a secure and compliant warehouse infrastructure. - Healthcare-specific data modeling: Design and build clinical data models inside a scalable warehouse solution. - Design warehouse optimization strategies.
Create data models and storage approaches that balance performance, scalability, and maintainability. - Establish data governance frameworks.
Implement controls that ensure data quality, consistency, security, and auditability. - Enable downstream analytics and AI workloads.
Build infrastructure that supports reporting, evidence generation, and machine learning applications. - Lead cross-functional technical initiatives.
Build monitoring, alerting, and operational tooling that ensures trust in critical data systems.

Pivotal Health combines software, data, and service into a seamlessly integrated, AI-driven platform that simplifies these complex reimbursement workflows.
You'll work on ingestion frameworks, warehouse architecture, orchestration systems, metadata management, and data access patterns that enable both analytics and AI-driven applications.
Experience in healthcare, health tech, or regulated data environments. -
Experience architecting modern cloud-based data warehouse solutions. - Strong proficiency in backend engineering and platform development. - Deep understanding of data modeling in a healthcare/clinical data setting, storage architecture, and data lifecycle management. - Strong proficiency in Python and SQL, or similar backend languages. - Proven track record in implementing zero trust PHI architectures. -
Experience with Snowflake, Databricks, BigQuery, Redshift, or similar platforms. - Familiarity with AI and machine learning data platform requirements.

WHO YOU ARE - 8+ years building distributed software systems or large-scale data platforms. -

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 investing in modern healthcare data infrastructure as a strategic capability.
This role will lead the design and development of foundational platform capabilities that ensure data is reliable, scalable, secure, and accessible across the organization.
This is an opportunity for an engineer who enjoys building foundational platforms that become critical company infrastructure.
You'll have significant influence over architecture, technology choices, and long-term platform strategy while working on meaningful problems in healthcare.
WHAT YOU’LL DO - Own warehouse platform architecture.
Partner with engineering, analytics, and product teams to align platform capabilities with business priorities. - Improve platform observability and reliability.