United States onlyAbout 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 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
Required Qualifications
- 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)
Preferred Qualifications (Nice to Haves)
- 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
Core Competencies/Skills
- 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
- Excellent communication skills and ability to present findings to technical and non-technical audiences
- Comfort working in a fast-moving environment with ambiguous problem definitions
Work Environment & Physical Requirements
Our team works remotely, with team members and collaborators spanning from PT to CET.
Compensation & Benefits
Orderly Wellness offers a comprehensive benefits package designed to support your health, financial well-being, and work-life balance. Benefits include medical, dental, and vision coverage with strong employer contribution, FSA and HSA options (with potential employer contributions), a 401(k) with company match, generous paid time off, paid parental leave, mental health and family-planning support, and access to professional development resources.
