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