Staff Data Engineer

About Atropos Health

Atropos Health is the developer of GENEVA™ OS , the operating system for rapid healthcare evidence across a robust network of real-world data. Healthcare and life science organizations work with Atropos Health to close evidence gaps from bench to bedside, improving individual patient outcomes with data-driven care, expediting research that advances the field of medicine, and more. We aim to transform healthcare with timely, relevant real-world evidence.

About the Role

You will build and refine the foundations for a robust Data Engineering team at Atropos Health, turning healthcare data into information. You will own healthcare data product delivery with analysis, cleaning, and transformation of large datasets and the creation of new tools to ensure quality and consistency of data. You will nurture strong relationships with commercial, medical, and data science stakeholders and deliver products and projects as part of a growing Series B startup. Your expert knowledge of healthcare data standards and terminology will help create world-class clinical data products and help Atropos deliver insights and knowledge to our customers. 

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 

Minimum Qualifications

• Bachelor’s Degree (Required), Master’s Degree (Preferred) or commensurate experience

• 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 (Required)

• Significant and deep experience as a data professional working with public cloud infrastructure to build data products (Required)

• 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

Reporting

The Senior Data Engineer reports directly to the Senior Director of Data Engineering, Philip Ballentine.  Data Engineering is part of the Engineering organization. 

Location

We are a remote first company! You must be currently authorized to work in the United States on a full-time basis. We cannot support visa sponsorship at this time.

Our Core Values

• Bias to Action. We are driven by urgency and persistence, ensuring our actions contribute to the relentless pursuit of our mission.

• Intellectual Honesty. We are committed to the integrity of our work, seeking truth, and building transparent methodologies that go beyond industry norms.

• Compelled by Curiosity. We seek to solve the unknown, push boundaries, and do not accept the status quo.

• Impactful Innovation. We pioneer solutions that pursue equity and representation that have a transformative impact for our customers, users, and patients.

• Mindful Mentorship. We approach all interactions with an empathetic understanding, actively investing in the growth of each other and our customers.

Perks

•  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.

At Atropos, we are committed to fostering a diverse, inclusive, and equitable workplace where every individual feels valued, respected, and empowered to contribute their unique perspectives and talents. We are an equal-opportunity employer that does not discriminate on the basis of race, religion, national origin, age, gender, gender identity or expression, sexual orientation, genetics, disability, pregnancy, veteran status, or any other legally protected status.

Atropos participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. only after a job offer is accepted and Form I-9 is completed. For more information on E-Verify, please visit the following: EVerify Participation & IER Right to Work.