Job Application for Senior Data Engineer at Formation Bio Back to jobs New Senior Data Engineer New York, NY; Boston, MA; San Francisco, CA; Raleigh-Durham, NC Apply 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 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. Formation Bio is prioritizing hiring in key hubs, primarily the New York City and Boston metro areas. These positions will follow a hybrid work model with 1-3 days required at the office. Applicants from the Research Triangle (NC) and San Francisco Bay Area may also be considered. Please only apply if you reside in these locations or are willing to relocate.
Compensation Range: $177,500 - $232,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. Create a Job Alert Interested in building your career at Formation Bio? Get future opportunities sent straight to your email. Create alert Apply for this job * indicates a required field Autofill with MyGreenhouse First Name * Last Name * Email * Phone Country Phone Resume/CV * Attach Attach Dropbox Google Drive Enter manually Enter manually Accepted file types: pdf, doc, docx, txt, rtf Cover Letter Attach Attach Dropbox Google Drive Enter manually Enter manually Accepted file types: pdf, doc, docx, txt, rtf LinkedIn Profile Are you legally authorized to work in the United States? * Select... Are you located in or willing to relocate to NYC, Boston, San Francisco, or Research Triangle Park? * Select... If hired by Formation Bio, will you now or in the future require sponsorship for employment visa status (e.g. H-1B, TN, OPT, etc)? * Select... What AI tools have you used, whether in your personal or work life? * Where are you most excited for AI to help your function? * Voluntary Self-Identification For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file. As set forth in Formation Bio’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law. Gender Select... Are you Hispanic/Latino? Select... Race & Ethnicity Definitions If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows: A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to
compensation (or who but for the receipt of military retired pay would be entitled to
compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability. A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service. An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense. An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985. Veteran Status Select... Voluntary Self-Identification of Disability Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026 Why are you being asked to complete this form? We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years. Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp . How do you know if you have a disability? A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to: Alcohol or other substance use disorder (not currently using drugs illegally) Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS Blind or low vision Cancer (past or present) Cardiovascular or heart disease Celiac disease Cerebral palsy Deaf or serious difficulty hearing Diabetes Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders Epilepsy or other seizure disorder Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome Intellectual or developmental disability Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD Missing limbs or partially missing limbs Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS) Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities Partial or complete paralysis (any cause) Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema Short stature (dwarfism) Traumatic brain injury Disability Status Select... PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete. Submit application Powered by Greenhouse
