Data Engineer- OrderlyMeds

About Orderly Wellness

Orderly Meds is building a better, more supportive healthcare experience—one that’s fast, reliable, and designed with people in mind. As a fully remote company, we’ve grown quickly by combining thoughtful technology with compassionate service, helping tens of thousands of patients get the care and medication they need, without the hassle.

We’re a collaborative, mission-driven team working across the U.S. (and beyond!) to improve access to care at scale. With over 100 customer support agents, six pharmacy partners, and a 50-state clinical network, we’re scaling fast, and looking for curious, kind, and solutions-oriented people to grow with us.

• OrderlyMeds is a vertically integrated health-tech platform.  Our founding mission is to restore dignity, access, and simplicity to healthcare.  We believe in the power of technology and personalized care to revolutionize wellness and provide individuals with more than just access to personalized medicine - we are personalizing their entire wellness experience

Orderly Wellness actively participates in E-Verify. To learn more, click here.

A note of awareness to Orderly Wellness applicants: To protect yourself against phishing and recruitment fraud, please note that Orderly Wellness only accepts applications through our official careers page at https://ats.rippling.com/orderly-wellness/jobs.

Orderly Wellness will never refer you to external websites, ask for payment or personal information, or conduct interviews via messaging apps. All official communication will come from a @orderlymeds.com email address. If you are contacted by someone claiming to be from Orderly Wellness via an unofficial channel, please do not share any information and report it as spam.

The Role

As a Data Engineer at Orderly Wellness, you'll be the primary owner of our data platform, connecting Salesforce, Ontraport, Rails, Stripe, and Twilio into a BigQuery warehouse that powers business decisions. Our three core systems use different identifier schemes and weren't designed to talk to each other — solving that is the heart of this role.

We're a small, cross-functional team. For example, in the course of one week you might find yourself building pipelines, creating Looker dashboards, and perhaps even doing some ad-hoc analysis. If you've been the sole data engineer responsible for making messy real-world systems work together, you'll thrive here (although you won’t actually have to go it alone!)

Our Stack

·         Warehouse:                    BigQuery

·         Transformation:           dbt (1.8+)

·         Ingestion:                         Heroku Connect, Fivetran, custom Python

·         BI:                                          Looker

·         Cloud:                                Google Cloud Platform (GCP) - BigQuery, GCS, Workload Identity Federation

·         Languages:                   SQL, Python, Ruby

·         CI/CD & Version Control:    GitHub Actions; Git

·         Data Quality:                 dbt tests, Elementary, custom automation

·         Orchestration:             GitHub Actions (evaluating dedicated tooling)

Key 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 strat