Staff Software Engineer, Data Warehouse

Pivotal Health

Staff Software Engineer developing and architecting data warehouse solutions for healthcare reimbursement. Focused on building scalable infrastructure and data governance frameworks.

Posted 6/12/2026full-timeRemote • New York • 🇺🇸 United StatesLead💰 $210,000 - $240,000 per yearWebsite

Tech Stack

Tools & technologies

CloudPythonSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data architecturedata modelingcloud-based data warehousebackend engineeringdata lifecycle managementPythonSQLzero trust PHI architectureoperational workloadsanalytical workloads

Soft Skills

leadershipcross-functional collaborationsystems thinkingproblem-solvingcommunication