Data Engineer

About Pivotal Health

Pivotal Health is the leading technology platform that helps healthcare providers get paid fairly in an increasingly complex reimbursement landscape. The platform combines software, data, and service into a seamlessly integrated, AI-driven solution that simplifies complex reimbursement workflows, helping providers efficiently dispute underpaid claims, reduce administrative burden, and recover the reimbursement they're entitled to.

About the Role

We're hiring a Data Engineer to sit at the intersection of our analytics and engineering teams. You'll be responsible for making Pivotal's product data accessible, reliable, and ready for analysis. This role brings a strong technical foundation in service of business outcomes: faster reporting, better data access, and more reliable pipelines that the team can trust.

What You'll Do

• Own the pipeline from product database to analytics warehouse by extracting data from PostgreSQL and loading it into BigQuery, designing and maintaining reliable ETL processes with the right structure for downstream analytics
• Expand the analytics footprint by integrating new data sources, including third-party tools like Salesforce, while partnering with DevOps to establish proper service accounts, permissions, and secure connection patterns
• Build and maintain analytics-ready tables using dbt to design, build, and manage the transformation layer that turns raw data into clean, well-structured tables
• Support reporting and business insights by working alongside analysts to ensure data is fresh, accurate, and structured for reliable dashboard and reporting creation in tools like Tableau, Power BI, or Metabase