Staff Data Engineer

Summary

Join Atropos Health as a Senior Data Engineer and build the foundation for a robust data engineering team. You will be responsible for the delivery of healthcare data products, including analysis, cleaning, and transformation of large datasets. This role requires expertise in healthcare data standards, cloud infrastructure, and data modeling. You will collaborate with various stakeholders and manage external relationships. The position offers a remote-first work environment and a comprehensive benefits package. At Atropos, we are committed to fostering a diverse, inclusive, and equitable workplace.

Requirements

• Bachelor’s Degree
• At least 5 years of experience working with messy real-world healthcare data (EHR data, claims) and experience with Real World Data / Evidence at least 3 years
• Expertise working with common data models and terminology systems in healthcare data (data models and standards such as FHIR, OMOP, codesets like ICD 9/10, CPT, ATC, RxNorm, NDC, etc.)
• Knowledge of common EHR and medical claim / administrative workflows and the basics of the US healthcare system (patient movement through a hospital or clinic, how medical procedures are reimbursed, etc.)
• SQL (any dialect): at least 5 years, Python at least 4 years
• Significant and deep experience as a data professional working with public cloud infrastructure to build data products
• Knowledge of EHR data systems and at least 4 years of experience working intensively with EHR data in a data engineering and/or analytics environment
• High level knowledge of ETL/ELT operations and data modeling

Responsibilities

• Create and maintain data pipelines to integrate, enrich, and map clinical, claims, and other data from multiple sources in the cloud
• Design systems of data quality checks and assessments on clinical datasets
• Expert knowledge of how to automate workflows and create reusable infrastructure in multiple public cloud environments (AWS, Azure, GCP)
• Map data from one source into a common data model using many different frameworks, with a particular focus on PySpark and Spark SQL
• Create, maintain, tune, and document data flows in Databricks and Snowflake, Bigquery, and other diverse cloud tools
• Filter, clean, transform, and integrate clinical data using your domain expertise of healthcare data and code systems and embedded knowledge
• Work remotely with an interdisciplinary team and build and maintain strong relationships with research, clinical, product, and commercial stakeholders
• Manage external customer, vendors, and customer relationships and create internal and external communications
• Travel required to company or team offsites 3-4 weeks per year

Preferred Qualifications

Master’s Degree

Benefits

• Health Benefits . Our benefit package includes employer paid Medical, Dental, Vision, Life, STD, and LTD insurance. We also offer FSA
• Parental Leave . We offer up to twelve weeks of paid leave for new parents who have been at the company for 6+ months
• Financial Wellness . Save for retirement through our 401k plan with Human Interest
• Flexible Work Environment . We're a remote first company with a flexible vacation policy
• Home Office Stipend . All full-time employees will receive a stipend to support their remote office setup
• Offsites . As a remote company we take time 2-3 times a year to get together in small teams and all together as a company