Staff Data Engineer, Data Warehouse at Pivotal Health | Torre
warning

Heads-up

The job you’re trying to post already exists in Torre:

Staff Data Engineer, Data Warehouse

You'll build a strategic clinical data platform, ensuring fair healthcare reimbursement through reliable data.
Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time

Legal agreement: Employment

Compensation
USD200k - 230k/year
location_on
Remote (for United States residents)
Match
skeleton-gauges
You have opted out of job matches in .
To undo this, go to the 'Skills and Interests' section of your preferences.
Review preferences
Shared by
Emma of Torre.ai
about 20 hours ago

Requirements and responsibilities


About Pivotal HealthPivotal 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 RolePivotal Health is building a clinical data platform to generate stronger evidence on behalf of providers. As our data footprint grows, we need dedicated data engineering leadership to build reliable pipelines, trusted datasets, and scalable warehouse infrastructure. This role exists to ensure that data becomes a strategic asset rather than a collection of disconnected systems.As a Staff Data Engineer, you will help design and implement data pipelines, warehouse models, transformation frameworks, and operational processes that support analytics and evidence generation. You will work closely with software engineers, analytics teams, and business stakeholders to ensure data is accurate, accessible, and actionable.This role is well suited for someone who enjoys turning complex data ecosystems into simple, reliable platforms. You'll have the opportunity to influence both architecture and execution while helping shape how Pivotal leverages healthcare data in the future.What You’ll DoOwn data pipeline development. Build and maintain reliable pipelines that ingest, transform, and deliver healthcare data across the organization.Design warehouse data models. Create scalable schemas and data structures that support analytics, reporting, and evidence generation.Lead data transformation strategy. Establish frameworks and standards that improve consistency, maintainability, and performance.Ensure data quality and trust. Implement validation, reconciliation, monitoring, and alerting processes across critical datasets.Support clinical data integration initiatives. Help incorporate new clinical data sources into the warehouse ecosystem.Optimize warehouse performance. Improve query efficiency, storage utilization, and processing costs as data volumes grow.Partner with stakeholders on data requirements. Translate business questions into durable data solutions and trusted datasets.Improve operational excellence. Develop tooling and processes that increase reliability and reduce manual intervention.Mentor data engineers and analysts. Share best practices and elevate technical standards across the data organization.Who You Are8+ 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.Comfortable navigating ambiguity and helping define solutions where requirements are still emerging.Strong ownership mindset with a focus on building durable systems rather than one-off solutions.Nice To HavesExperience working with healthcare data, claims data, or clinical records.Familiarity with healthcare interoperability standards such as FHIR or HL7.Experience supporting machine learning or LLM-enabled data workflows.This position is not eligible for employer-sponsored work authorization. Applicants must be legally authorized to work in the United States on a permanent basis without the need for current or future visa sponsorship.*Why You’ll Love Working HereWe’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 equityFull health, dental, and vision coverageRetirement savings plan through 401(k)Flexible time offOpportunities for company-wide connection and eventsReady 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 InformationWork AuthorizationCandidates must be authorized to work in the United States without current or future employer sponsorship.Equal Employment OpportunityPivotal 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 AccommodationsPivotal 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 ChecksEmployment is contingent upon successful completion of applicable background checks, where permitted by law.At-Will EmploymentEmployment 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.
Optionally, you can add more information later (benefits, pre-screening questions, etc.)
check_circle

Payment confirmed

A member of the Torre team will contact you shortly

In the meantime, continue adding information to your job opening.