Staff Data Engineer, Data Warehouse

Pivotal Health Inc.

Job Overview

Location

Remote - NY

Job Type

Full-time

Full Job Description

📋 Description

• Own end-to-end development and maintenance of reliable data pipelines that ingest, transform, and deliver healthcare data across the organization to support analytics and evidence generation.
• Design scalable data warehouse models and schemas that enable accurate reporting, clinical analytics, and reimbursement evidence generation.
• Lead data transformation strategy by establishing standardized frameworks and best practices for consistency, maintainability, and performance across all data assets.
• Implement data quality controls including validation rules, reconciliation processes, monitoring systems, and alerting mechanisms to ensure trust in critical datasets.
• Integrate new clinical and claims data sources into the central data warehouse ecosystem, ensuring compatibility and structural integrity.
• Optimize data warehouse performance by improving query efficiency, reducing storage costs, and enhancing processing speed as data volumes scale.
• Partner with software engineers, analytics teams, and business stakeholders to translate complex business questions into durable, actionable data solutions.
• Develop tooling and operational processes that automate manual tasks, increase system reliability, and reduce technical debt.
• Mentor junior data engineers and analysts by sharing technical expertise, promoting data engineering standards, and elevating team-wide technical capabilities.
• Ensure all data infrastructure supports compliance with healthcare data handling requirements and enables reproducible, auditable analytical workflows.
• Contribute to the strategic evolution of Pivotal Health’s clinical data platform by influencing architecture decisions that align with long-term business goals.
• Maintain documentation for data models, pipeline logic, and operational procedures to ensure knowledge transfer and system sustainability.
• Collaborate across teams to define data requirements for machine learning and LLM-enabled workflows, ensuring data readiness and quality.
• Drive operational excellence by identifying bottlenecks in data workflows and implementing scalable solutions that reduce dependency on manual intervention.

🎯 Requirements

• 8+ years of 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

🏖️ Benefits

• 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

Skills & Technologies

Python

Senior

Remote

Ready to Apply?

Apply Externally

You will be redirected to an external site to apply.

AI Job Fit Analysis

Pro

See exactly how your profile matches this role — strengths, skill gaps, and what to do about them.

Pivotal Health Inc.

Visit Website

About Pivotal Health Inc.

Pivotal Health is a health technology company focused on improving the healthcare experience for patients and providers. They offer a platform designed to streamline administrative tasks, enhance patient engagement, and provide data-driven insights for healthcare organizations. Their solutions aim to reduce costs, improve efficiency, and ultimately lead to better health outcomes. Pivotal Health operates within the digital health and health IT sectors, leveraging technology to address challenges in healthcare delivery and management. The company is committed to innovation and creating a more connected and accessible healthcare ecosystem.

View Company Profile

Get more remote jobs like this

Subscribe to the weekly newsletter for similar remote roles and curated hiring updates.

Weekly remote jobs and featured talent.

No spam. Only curated remote roles and product updates. You can unsubscribe anytime.