Talent.com
Senior Data Engineer II - Electronic Health Records (EHR)

Senior Data Engineer II - Electronic Health Records (EHR)

Formation BioRaleigh, North Carolina, United States
1 day ago
Job type
  • Full-time
Job description

About Formation Bio

Formation Bio is a tech and AI driven pharma company differentiated by radically more efficient drug development.

Advancements in AI and drug discovery are creating more candidate drugs than the industry can progress because of the high cost and time of clinical trials. Recognizing that this development bottleneck may ultimately limit the number of new medicines that can reach patients, Formation Bio, founded in 2016 as TrialSpark Inc., has built technology platforms, processes, and capabilities to accelerate all aspects of drug development and clinical trials. Formation Bio partners, acquires, or in-licenses drugs from pharma companies, research organizations, and biotechs to develop programs past clinical proof of concept and beyond, ultimately helping to bring new medicines to patients. The company is backed by investors across pharma and tech, including a16z, Sequoia, Sanofi, Thrive Capital, Sam Altman, John Doerr, Spark Capital, SV Angel Growth, and others.

You can read more at the following links :

  • Our Vision for AI in Pharma
  • Our Current Drug Portfolio
  • Our Technology & Platform

At Formation Bio, our values are the driving force behind our mission to revolutionize the pharma industry. Every team and individual at the company shares these same values, and every team and individual plays a key part in our mission to bring new treatments to patients faster and more efficiently.

About the Position

We’re looking for a Senior Data Engineer to join the Data Platform team at Formation Bio to help transform Electronic Health Records (EHR) data into structured, analytics-ready assets. In this role, you’ll be partnering closely with our Data Science team to model, transform, and refine data for operational and scientific use cases.

This position sits at the intersection of healthcare data engineering, modern data platform infrastructure, and generative AI. While your initial focus will be on building high-quality EHR models for  Formation Bio platform, you’ll also contribute to our broader data architecture by leveraging tools like Snowflake, Dagster, and dbt to enable scalable, governed, and high-reliability pipelines.

The ideal candidate combines deep data engineering experience with both GenAI fluency (e.g., LLM-based entity extraction, summarization, classification) and strong technical expertise with modern data tooling. You’ll play a key role in shaping how healthcare data becomes discoverable, structured, and impactful across the organization.

