Senior Data Engineer, Translational Data Products

Job description

**Working with Us**
Challenging.

Meaningful.

Life-changing.

Those aren't words that are usually associated with a job.

But working at Bristol Myers Squibb is anything but usual.

Here, uniquely interesting work happens every day, in every department.

From optimizing a production line to the latest breakthroughs in cell therapy, this is work that transforms the lives of patients, and the careers of those who do it.

You'll get the chance to grow and thrive through opportunities uncommon in scale and scope, alongside high-achieving teams.

Take your career farther than you thought possible.

Bristol Myers Squibb recognizes the importance of balance and flexibility in our work environment.

We offer a wide variety of competitive benefits, services and programs that provide our employees with the resources to pursue their goals, both at work and in their personal lives.

Read more: careers.bms.com/working-with-us .

**Summary:**

As part of the Translational Data Products team, you will directly support translational medicine leaders in their mission to discover biomarkers that guide patient selection and treatment response for BMS assets.

Your work will enable exploratory data analysis that drives crucial biomarker decisions at the heart of translational research.

You will bridge data engineering with innovation: orchestrating advanced pipelines, ensuring auto-generated ETL and schema mappings are correct, and experimenting with the newest techniques-such as MCP servers, prompt engineering strategies (ReACT, chain-of-thought, etc.), and LLM-assisted tooling-to make biomarker data accessible, trustworthy, and actionable.

**Key Responsibilities:**

+ **Enable biomarker discovery:** Deliver data pipelines and mappings that help translational leaders identify biomarkers (molecular, digital, imaging) for patient stratification and treatment response.
+ **Innovate with AI/LLMs:** Explore and apply cutting-edge approaches (MCP servers, prompt orchestration, auto-schema mapping, LLM-based ETL generation) to accelerate and improve data workflows.
+ **Data orchestration:** Oversee ingestion from diverse sources (vendor feeds, raw instruments, CSV, PDF, etc.), ensuring automated ETL and sample-to-target mapping & transformation (STTM) outputs meet stakeholder needs.
+ **Quality and profiling:** Assess and validate source data, documenting any cleaning, normalization of semantic mapping that needs to be applied for optimal QC, and identify where improvements are required vs merely convenient.
+ **Hands-on implementation:** Build or adapt tools/scripts (Python, SQL, AWS Glue, Databricks, etc.) when automation falls short.
+ **Stakeholder collaboration:** Act as a partner to translational medicine leaders-communicating progress, and brainstorming next steps as priorities evolve.
+ **Agile team contribution:** Participate actively in standups, design sessions, sprint demos and innovation discussions.

**Qualifications:**

+ Bachelor's or Master's degree in Computer Science, Data Engineering, Bioinformatics, or related field.
+ 5+ years of experience in data engineering, ideally with exposure to life sciences or healthcare.
+ Strong experience with data integration from heterogeneous sources (structured, semi-structured, unstructured).
+ Proficiency in AWS, Python and SQL, with ability to prototype and automate workflows.
+ Hands-on expertise with ETL frameworks (AWS Glue, Databricks, Airflow)
+ Familiarity with modern AI/LLM approaches for data transformation and semantic mapping is highly desirable.
+ Excellent communication skills to engage both technical and scientific stakeholders.
+ Comfortable in agile, exploratory, scientific environments

**What Makes This Role Unique:**

+ **Direct scientific impact:** Your work connects directly to patient-centric translational decisions.
+ **Innovation:** You are encouraged to explore new technologies and approaches, not just maintain existing ones.
+ **Automation first:** Instead of building every pipeline from scratch, you orchestrate and validate auto-generated ETLs and mappings.
+ **Collaborative science + engineering:** You will brainstorm with scientists, demo working solutions, and help shape the future of translational data products.

If you come across a role that intrigues you but doesn't perfectly line up with your resume, we encourage you to apply anyway.

You could be one step away from work that will transform your life and career.

**Compensation Overview:**

