Pay
Higher than most similar jobs
$186K–$232K against $127K–$190K, the middle half of what similar US postings state.
From 2,133 postings in the last year. Stated ranges, not salaries paid.
Senior Data Engineer
New York, NY; Boston, MA; San Francisco, CA
Live, first seen by us 44 days ago- Pay
$185,500–232,000/year · Total compensationAnnual period assumed — pay source
Experience working within and building validated computerized systems (CSV) is a plus. Total Compensation Range: $185,500 - $232,000 Compensation Individual compensation is determined by several factors, including role scope, geographic location, and skills & experience. Your offer will reflect where you fall within the range based on these considerations. In addition to base salary, we offer equity, comprehensive benefits, and generous perks. If the posted range doesn't match your expectations, we still encourage you to apply!
Read the full posting- Work setting
- Not stated
- Employment
- Not stated
What you’ll work on
Full postingDesign and operate production pipelines ingesting clinical, operational, and vendor data
Own shared data models, data contracts, transformations, and orchestration
Partner with Product Engineering on application data models and APIs
Build training datasets and feature pipelines with Data Science
Set data quality, testing, lineage, and observability practices
From the employer’s posting
Design and operate production data systems that ingest clinical, operational, and third-party vendor data into reliable, queryable data products.
Own shared and canonical data models, data contracts, transformations, orchestration, warehouse models, and downstream interfaces.
Partner with Product Engineering on application data models, source-system contracts, APIs, events, and data access patterns.
Partner with Data Science on productionized training datasets, feature pipelines, data interfaces, and ML use cases.
Establish strong data quality, testing, freshness, completeness, lineage, documentation, and observability practices.
What you’ll bring
All qualificationsCore experience
- 5+ years of relevant data engineering experience building and operating production data systems.
- Experience with pharmaceutical, biology, HIPPA or other regulated data core to BioTech is required.
- Strong Python and SQL skills, with deep experience in data modeling and warehouse systems, especially Snowflake.
- Experience with Dagster as an orchestration systems (or equivalent) transformation tooling such as dbt or an equivalent approach.
- Experience with data contracts, schema evolution, data quality testing, observability, lineage, and production incident response.
- Experience integrating messy clinical, operational, vendor, or otherwise complex source data.
Preferred experience
- Experience working within and building validated computerized systems (CSV) is a plus.
Qualification wording
5+ years of relevant data engineering experience building and operating production data systems.
Experience with pharmaceutical, biology, HIPPA or other regulated data core to BioTech is required.
Strong Python and SQL skills, with deep experience in data modeling and warehouse systems, especially Snowflake.
Experience with Dagster as an orchestration systems (or equivalent) transformation tooling such as dbt or an equivalent approach.
Experience with data contracts, schema evolution, data quality testing, observability, lineage, and production incident response.
Experience integrating messy clinical, operational, vendor, or otherwise complex source data.
Experience working within and building validated computerized systems (CSV) is a plus.
About Formation Bio
At Formation Bio, our values are the driving force behind our mission to revolutionize the pharma industry.
In the employer’s words · Read in context
Posting record
Report an error- Status in our records
- Live
- First seen by us
- Sep 21, 202644 days ago
- Recorded sightings
- 29
- Last seen by us
- Nov 5, 2026
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
How this job compares
Time since we first saw it
Day 44
Similar jobs usually come down between day 6 and day 54.
At Formation Bio, jobs usually come down by about day 190.
From 10,957 similar postings that came down, and 6 of Formation Bio’s. Coming down is not always a hire.
Formation Bio is hiring
7 open jobs
Open jobs by the week we first saw them, last 12 weeks.
- Its jobs tend to stay up a long time
See how this role fits your experience
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- Python
- SQL
- dbt
- Docker
- Snowflake
- Terraform
- Dagster
Where the posting names them
- Experience with pharmaceutical, biology, HIPPA or other regulated data core to BioTech is required. - Strong Python and SQL skills, with deep experience in data modeling and warehouse systems, especially Snowflake. - Experience with Dagster as an orchestration systems (or equivalent) transformation tooling such as dbt or an equivalent approach.
- Strong Python and SQL skills, with deep experience in data modeling and warehouse systems, especially Snowflake. - Experience with Dagster as an orchestration systems (or equivalent) transformation tooling such as dbt or an equivalent approach. - Experience with data contracts, schema evolution, data quality testing, observability, lineage, and production incident response.
- Experience integrating messy clinical, operational, vendor, or otherwise complex source data. - Working knowledge of Docker, GitHub, and Terraform or OpenTofu sufficient to partner effectively with SRE. - Experience building data products and access patterns for applications, Data Science, analytics, human users, and AI Enabled Employees and Agents.
Your next step
Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.
Applying through Greenhouse
- No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
- Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.
Already applied? Track this application
About the role
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
US government figures for database architects
- Median yearly pay, May 2025
- $139,500
- Expected change, 2025 to 2035
- 9.4% more jobsagainst 3.5% for all jobs
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
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, John Doerr, Spark Capital, SV Angel Growth, and others.
You can read more at the following links:
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
As a Senior Data Engineer at Formation Bio, you will build the trusted data systems that support clinical operations, drug asset evaluation, business development, analytics, and machine learning through AI Enabled Employees and Agents. You will work across clinical, operational, and third-party data sources to design and operate reliable ingestion pipelines, transformations, data models, and data products.
This role sits at the intersection of Product Engineering, Data Engineering, and Data Science. You will help shape how application data is modeled and exposed, own shared data models and production data products, and prioritize data platform work against clinical and business needs. You will work closely with Product Engineering on application data models and contracts, with Data Science on training datasets and ML use cases, and with human and AI consumers of the data platform.
A data product is not complete merely because it is technically correct or available in a warehouse. It should be understandable to people, usable by applications, useful to Data Science, and structured so AI Enabled Employees and Agents can access it reliably and safely.
Responsibilities
- Design and operate production data systems that ingest clinical, operational, and third-party vendor data into reliable, queryable data products.
- Own shared and canonical data models, data contracts, transformations, orchestration, warehouse models, and downstream interfaces.
- Partner with Product Engineering on application data models, source-system contracts, APIs, events, and data access patterns.
- Partner with Data Science on productionized training datasets, feature pipelines, data interfaces, and ML use cases.
- Turn recurring data cleaning, normalization, and transformation work into versioned, tested, observable, and maintainable production pipelines.
- Build data products for clinical operations, asset evaluation, Business Development, analytics, machine learning, and AI Enabled Employees and Agents.
- Design data products that are semantically clear, discoverable, machine-readable, permission-aware, traceable, and safe to query.
- Establish strong data quality, testing, freshness, completeness, lineage, documentation, and observability practices.
- Own data governance practices for sensitive and regulated data, including access controls, auditability, traceability, and appropriate data handling.
- Participate in support and incident response for data platform issues, including diagnosis, stakeholder communication, remediation, and prevention of recurrence.
- Use AI tools, including LLMs and agentic coding systems, to accelerate pipeline development, data modeling, debugging, documentation, and data quality investigation while validating their output.
- Contribute to architecture and design reviews, mentor other engineers, and improve the engineering practices used across the organization.
About You
- 5+ years of relevant data engineering experience building and operating production data systems.
- Experience with pharmaceutical, biology, HIPPA or other regulated data core to BioTech is required.
- Strong Python and SQL skills, with deep experience in data modeling and warehouse systems, especially Snowflake.
- Experience with Dagster as an orchestration systems (or equivalent) transformation tooling such as dbt or an equivalent approach.
- Experience with data contracts, schema evolution, data quality testing, observability, lineage, and production incident response.
- Experience integrating messy clinical, operational, vendor, or otherwise complex source data.
- Working knowledge of Docker, GitHub, and Terraform or OpenTofu sufficient to partner effectively with SRE.
- Experience building data products and access patterns for applications, Data Science, analytics, human users, and AI Enabled Employees and Agents.
- Strong judgment about when to build reusable platform capabilities versus one-off stakeholder solutions.
- Daily fluency with AI tools and the ability to validate generated code, transformations, and data-modeling decisions.
- Exceptional collaboration and communication skills across Product Engineering, Data Science, Clinical Operations, Data Management, Business Development, and other non-technical partners.
- Experience working within and building validated computerized systems (CSV) is a plus.
Total Compensation Range: $185,500 - $232,000
Compensation Individual compensation is determined by several factors, including role scope, geographic location, and skills & experience. Your offer will reflect where you fall within the range based on these considerations. In addition to base salary, we offer equity, comprehensive benefits, and generous perks. If the posted range doesn't match your expectations, we still encourage you to apply!
Where We Hire Formation Bio is prioritizing hiring in key hubs, primarily the New York City and Boston metro areas, with a hybrid model requiring 3 days per week in office. Applicants from the Research Triangle (NC) and San Francisco Bay Area may also be considered. Please apply only if you reside in these locations or are willing to relocate.
Equal Opportunity Formation Bio is committed to building a diverse and inclusive team. We are an equal opportunity employer and welcome candidates from all backgrounds. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, ancestry, sex (including pregnancy, childbirth, breastfeeding, and related medical conditions), gender identity or expression, sexual orientation, age, disability, genetic information, marital status, military or veteran status, or any other characteristic protected by federal, state, or local law.
We've seen a rise in recruiting impersonation scams across the industry, where fake profiles pose as recruiters aiming to trick candidates into sharing personal and financial information through illegitimate interviews and job offers. All legitimate recruiting communications from Formation Bio will come from a @formation.bio email address. If you receive outreach from someone claiming to work at Formation Bio through any other domain or channel, please disregard it and do not share any personal information.
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
Experience working within and building validated computerized systems (CSV) is a plus. Total Compensation Range: $185,500 - $232,000 Compensation Individual compensation is determined by several factors, including role scope, geographic location, and skills & experience. Your offer will reflect where you fall within the range based on these considerations. In addition to base salary, we offer equity, comprehensive benefits, and generous perks. If the posted range doesn't match your expectations, we still encourage you to apply!
- Location & working pattern
New York, NY; Boston, MA; San Francisco, CA
This passage needs a closer read in the full description.
- Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.