Data Engineer

OrderlyMeds is a health-tech platform focused on improving healthcare experiences. The Data Engineer will own the data platform, integrating various systems into a BigQuery warehouse to support business decisions.

Responsibilities:

• Own and extend ELT pipelines connecting five business systems into BigQuery via Heroku Connect, Fivetran, and custom ingestion
• Design and maintain dbt models following star schema patterns (staging → intermediate → marts), including incremental strategies and testing
• Solve cross-system identity resolution across three CRMs with different identifier schemes
• Build and maintain data quality frameworks: automated testing, schema drift detection, and pipeline observability
• Define and implement reverse ETL workflows to push warehouse-derived segments back into Salesforce and Ontraport for marketing and operations teams
• Build and maintain Looker dashboards to surface key metrics; provide ad hoc analysis for strategic decisions
• Collaborate with engineering to ensure reliable data replication from production systems
• Evaluate orchestration tooling and scale the platform as the team grows

Requirements:

• 4+ years of experience –or- a degree in Computer Science, Data Science, or similar and 3 years of experience
• Strong proficiency in SQL
• Experience with dbt - you've built and maintained dimensional models, not just written queries
• Experience wiring together multiple SaaS systems into a warehouse (bonus if you've dealt with Salesforce and/or legacy CRM data)
• Comfort with Python for scripting, automation, and custom ingestion
• Familiarity with BigQuery or similar cloud warehouses
• Pragmatic approach to data quality - you build tests and monitoring, not just dashboards
• Ability to work autonomously and make decisions with incomplete information - you'll often be the only person who knows the data layer end to end
• Strong understanding of data modeling concepts (dimensional modeling, normalization, schema design) in a Kimball style data warehouse
• Experience working in cloud environments (AWS, GCP, or Azure)
• Experience with Heroku Connect, Fivetran, or similar CDC/replication tools
• Familiarity with Ruby and Rails (this is the stack our fulfillment system is written in)
• Experience with Looker development (LookML)
• Experience with Entity resolution across systems with mismatched identifiers
• Experience with GCP infrastructure (IAM, GCS, Workload Identity Federation)
• Experience in digital health, telemedicine, pharmacy, or a related field
• Experience at a high-growth startup