pivotal-health - Staff Data Engineer, Data Warehouse
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT
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. • 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. • Experience 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.*
Responsibilities
• Own 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.
Benefits
• 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. • 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
No credit card. Takes 10 seconds.