Responsibilities

  • Model and transform raw EHR data into clean, canonical, and analytics-ready datasets using SQL, Python, and clinical standards like FHIR, HL7, or OMOP.
  • Build and manage scalable data pipelines using Dagster for orchestration, dbt for transformation, and Snowflake as the primary compute and storage engine.
  • Collaborate with Data Science and product stakeholders to co-develop cohort logic, derived features, and structured outputs that meet real-world scientific needs.
  • Apply Generative AI techniques within transformation layers—using LLMs for named entity recognition, document summarization, classification, and schema alignment.
  • Write robust, testable, and version-controlled code that adheres to CI / CD and data governance best practices.
  • Implement data validation and observability frameworks to ensure quality, trust, and reproducibility of datasets.
  • Document transformation logic, assumptions, and data lineage in collaboration with metadata and cataloging systems.
  • Contribute to the evolution of the Data Platform by helping define standards, patterns, and best practices around GenAI and platform-scale data engineering.
  • About You

  • You have 5+ years of experience in data engineering, ideally with at least 2 years working in healthcare or life sciences, including direct exposure to EHR datasets.
  • Experience with ontologies and biomedical schemas (e.g. UMLS, LOINC, ICD9 / 10, MeSH, etc.)]
  • Experience and understanding of modalities found within EHR datasets incl. Billing claims, lab results, visit notes, images
  • Experience in biomedical feature engineering, e.g. variable transformations and derivatives
  • You’re fluent in SQL and Python, and you’ve built and maintained production-grade pipelines that support analytics, science, or operational workflows.
  • You have hands-on expertise with modern data infrastructure, including :
  • You’re experienced in applying GenAI techniques within pipelines, including prompt engineering, LLM-based entity extraction, and classification / summarization workflows.
  • You value clarity, documentation, and structured thinking—especially when working with complex data like healthcare records.
  • You have a growth mindset and are excited to build bridges between isolated data environments and governed, shared models that power scientific innovation.
  • Bonus : You’ve worked in regulated or privacy-sensitive data environments, and you’re familiar with governance models for PHI or sensitive data
  • Formation Bio is prioritizing hiring in key hubs, primarily the New York City and Boston metro areas, with additional growth in the Research Triangle (NC) and San Francisco Bay Area. Please only apply if you reside in these locations or are willing to relocate.

    Compensation :

    The target salary range for this role is : $230,000 - $280,000.

    Salary ranges are informed by a number of factors including geographic location. The range provided includes base salary only. In addition to base salary, we offer equity, comprehensive benefits, generous perks, hybrid flexibility, and more. If this range doesn't match your expectations, please still apply because we may have something else for you.

    You will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

    #LI-hybrid

    Create a job alert for this search

    Data Engineer Ii • Raleigh, North Carolina, United States

    Related jobs
    • Promoted
    Statistician / Data Scientist - ISD Analytics

    Statistician / Data Scientist - ISD Analytics

    UNC Health CareMorrisville, NC, United States
    Full-time
    Become part of an inclusive organization with over 40,000 teammates, whose mission is to improve the health and well-being of the unique communities we serve. Data Scientists are experts within UNC ...Show moreLast updated: 30+ days ago
    • Promoted
    Data Engineer (Remote USA) G10

    Data Engineer (Remote USA) G10

    Cisco Systems, Inc.Research Triangle Park, NC, United States
    Full-time
    The application window is expected to close on : 12 / 25 / 25.Job posting may be removed earlier if the position is filled or if a sufficient number of applications are received.Job location preference : ...Show moreLast updated: 2 days ago
    • Promoted
    Principal Data Engineer (Foundry)

    Principal Data Engineer (Foundry)

    Azurity Pharmaceuticals - USRaleigh, NC, US
    Full-time
    Azurity Pharmaceuticals is a privately held, specialty pharmaceutical company that focuses on innovative products that meet the needs of underserved patients. As an industry leader in providing uniq...Show moreLast updated: 19 days ago
    • Promoted
    Controls Engineer II

    Controls Engineer II

    E2i Inc.Durham, NC, US
    Full-time
    E2i is a small systems integrator that specializes in automation, validation, informatics, control panel design, and fabrication for the last 35 years. At E2i, self-growth is at the basis of many de...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Engineer - AI Data Center Global Demo team

    Senior Engineer - AI Data Center Global Demo team

    Cisco Systems, Inc.Research Triangle Park, NC, United States
    Full-time
    The application window is expected to close on November 25, 2025.This job posting may be removed earlier if the position is filled or if a sufficient number of applications are received.Raleigh, NC...Show moreLast updated: 10 days ago
    Azure Data Engineer 1-20-

    Azure Data Engineer 1-20-

    Focused HR SolutionsRaleigh, North Carolina, United States
    Full-time
    Quick Apply
    This position is 100% on-site in Raleigh, NC.In-Person Interview REQUIRED on 1st round.Our direct client has an opening for a Azure Data Engineer position # 730992. This position is for 4+ months, w...Show moreLast updated: 30+ days ago
    • Promoted
    Data Engineer

    Data Engineer

    Cisco Systems, Inc.Research Triangle Park, NC, United States
    Full-time
    The application window is expected to close on : 12 / 05 / 2025.Job posting may be removed earlier if the position is filled or if a sufficient number of applications are received.When you work with us ...Show moreLast updated: 2 days ago
    • Promoted
    Medical Records Coder II-Inpatient

    Medical Records Coder II-Inpatient

    Duke Clinical Research InstituteDurham, NC, United States
    Full-time
    PRMO Established in 2001, Patient Revenue Management Organization (PRMO) is a fully integrated, centralized revenue cycle organization supporting all of Duke Health, including Duke University Ho...Show moreLast updated: 20 days ago
    • Promoted
    Senior Data Engineer

    Senior Data Engineer

    First Citizens BankRaleigh, NC, US
    Full-time
    This is a hybrid role, with the expectation that time working will regularly take place inside and outside of a company office. Seeking for a skilled Software engineer role to design, develop and op...Show moreLast updated: 30+ days ago
    • Promoted
    CRA II / Sr CRA | Full Service | Oncology + Gen Med (Home-Based, Eastern US)

    CRA II / Sr CRA | Full Service | Oncology + Gen Med (Home-Based, Eastern US)

    Syneos Health / inVentiv Health Commercial LLCMorrisville, NC, United States
    Temporary
    CRA II / Sr CRA | Full Service | Oncology + Gen Med (Home-Based, Eastern US).Syneos Health is a leading fully integrated biopharmaceutical solutions organization built to accelerate customer succes...Show moreLast updated: 20 days ago
    • Promoted
    • New!
    Senior Security Engineer - Data Loss Prevention Operations

    Senior Security Engineer - Data Loss Prevention Operations

    OracleRaleigh, NC, United States
    Full-time
    Our rapidly growing team specializes in threat hunting, analyzing indicators of compromise (IOCs), investigating security incidents, managing incident responses, and conducting digital forensics ac...Show moreLast updated: 2 hours ago
    • Promoted
    Medical Records Coder II-Commitment Bonus

    Medical Records Coder II-Commitment Bonus

    Duke Clinical Research InstituteDurham, NC, United States
    Full-time
    At Duke Health, we're driven by a commitment to compassionate care that changes the lives of patients, their loved ones, and the greater community. No matter where your talents lie, join us and disc...Show moreLast updated: 11 days ago
    Sr. Data Solutions Engineer (Hybrid)

    Sr. Data Solutions Engineer (Hybrid)

    Serigor Inc.Raleigh, NC, US
    Full-time
    Quick Apply
    Data Solutions Engineer (Hybrid) Location : .Raleigh, NC Duration : 12+ Month Job Description : The Sr.Data Solutions Engineer role will aid in the development of a new cloud environment by assisting t...Show moreLast updated: 30+ days ago
    • Promoted
    Controls Engineer III - Senior

    Controls Engineer III - Senior

    E2i Inc.Durham, NC, US
    Full-time
    E2i is a small systems integrator that specializes in automation, validation, informatics, control panel design, and fabrication for the last 35 years. At E2i, self-growth is at the basis of many de...Show moreLast updated: 30+ days ago
    Senior Data Engineer (Hybrid)

    Senior Data Engineer (Hybrid)

    Serigor Inc.Durham, NC, NC, US
    Full-time
    Quick Apply
    Senior Data Engineer (Hybrid) Location : Durham, NC Duration : 12 Month Job Description : The client is seeking a Senior Data Engineer to lead the development and optimization of end-to-end solutions ...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Statistical Programmer, Data Visualization

    Senior Statistical Programmer, Data Visualization

    5PY IQVIA RDS Inc.Durham, NC, United States
    Part-time
    IQVIA is hiring to expand a sponsor-dedicated team, working fully within the environment of a prominent Pharma company.The position will work in a data visualization team, safety statistical progra...Show moreLast updated: 13 days ago
    • Promoted
    Global Clinical System Engineer II

    Global Clinical System Engineer II

    bioMerieux Inc.Morrisville, NC, United States
    Full-time
    The Global Clinical System Engineer II is responsible for end-to-end product ownership and contributing to worldwide serviceability throughout the entire product lifecycle-from successful launches ...Show moreLast updated: 30+ days ago
    • New!
    Senior Data Engineer

    Senior Data Engineer

    JPS Tech Solutions LLCCary, NC, United States
    Full-time
    Quick Apply
    Job Title : Senior Data Engineer Location : Cary, NC Experience : 12+ Years About the Role Show moreLast updated: 1 hour ago