Data Engineer

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 RoleWe'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, connecting data sources to our warehouse, building clean transformation pipelines, and ensuring our analysts have what they need to drive business decisions.This is not a traditional software engineering role and it's not a pure analyst role either. You'll bring a strong technical foundation and apply it in service of business outcomes: faster reporting, better data access, and more reliable pipelines that the team can actually trust.If you enjoy building the infrastructure that makes great analysis possible and care about the business impact of your work, this role is for you.What You’ll DoOwn the pipeline from product database to analytics warehouse: Take full ownership of extracting data from our PostgreSQL product database and loading it into BigQuery. Design and maintain the ETL processes that make this happen reliably, with the right structure for downstream analytics use.Bring in new data sources: Expand our analytics footprint by integrating new data sources, including third-party tools like Salesforce, into our warehouse. You'll partner with our DevOps team to establish the right service accounts, permissions, and connection patterns to do this securely and correctly.Build and maintain analytics-ready tables: Use dbt to design, build, and manage the transformation layer that turns raw data into clean, well-structured tables. You'll have real ownership over what the data looks like: what gets modeled, how it's shaped, and what makes it most useful for reporting.Support reporting and business insights: Work alongside our analysts to support the reporting layer, ensuring data is fresh, accurate, and structured in a way that makes building dashboards and reports in Tableau, Power BI, or Metabase reliable and efficient.Be the bridge between analytics and engineering: Attend engineering team meetings to stay ahead of product changes that could affect analytics. Serve as the connective tissue between both teams, translating data needs into technical solutions and keeping everyone aligned.Who You AreStrong SQL skills with hands-on experience in modern cloud data warehouses: BigQuery, Snowflake, or RedshiftProficient with dbt for managing SQL transformations. You understand how to write clean, maintainable, well-documented modelsComfortable with Python at a working level, enough to build and automate data workflows without needing to be a full software engineerExperience with at least one BI or reporting tool (Tableau, Power BI, Metabase, or similar)You think in business outcomes: your resume reflects the impact your work had, not just the tools you usedSelf-directed and comfortable with ambiguity: you can identify what needs to be done and execute without heavy guidanceCollaborative by nature: you know how to work across teams with different levels of technical depthStartup or high-growth company experience: you're used to environments where ownership is real and speed mattersExtra Credit If You HaveHands-on experience with BigQuery specificallyExperience connecting BI tools to a cloud warehouse (e.g., Power BI to BigQuery)Experience with Salesforce data or CRM integrationsBackground in FinTech, HealthTech, or other data-rich industriesWhy 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.Please mention the word STUPENDOUSLY and tag RMmEwNjo5OGMwOjM2MDA6OjEwMw== when applying to show you read the job post completely (#RMmEwNjo5OGMwOjM2MDA6OjEwMw==). This is a beta feature to avoid spam applicants. Companies can search these words to find applicants that read this and see they're human.

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 RoleWe'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, connecting data sources to our warehouse, building clean transformation pipelines, and ensuring our analysts have what they need to drive business decisions.This is not a traditional software engineering role and it's not a pure analyst role either. You'll bring a strong technical foundation and apply it in service of business outcomes: faster reporting, better data access, and more reliable pipelines that the team can actually trust.If you enjoy building the infrastructure that makes great analysis possible and care about the business impact of your work, this role is for you.What You’ll DoOwn the pipeline from product database to analytics warehouse: Take full ownership of extracting data from our PostgreSQL product database and loading it into BigQuery. Design and maintain the ETL processes that make this happen reliably, with the right structure for downstream analytics use.Bring in new data sources: Expand our analytics footprint by integrating new data sources, including third-party tools like Salesforce, into our warehouse. You'll partner with our DevOps team to establish the right service accounts, permissions, and connection patterns to do this securely and correctly.Build and maintain analytics-ready tables: Use dbt to design, build, and manage the transformation layer that turns raw data into clean, well-structured tables. You'll have real ownership over what the data looks like: what gets modeled, how it's shaped, and what makes it most useful for reporting.Support reporting and business insights: Work alongside our analysts to support the reporting layer, ensuring data is fresh, accurate, and structured in a way that makes building dashboards and reports in Tableau, Power BI, or Metabase reliable and efficient.Be the bridge between analytics and engineering: Attend engineering team meetings to stay ahead of product changes that could affect analytics. Serve as the connective tissue between both teams, translating data needs into technical solutions and keeping everyone aligned.Who You AreStrong SQL skills with hands-on experience in modern cloud data warehouses: BigQuery, Snowflake, or RedshiftProficient with dbt for managing SQL transformations. You understand how to write clean, maintainable, well-documented modelsComfortable with Python at a working level, enough to build and automate data workflows without needing to be a full software engineerExperience with at least one BI or reporting tool (Tableau, Power BI, Metabase, or similar)You think in business outcomes: your resume reflects the impact your work had, not just the tools you usedSelf-directed and comfortable with ambiguity: you can identify what needs to be done and execute without heavy guidanceCollaborative by nature: you know how to work across teams with different levels of technical depthStartup or high-growth company experience: you're used to environments where ownership is real and speed mattersExtra Credit If You HaveHands-on experience with BigQuery specificallyExperience connecting BI tools to a cloud warehouse (e.g., Power BI to BigQuery)Experience with Salesforce data or CRM integrationsBackground in FinTech, HealthTech, or other data-rich industriesWhy 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.Please mention the word STUPENDOUSLY and tag RMmEwNjo5OGMwOjM2MDA6OjEwMw== when applying to show you read the job post completely (#RMmEwNjo5OGMwOjM2MDA6OjEwMw==). This is a beta feature to avoid spam applicants. Companies can search these words to find applicants that read this and see they're human.