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. We combine software, data, and service into a seamlessly integrated, AI-driven platform that simplifies complex reimbursement workflows. ### About the Role We're hiring a **Data Engineer** to bridge our analytics and engineering teams. You'll be responsible for making Pivotal's product data accessible, reliable, and ready for analysis. This role involves connecting data sources to our warehouse, building clean transformation pipelines, and ensuring our analysts have the necessary tools to drive business decisions. ### What You’ll Do - **Own the pipeline** from product database to analytics warehouse: Extract data from our PostgreSQL product database and load it into BigQuery. - **Design and maintain ETL processes**: Ensure reliable data extraction and transformation for downstream analytics use. - **Integrate new data sources**: Expand our analytics footprint by incorporating third-party tools like Salesforce into our warehouse. - **Build and maintain analytics-ready tables**: Use dbt to design, build, and manage the transformation layer that turns raw data into structured tables. - **Support reporting and business insights**: Collaborate with analysts to ensure data is fresh, accurate, and structured for efficient reporting in tools like Tableau, Power BI, or Metabase.