Staff Data Engineer, Data Warehouse

Job not on LinkedIn

🕒 June 12

🗽 New York – Remote

🗽 New York – Remote

💵 $200k - $230k / year

⏰ Full Time

🔴 Lead

🚰 Data Engineer

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Pivotal Health

WebsiteLinkedInAll Job Openings

51 - 200 employees

⚕️ Healthcare Insurance

☁️ SaaS

🤝 B2B

💰 Pre seed on 2024-01

Healthcare Insurance • SaaS • B2B

Pivotal Health is a healthcare technology company that provides the industry’s only full-service Independent Dispute Resolution (IDR) platform, combining software, data, and white-glove services to help providers secure fair reimbursement from payers. Their scalable, integrated SaaS platform automates IDR workflows, connects with major revenue cycle management systems, and manages eligibility, submissions, and appeals on behalf of provider organizations. Pivotal Health serves hospitals and specialty practices with a results-driven, outcome-aligned business model (paid after client success) and emphasizes transparency, high client retention, and measurable revenue recovery.

📋 Description

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

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

🏖️ 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