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.
Position: Data Engineer II – Data & Analytics IT • GDD Data Product - Safety & Regulatory
Location: LVL, New Jersey, US
Position Summary: As a Data Engineer II, you will help build and operate reliable, secure, and user-centric data and analytics capabilities for Global Drug Development (GDD) across Safety and Regulatory data products. You will design and optimize cloud-native data pipelines, dimensional models, and self-service analytics to support Pharmacovigilance (PV) scientists, Regulatory specialists, and cross-functional stakeholders. You will also leverage GenAI and semantic search techniques (e.g., RAG, vector embeddings) to improve data discovery, compliance automation, and decision support. This role is ideal for an engineer with 3–5 years of experience who thrives in regulated environments, can reverse-engineer complex systems, and enjoys turning ambiguous requirements into scalable, production-grade solutions.
Key Responsibilities:
Contribute to cross-functional data and AI initiatives across WWPS and Regulatory product lines; collaborate closely with PV scientists, Regulatory leads, data product owners, and engineering teams to deliver high-impact outcomes.
Design, build, and optimize scalable ETL/ELT pipelines and data models using AWS-native services (e.g., S3, Redshift) and Spark for large, complex life-sciences datasets; implement robust orchestration (e.g., cron or similar) and monitoring.
Develop and maintain dimensional models and data marts; define clear source-to-target mappings, data lineage, and documentation to support auditability, validation, and reuse.
Migrate and modernize data pipelines (e.g., Postgres to Redshift), reducing refresh latency and improving availability, performance, and cost efficiency through techniques like partitioning, distribution/sort keys, and caching.
Architect and deliver GenAI/NLP-powered features for data discovery and compliance automation using RAG, vector embeddings (e.g., FAISS), and frameworks like LangChain with OpenAI/Anthropic/Llama.
Build self-service analytics and interactive dashboards (Tableau, QuickSight, Power BI) to support operational and regulatory decision-making (e.g., query forecasting, submission tracking, safety signal exploration).
Ingest and harmonize data from multiple clinical programs into S3-backed data lakes; implement Spark transforms and Redshift models to expand safety and adverse event data domains.
Partner with PV and QA teams to plan and execute functional/regression/validation testing; document test evidence and support GxP-aligned processes to ensure high-quality releases.
Drive PoCs for governance and analytics, evaluate emerging patterns, and translate learnings into scalable platform capabilities.
Contribute to engineering standards, code reviews, and documentation; collaborate with onshore/offshore teams and mentor interns/junior analysts on best practices and business alignment.
Stay current on trends in GenAI, RAG, vector databases, semantic search, and cloud data engineering; propose and integrate best practices for continuous platform improvement.
Qualifications & Experience:
3–5 years of hands-on experience in Data Engineering/Analytics delivering production-grade data pipelines, models, and analytics in a cloud environment (AWS preferred) within regulated or life-sciences settings (highly preferred).
Bachelor’s degree in Engineering or a Scientific discipline required; Master’s degree in Analytics or related field preferred.
Proficiency in Python and SQL with experience in Spark (PySpark) for data processing; strong Linux/shell scripting skills.
Demonstrated experience with AWS data services and tooling, including S3 and Redshift; familiarity with data lake patterns and scheduling/orchestration (e.g., cron or similar tools).
Proven capability in dimensional modeling, data mart design, and source-to-target mapping with strong documentation and lineage practices.
Hands-on experience operationalizing dashboards and self-service analytics using Spotfire and/or powerBI; familiarity with Quicksight is a plus.
Practical experience building GenAI/NLP features: RAG pipelines, vector embeddings (e.g., FAISS), prompt engineering, and frameworks such as LangChain; familiarity with OpenAI/Anthropic/Llama.
Strong stakeholder engagement and communication skills; demonstrated ability to collaborate across onshore/offshore teams and drive clarity from ambiguous requirements.
Experience in communication and stakeholder engagement; ability to reverse engineer and document complex systems, as well as support adoption among cross-functional teams.
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:
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 in effect at the time and may require enrollment. Our benefits include:
Health Coverage: Medical, pharmacy, dental, and vision care.
Wellbeing Support: Programs such as BMS Well-Being Account, BMS Living Life Better, and Employee Assistance Programs (EAP).
Financial Well-being and Protection: 401(k) plan, short- and long-term disability, life insurance, accident insurance, supplemental health insurance, business travel protection, personal liability protection, identity theft benefit, legal support, and survivor support.
Work-life benefits include:
Paid Time Off
US Exempt Employees: flexible time off (unlimited, with manager approval, 11 paid national holidays (not applicable to employees in Phoenix, AZ, Puerto Rico or Rayzebio employees)
Phoenix, AZ, Puerto Rico and Rayzebio Exempt, Non-Exempt, Hourly Employees: 160 hours annual paid vacation for new hires with manager approval, 11 national holidays, and 3 optional holidays
Based on eligibility*, additional time off for employees may include unlimited paid sick time, up to 2 paid volunteer days per year, summer hours flexibility, leaves of absence for medical, personal, parental, caregiver, bereavement, and military needs and an annual Global Shutdown between Christmas and New Years Day.
All global employees full and part-time who are actively employed at and paid directly by BMS at the end of the calendar year are eligible to take advantage of the Global Shutdown.
*Eligibility Disclosure: The summer hours program is for United States (U.S.) office-based employees due to the unique nature of their work. Summer hours are generally not available for field sales and manufacturing operations and may also be limited for the capability centers. Employees in remote-by-design or lab-based roles may be eligible for summer hours, depending on the nature of their work, and should discuss eligibility with their manager. Employees covered under a collective bargaining agreement should consult that document to determine if they are eligible. Contractors, leased workers and other service providers are not eligible to participate in the 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.
Supporting People with Disabilities
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/eeo-accessibility to access our complete Equal Employment Opportunity statement.
Candidate Rights
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/
Data Protection
We will never request payments, financial information, or social security numbers during our application or recruitment process. Learn more about protecting yourself at https://careers.bms.com/fraud-protection.
Any data processed in connection with role applications will be treated in accordance with applicable data privacy policies and regulations.
If you believe that the job posting is missing information required by local law or incorrect in any way, please contact BMS at TAEnablement@bms.com. Please provide the Job Title and Requisition number so we can review. Communications related to your application should not be sent to this email and you will not receive a response. Inquiries related to the status of your application should be directed to Chat with Ripley.
R1599531 : Data Engineer II – Data & Analytics IT • GDD Data Product - Safety & Regulatory