Key skills
PythonRubySQLETLELTLookerBigQuerydbtFivetranRailsAWSAzureGCPHerokuIAMGCSSaaSSalesforceCRM
About this role
OrderlyMeds is a health-tech company focused on improving healthcare experiences through technology and compassionate service. As a Data Engineer, you will manage the data platform, integrating various business 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