Staff Software Engineer, Data Warehouse

Pivotal Health
Santa Monica; Lower Manhattan, US
RemoteCareer-pivot friendly

Who this role is best for

Best suited to senior engineers with healthcare data expertise who thrive in architecting foundational data platforms.

Best fit for

  • Healthcare data veterans comfortable designing PHI-compliant warehouse architectures.
    — “Proven track record in implementing zero trust PHI architectures
  • Platform builders who balance immediate delivery with long-term scalability.
    — “Strong systems-thinking mindset with an ability to balance short-term execution and long-term scalability
  • Technical leads experienced in cross-functional healthcare data initiatives.
    — “Track record of leading technical initiatives spanning multiple teams

Things to consider

  • US work authorization required without employer sponsorship.
    — “Candidates must be authorized to work in the United States without current or future employer sponsorship
  • Core team hubs suggest occasional in-person expectations for remote hires.
    — “While we primarily hire around our core hubs–Los Angeles and New York–we remain open to exceptional talent outside those regions

How to stand out

  • Showcase healthcare data modeling experience beyond generic warehouse projects.
    — “Deep understanding of data modeling in a healthcare/clinical data setting
  • Highlight platform ownership in scaling environments, not just participation.
    — “Demonstrated ownership of critical infrastructure in high-growth environments
  • Emphasize bridging analytical and operational systems in past work.
    — “Experience designing systems that support both operational and analytical workloads
Pace · SteadyCollaboration · HighAutonomy · MediumDecision Impact · TeamLevel · Senior

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

  • successful data warehouse infrastructure
  • enhanced data governance
Typical background
data warehouse architecturecloud-based data solutions

Skills & requirements

Required

Data Warehouse ArchitectureCloud-based Data Warehouse SolutionsData ModelingData Governance

Preferred

Healthcare DataAi-driven Applications

Stack & domain

Data WarehouseCloud-based Data Warehouse SolutionsData ModelingData GovernanceAIMachine LearningSQLSalesforceBi ToolsLeadershipCollaborationProblem SolvingCommunicationHealthcareData InfrastructureData Platform

About the role

Original posting from Pivotal Health via Ashby

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. 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.

Pivotal Health combines software, data, and service into a seamlessly integrated, AI-driven platform that simplifies these complex reimbursement workflows. 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. We are building a state-of-the-art healthcare data platform that ingests, processes, and organizes complex healthcare information into trusted data assets. This role will lead the design and development of foundational platform capabilities that ensure data is reliable, scalable, secure, and accessible across the organization.

As a Staff Software Engineer focused on Data Warehouse infrastructure, you will architect the services, pipelines, and platform capabilities that power our healthcare data ecosystem. You'll work on ingestion frameworks, warehouse architecture, orchestration systems, metadata management, and data access patterns that enable both analytics and AI-driven applications.

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. 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. Partner with engineering, analytics, and product teams to align platform capabilities with business priorities.
  • Improve platform observability and reliability. Build monitoring, alerting, and operational tooling that ensures trust in critical data systems.

WHO YOU ARE

  • 8+ years building distributed software systems or large-scale data platforms.
  • 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 designing systems that support both operational and analytical workloads.
  • Track record of leading technical initiatives spanning multiple teams.
  • Strong systems-thinking mindset with an ability to balance short-term execution and long-term scalability.
  • Demonstrated ownership of critical infrastructure in high-growth environments.

NICE TO HAVES

  • Experience with Snowflake, Databricks, BigQuery, Redshift, or similar platforms.
  • Familiarity with AI and machine learning data platform requirements.

WHY YOU’LL LOVE WORKING HERE

We’re a collaborative, low-ego team on a mission to make healthcare reimbursement fairer for providers. While we primarily hire around our core hubs–Los Angeles and New York–we remain open to exceptional talent outside those regions. Remote and hybrid flexibility varies by role and team, and is outlined in each job description.

If you’re excited by solving complex problems and making a real-world impact, we’d love to hear from you.

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.

EMPLOYMENT INFORMATION

Work Authorization

Candidates must be authorized to work in the United States without current or future employer sponsorship.

Equal Employment Opportunity

Pivotal Health is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, gender identity or expression, sexual orientation, national origin, age, disability, veteran status, or any other legally protected status.

Reasonable Accommodations

Pivotal Health provides reasonable accommodations for qualified individuals with disabilities in accordance with applicable laws. If you need assistance during the application or interview process, please let us know.

Background Checks

Employment is contingent upon successful completion of applicable background checks, where permitted by law.

At-Will Employment

Employment with Pivotal Health is at-will and may be terminated by either party at any time, with or without cause or notice, in accordance with applicable law.

Source: Pivotal Health careers (Ashby)

Similar roles