Cambridge Crossing: $148,850 - $180,374
San Diego - CA - US: $148,850 - $180,374
Tampa - FL - US: $135,320 - $163,976

The starting compensation range(s) for this role are listed above for a full-time employee (FTE) basis.

Additional incentive cash and stock opportunities (based on eligibility) may be available.

The starting pay rate takes into account characteristics of the job, such as required skills, where the job is performed, the employee's work schedule, job-related knowledge, and experience.

Final, individual compensation will be decided based on demonstrated experience.

Eligibility for specific benefits listed on our careers site may vary based on the job and location.

For more on benefits, please visit https://careers.bms.com/life-at-bms/.

Benefit offerings are subject to the terms and conditions of the applicable plans then in effect and may include the following: Medical, pharmacy, dental and vision care.

Wellbeing support such as the BMS Living Life Better program and employee assistance programs (EAP).

Financial well-being resources and a 401(K).

Financial protection benefits such as short- and long-term disability, life insurance, supplemental health insurance, business travel protection and survivor support.

Work-life programs include paid national holidays and optional holidays, Global Shutdown Days between Christmas and New Year's holiday, up to 120 hours of paid vacation, up to two (2) paid days to volunteer, sick time off, and summer hours flexibility.

Parental, caregiver, bereavement, and military leave.

Family care services such as adoption and surrogacy reimbursement, fertility/infertility benefits, support for traveling mothers, and child, elder and pet care resources.

Other perks like tuition reimbursement and a recognition program.

**Uniquely Interesting Work, Life-changing Careers**
With a single vision as inspiring as Transforming patients' lives through science™ , every BMS employee plays an integral role in work that goes far beyond ordinary.

Each of us is empowered to apply our individual talents and unique perspectives in a supportive culture, promoting global participation in clinical trials, while our shared values of passion, innovation, urgency, accountability, inclusion and integrity bring out the highest potential of each of our colleagues.

**On-site Protocol**

BMS has an occupancy structure that determines where an employee is required to conduct their work.

This structure includes site-essential, site-by-design, field-based and remote-by-design jobs.

The occupancy type that you are assigned is determined by the nature and responsibilities of your role:

Site-essential roles require 100% of shifts onsite at your assigned facility.

Site-by-design roles may be eligible for a hybrid work model with at least 50% onsite at your assigned facility.

For these roles, onsite presence is considered an essential job function and is critical to collaboration, innovation, productivity, and a positive Company culture.

For field-based and remote-by-design roles the ability to physically travel to visit customers, patients or business partners and to attend meetings on behalf of BMS as directed is an essential job function.

BMS is dedicated to ensuring that people with disabilities can excel through a transparent recruitment process, reasonable workplace accommodations/adjustments and ongoing support in their roles.

Applicants can request a reasonable workplace accommodation/adjustment prior to accepting a job offer.

If you require reasonable accommodations/adjustments in completing this application, or in any part of the recruitment process, direct your inquiries to adastaffingsupport@bms.com .

Visit careers.bms.com/ (https://careers.bms.com/eeo-accessibility) eeo-accessibility to access our complete Equal Employment Opportunity statement.

BMS cares about your well-being and the well-being of our staff, customers, patients, and communities.

As a result, the Company strongly recommends that all employees be fully vaccinated for Covid-19 and keep up to date with Covid-19 boosters.

BMS will consider for employment qualified applicants with arrest and conviction records, pursuant to applicable laws in your area.

If you live in or expect to work from Los Angeles County if hired for this position, please visit this page for important additional information: https://careers.bms.com/california-residents/

Any data processed in connection with role applications will be treated in accordance with applicable data privacy policies and regulations.
**Company:** Bristol-Myers Squibb
**Req Number:** R1594798
**Updated:** 2025-10-23 05:58:27.848 UTC
**Location:** Lawrence Township-NJ
Bristol Myers Squibb is an equal opportunity employer.

Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, pregnancy, citizenship, marital status, gender expression, genetic information, political affiliation, or any other characteristic protected by law.

Required Skill Profession

Other General