data
Posted Apr 23Data Engineer
Santa Monica, United StatesRemote
Responsibilities
- 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.
Requirements
- Pivotal Health combines software, data, and service into a seamlessly integrated, AI-driven platform that simplifies these complex reimbursement workflows.
- 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.
- 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.
- 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.
- You understand how to 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) - You think in business outcomes: your resume reflects the impact your work had, not just the tools you used - Self-directed and comfortable with ambiguity: you can identify what needs to be done and execute without heavy guidance - Collaborative by nature: you know how to work across teams with different levels of technical depth - Startup or high-growth company
- 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 We’re a collaborative, low-ego team on a mission to make healthcare reimbursement fairer for providers.