We are currently seeking an Industrial / Process Architect to join our Raleigh office. In this role, you will play a pivotal role in growing our pharmaceutical manufacturing business. You possess experience in planning and design for the life sciences realm, specifically in biotechnology, pharmaceutical, biomedical or other process architecture. You are passionate about design and devoted to quality. You possess the organizational skills to prioritize tasks and handle multiple deadlines, a thorough knowledge of relevant codes, operations, processes and trends, a demonstrated ability to mentor and manage teams, and foster and nurture Client relationships. 

About the Position

We're looking for a Data Engineer to join the Scientific Data Intelligence (SDI) team at Formation Bio to help build and scale the data infrastructure that powers our drug development platform. In this role, your primary focus will be supporting the Data Science team — building the coherent, well-structured data models, feature engineering pipelines, and evidence layers that underpin their scientific work. You'll also be responsible for ingesting data from a wide variety of sources—APIs, files, databases, and licensed third-party datasets—and transforming it into clean, analytics-ready assets using modern data tooling.

This is a foundational engineering role for someone who takes pride in building things right: reliable pipelines, well-structured data models, and systems that others can trust and build on. You'll work closely with Data Scientists and other engineers across the SDI team to ensure that high-quality data is consistently available where and when it's needed — and structured in a way that directly accelerates scientific discovery.

The ideal candidate is deeply fluent in Snowflake and dbt, has strong opinions about data modeling best practices, and has experience handling large and complex datasets across diverse ingestion patterns. You thrive in environments where data quality and engineering rigor are treated as first-class concerns.

Responsibilities

• Partner closely with Data Scientists and other teams to build coherent data models, feature engineering pipelines, and structured evidence layers that directly support scientific analysis and machine learning workflows.
• Design and build scalable ingestion pipelines to onboard data from diverse sources including REST APIs, flat files, relational databases, and licensed third-party datasets.
• Develop and maintain robust data models in dbt, adhering to best practices around modularity, testing, documentation, and layered architecture (staging, intermediate, mart).
• Orchestrate pipelines using Dagster to ensure reliable, observable, and maintainable workflows.
• Implement data quality checks, validation frameworks, and monitoring to ensure trustworthiness of datasets across the platform.
• Collaborate with Data Scientists and analysts to understand data needs and translate them into well-structured, reusable models.
• Handle large-scale data movement and transfer scenarios, applying appropriate tooling and patterns to ensure efficiency and reliability at scale.
• Document data models, pipeline logic, and transformation assumptions to support discoverability and data governance.

About You

• You have 5+ years of experience in data engineering, with a strong track record of building and maintaining production-grade pipelines.
• You are deeply fluent in dbt and follow best practices rigorously—including modular model design, sources and refs, testing (schema + data), documentation, and environment management.
• You have hands-on expertise with Snowflake, including schema design, performance tuning, and data governance patterns.
• You have experience with at least one modern orchestration tool—we use Dagster, but experience with Airflow or Prefect is equally welcome.
• You have broad ingestion experience across source types: REST APIs, flat files (CSV, JSON, Parquet), relational databases, and vendor-licensed datasets.
• You have worked with large datasets (TB -> PB scale) and understand the engineering considerations that come with scale—partitioning, incremental loading, efficient data movement, and storage optimization.
• You're a strong data modeler who thinks carefully about how data is structured, named, and layered for downstream usability.
• You value documentation, testability, and building things others can maintain and extend.
• You can balance upfront design with speed to execution, slowing down when it counts without getting stuck in the details.
• Bonus: You have experience with data quality and observability tooling such as Elementary, Great Expectations, or similar frameworks — and you treat data quality as a first-class engineering concern, not an afterthought.
• Bonus: You have experience with Spark, Databricks for large-scale data processing workloads.
• Bonus: You have experience with large-scale data transfer tooling such as AWS DataSync, AWS S3 Transfer Acceleration, or equivalent cloud-native data movement services.
• Bonus: You have experience in healthcare or life sciences data environments, including familiarity with EHR, claims, or other biomedical datasets.

Total Compensation Range: $177,500 - $232,000

About the Position

We're looking for a Senior Data Engineer to join the Scientific Data Intelligence (SDI) team at Formation Bio to help transform Real World Data (RWD)—spanning electronic health records, claims, and other longitudinal patient data sources—into structured, analytics-ready assets. In this role, you'll be partnering closely with our Data Science team not only to model and transform data, but also to actively analyze it: answering research questions, generating evidence, and supporting scientific decision-making across our drug portfolio.

This position sits at the intersection of healthcare data engineering, real-world evidence analysis, and generative AI. While a strong foundation in building reliable, scalable pipelines is essential, you'll be equally expected to roll up your sleeves and work directly with the data—constructing cohorts, running analyses, and translating findings into actionable insights for scientific and business stakeholders.

The ideal candidate is a hybrid of data engineer and applied scientist: someone who can build the infrastructure and then use it, with familiarity in RWD study design, 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 real-world patient data becomes discoverable, structured, and impactful across the organization.

Responsibilities

• Model and transform raw EHR and claims data into clean, canonical, and analytics-ready datasets using SQL, Python, and clinical standards like OMOP.
• Build and manage scalable data pipelines using Dagster for orchestration, dbt for transformation, and Snowflake as the primary compute and storage engine.
• Conduct hands-on RWD analyses to answer scientific and strategic research questions—including disease epidemiology, treatment patterns, patient journey characterization, and comparative effectiveness.
• Partner with Data Scientists and clinical leads to design and execute observational studies, translating scientific questions into well-structured, reproducible analyses.
• Implement data validation, completeness, and observability frameworks to ensure real-world datasets are accurate, comprehensive, and trustworthy for downstream research and product use.
• Apply Generative AI techniques within transformation and analysis layers to accelerate data structuring and insight generation.
• Communicate findings clearly to both technical and non-technical stakeholders, including summaries for portfolio teams and leadership.

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 or claims datasets.
• You have experience with ontologies and biomedical schemas (e.g. UMLS, LOINC, ICD9/10, MeSH) and understand the modalities found within RWD — billing claims, lab results, visit notes.
• You're fluent in SQL and Python, and you've built and maintained production-grade pipelines that support analytics or scientific workflows.
• You have experience building longitudinal patient cohorts from EHR or claims data, including index date logic, washout periods, and follow-up window construction.
• You have a solid understanding of the causal inference frameworks such as potential outcomes and target trial emulation. 
• You have working familiarity with real-world evidence study design concepts—such as active comparator new user designs, time-to-event outcomes, confounder adjustment, and causal discovery algorithms—sufficient to partner effectively with Data Scientists on causal inference workflows.
• You value clarity, documentation, and structured thinking—especially when working with complex healthcare data.
• You have hands-on expertise with modern data infrastructure, such as Snowflake, dbt, and Dagster.
• You can balance upfront design with speed to execution, slowing down when it counts without getting stuck in the details.
• Bonus: You've worked in regulated or privacy-sensitive data environments and are familiar with governance models for PHI or sensitive data.
• Bonus: You have prior experience working with commercial RWD vendors (e.g. Truveta, Optum, Komodo, IQVIA) and understand the nuances of licensed claims and EHR datasets, including longitudinal patient journey construction and line-of-therapy sequencing.

Total Compensation Range: $204,500 - $267,000