Analytics Engineer

About Pivotal Health Pivotal Health is the leading technology platform that helps healthcare providers get paid fairly in an increasingly complex reimbursement landscape. Providers face persistent underpayment from health insurance companies. Our AI‑driven platform simplifies reimbursement workflows, helping teams efficiently dispute underpaid claims and reduce administrative burden. About The Role Data Engineer at the intersection of analytics and engineering. Responsible for making product data accessible, reliable, and ready for analysis. Connect data sources to our warehouse, build clean transformation pipelines, and enable analysts to drive business decisions. What You’ll Do Own 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. 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. Own 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 Are Strong SQL skills with hands‑on experience in modern cloud data warehouses: BigQuery, Snowflake, or Redshift. Proficient with dbt for managing SQL transformations. Write clean, maintainable, well‑documented models. Comfortable with Python at a working level, enough to build and automate data workflows without needing to be a full software engineer. Experience with at least one BI or reporting tool (Tableau, Power BI, Metabase, or similar). Think in business outcomes: the resume reflects the impact of work, not just the tools used. Self‑directed and comfortable with ambiguity: identify what needs to be done and execute without heavy guidance. Collaborative by nature: work across teams with different levels of technical depth. Startup or high‑growth company experience: used to environments where ownership is real and speed matters. Extra Credit If You Have Hands‑on experience with BigQuery specifically. Experience connecting BI tools to a cloud warehouse (e.g., Power BI to BigQuery). Experience with Salesforce data or CRM integrations. Background in FinTech, HealthTech, or other data‑rich industries. Why You’ll Love Working Here Team mission to make healthcare reimbursement fairer for providers. Remote and hybrid flexibility varies by role and team. We value solving complex problems and making a real‑world impact. Benefits Include 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 Employment Information Candidates must be authorized to work in the United States without current or future employer sponsorship. Equal Employment Opportunity Pivotal Health is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Reasonable Accommodations We provide 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 Checks Employment is contingent upon successful completion of applicable background checks, where permitted by law. At‑Will Employment Employment 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. Compensation Range: $160K – $180K #J-18808-Ljbffr Pivotal Health