Data Engineer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Engineer at OrderlyMeds connecting multiple systems to BigQuery for strategic insights. Collaborating with a cross-functional team to enhance data utility and drive 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)
Benefits:
- 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
- access to professional development resources
Similar Jobs
Data Engineer/Software Engineer
Data Engineer/Software Engineer responsible for implementing data-driven solutions and managing data pipelines. Join ALTEN Technology USA to work on challenging engineering projects.
Data Engineering Manager
Engineering leader managing Data Engineering team at Northrop Grumman. Overseeing data systems and leading a collaborative team to ensure engineering excellence.
Data Engineer
Senior Data Engineer serving in Prima's engineering team, building scalable data products and maintaining pipelines for optimal growth. Engaging in innovative solutions to transform motor insurance experience.
Senior Data Engineer
Senior Data Engineer leading design discussions and driving technical vision for healthcare data solutions. Collaborating cross-functionally to ensure high standards and timely project delivery.
Senior Analytics Data Engineer
Full Stack Engineer developing scalable applications for the largest real-world healthcare datasets provider. Collaborating with an international team under technical leadership for critical platform enhancements.
Director – Data Engineering
Director leading and scaling data engineering function for a Weekday's client. Building efficient data platforms powering analytics and business intelligence across the organization.
Data Engineer
Data Engineer building and maintaining data pipelines for marketing and analytics at an EdTech app with 70 million users. Collaborating with analysts and business teams for data quality and reporting.
Data Engineer
Data Engineer responsible for managing data infrastructure at Bemobi with innovative solutions for data access and analysis. Join the Data Platform team to enhance data lifecycle processes.
Senior Lead Software Engineer, Data Platform
Senior Software Engineer building scalable data and analytics platforms at Coupa. Focusing on advanced data ingestion and processing in a multi-cloud environment.
Workday/Fabric Data Engineer
Workday/Fabric Data Engineer supporting USNH's business intelligence initiatives by designing and maintaining data solutions. Collaborating with teams for effective reporting and analytics.
Senior Data Engineer
Senior Data Engineer enhancing Dotdigital's data platform and capabilities. Designing data pipelines and collaborating with teams to unlock the value of data.
Director of Data Engineering – Platforms
Director of Data Engineering at Cotality leading data transformation initiatives and data architecture frameworks. Collaborating with product teams to drive actionable business intelligence.
Data Architect
Design and manage enterprise data architecture with a focus on Air Force Logistics Systems. Collaborate with engineers and government stakeholders for scalable and secure data solutions.
Data Engineer
Data Engineer building data pipelines for analytics and machine learning at Illumination Works. Collaborating across teams to ensure reliable data for insights and experimentation.
Data Architect – Short-Term Freelance Project, Pharma
Data Architect role focused on implementing modern data governance practices in pharmaceutical projects. Requires strong expertise in Governance as Code and data architecture.
Data Engineer – Medicine & Analytics
Data Engineer responsible for building reliable data solutions for analytics in Medicine. Collaborate with diverse teams to improve patient outcomes through data-driven insights.
Senior Application Data Architect
Senior Application Data Architect leading enterprise data architecture and engineering initiatives. Collaborating with cross-functional teams to design and build scalable data solutions.
Unit Lead, Data Engineering
Lead the Data Engineering team at evoila, driving innovative data projects and developing advanced technological solutions in Germany. Collaborate on Greenfield projects and enhance existing platforms.
Data Engineer – AI Platform
Data Engineer responsible for building data ingestion pipelines for the AI platform at TaskUs. Engaging in scalable data management with strong experience in Python, SQL, and AWS.
Data Engineer II
Data Engineer II contributing to data governance engineering programs at CareSource. Focused on solution design architecture and implementation of standards for data management.