Data Pipeline Engineer, Spotlight - Oncology

Key Skills

Analytical and Problem solving, Data Analysis, Data pipelines, ETL frameworks, Machine learning techniques, Oncology, Pandas, Python Programming, R Programming, SQL

Job Description

Reimagine the infrastructure of cancer care within a technology and science community that values integrity, inspires growth, and is uniquely positioned to create a more modern, connected oncology ecosystem. 

We’re looking for a Data Pipeline Engineer to help us accomplish our mission to improve lives by learning from the experience of every cancer patient. Are you ready to be the next changemaker in cancer care?

What you’ll do

In this role, you will join a team of Data Pipeline Engineers which curates custom real-world evidence datasets to empower our life science partners to deliver better cancer treatments - deliver them faster, and develop them more cost effectively than existing alternatives. You will be responsible for technical execution of dataset curation, writing SQL and Python in a proprietary Extract Transform and Load (ETL) framework.

You’ll work to dig into data nuances working closely with cross functional team members like Research Oncologists and Quantitative Scientists to help develop new data variables. In addition, you’ll also:

• Help define business logic rules, using SQL and Python to turn those rules into derived data variables
• Write automated SQL checks to ensure data quality and integrity
• Integrate and link new data sources, work with upstream Flatiron teams on data requirements and quality thresholds
• Identify common needs across dataset requests, and move shared logic into templatized ETL code
• Own and improve the library of templatized ETL pipeline code
• Become an expert in our data models

Who you are

You're a kind, passionate and collaborative problem-solver who values the opportunity to think beyond the way things are. In addition, you’re fluent in SQL, experienced working with complex datasets, excited to learn about the cancer patient journey, and are proactive in collaborating with cross-functional teammates and/or stakeholders.

• You have 1+ year(s) of experience working in a data engineering or similar role
• You have used SQLite and PostgreSQL and/or are familiar with another SQL environment
• You communicate effectively and empathetically with cross-functional stakeholders
• You are flexible and have exceptional problem-solving skills
• You thrive in a cross-functional environment 

Extra Credit

• You have experience working with ETL frameworks
• You have experience working with Python
• You have healthcare industry knowledge/context (especially oncology specific knowledge)

Life at Flatiron 

At Flatiron Health, we offer a full range of benefits to support you and your loved ones so you can focus your working hours on improving cancer care and accelerating cancer research, and your non-working hours on everything else life has to offer: 

• Work/life autonomy via flexible work hours and flexible paid time off
• Comprehensive compensation package
• 401(k) contribution to help you reach your retirement planning goals
• Financial health resources including 1:1 financial advice
• Mental well-being tools and services 
• Parental benefits and policies including family-building care and generous leave
• Path to parenthood programs supporting fertility, adoption and surrogacy
• Travel support for safe healthcare services
• Lifestyle spending account for perks that make sense for you and your family

In addition to our robust benefit offerings, visit our Life at Flatiron page to learn how we support continuous learning through professional development programs and celebrate Diversity in the workplace.

Job Compensation Range

Salary Range: $130,200.00 - $179,800.00

Preferred Primary Location: NYC Headquarters

The annual pay range reflected above for this position is based on the preferred primary location of the role which is listed in the job description. Salary ranges for other locations vary from the range reflected above. Base pay offered may vary depending on job-related knowledge, skills, and experience. An annual bonus and equity may be provided as part of the compensation package, in addition to a full range of medical, financial, and/or other benefits, dependent on the position offered.

Flatiron Health is proud to be an Equal Employment Opportunity employer.