Data Engineer, Clinical Operations

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. Position Summary: As a Data Engineer, you will play a vital role in supporting the broader Data Engineering community to deliver cutting-edge data and analytics platforms for our Global Drug Development (GDD) IT group — specifically within the Cross Study Operations and Specimen Management domain. We seek a candidate who excels at creating innovative, reliable, secure, and easy-to-use data ecosystems that support the full data product lifecycle — including ingesting, storing, processing, governing, and interacting with data. You will be a hands-on technical expert and individual contributor, applying deep expertise in data engineering, cloud platforms, and Generative AI to solve complex clinical data challenges across cross-study operations and biospecimen workflows, delivering high-quality, scalable data solutions. You will collaborate closely with BI&T partners, business analysts, and data engineers, as well as Clinical Operations specialists, Specimen Management professionals, Cross-Study Operations leads, and other domain experts to support various data-driven initiatives and enhance the overall BMS data ecosystem. You will be expected to leverage Generative AI (GenAI), Databricks, and semantic technologies to drive innovation and efficiency within our data platforms. Key Responsibilities: Collaborate with BI&T partners, cross-study operations leads, specimen management specialists, clinical study teams, clinical trial analysts, trial managers, domain experts, and cross-functional leaders in data engineering, data product teams, and data operations to support effective adoption of our Data Platform. Design, build, and maintain scalable, production-grade data pipelines and platform components supporting Cross Study Operations and Specimen Management product lines, including cross-trial data aggregation, specimen tracking, and biobanking workflows. Develop and enhance data solutions to accelerate data usage across cross-study clinical R&D programs, ensuring robustness, interoperability with consumer applications, and scalability. Optimize data platform components for performance, scalability, interoperability, availability, and cost-effectiveness using techniques such as cloud-native parallel processing, Databricks Delta Lake, caching, and partitioning. Help design and build scalable ETL/ELT pipelines and data models using Databricks, Delta Lake, cloud-native tools, semantic modeling, and interoperability standards for large, complex cross-study and specimen datasets in life sciences. Partner with business and data product owners to deliver hands-on technical solutions for data product development, standardization, testing, lineage, meeting latency requirements, and ensuring access governance across cross-study and specimen management data assets. Utilize Databricks Unity Catalog to enforce data governance, manage metadata, and ensure end-to-end data lineage across cross-study and specimen management data products. Contribute to the development of self-service data discovery solutions, fostering findability, accessibility, and reusability of cross-study operational and specimen data assets. Maintain thorough documentation of processes, data structures, and technical solutions; deliver clear technical recommendations and execute solutions effectively across the enterprise. Help build and deploy GenAI-powered and NLP-driven applications that deliver measurable outcomes across cross-study operations and specimen management, including efficiency gains, specimen traceability improvements, cross-study insight generation, risk mitigation, and compliance automation Develop and operationalize cloud-based GenAI and LLM-powered applications in collaboration with data product owners, engineers, and data scientists, utilizing techniques such as RAG, fine-tuning, and vector embeddings to deliver high-quality data discovery and consumption features for cross-study and specimen management workflows. Leverage Databricks Mosaic AI and MLflow to develop, track, deploy, and manage machine learning and GenAI models at scale within cross-study and specimen management contexts. Stay current on technology trends in GenAI, RAG, semantic search, Databricks, cloud orchestration, and containerization; apply emerging best practices to optimize platform performance, scalability, and cost-effectiveness. Serve as a go-to technical expert within the Cross Study Operations and Specimen Management domain, providing guidance and mentorship to junior analysts, interns, and vendor resources on Databricks, technical best practices, and business alignment. Foster a culture of continuous learning, engineering excellence, and knowledge sharing across the data engineering community. Qualifications & Experience: 5+ years of hands-on experience in Data Engineering, Analytics, and AI/ML, with demonstrated expertise implementing and operating data capabilities and solutions in a cloud environment. Hands-on expertise with Databricks, including Delta Lake, Unity Catalog, Databricks Workflows, Mosaic AI, and MLflow; Databricks certification (e.g., Databricks Certified Data Engineer Associate/Professional) is a strong plus. Demonstrated expertise in cloud-native data platforms, ETL/ELT pipeline design, data modeling, and semantic analytics for large-scale, complex datasets, with hands-on DevOps experience. Strong proficiency in Python, SQL, Spark (including PySpark on Databricks), and GenAI frameworks; hands-on experience with LLM architectures, RAG, prompt engineering, and agentic frameworks. Proficiency in creating and maintaining optimal data pipeline architecture for large, complex datasets, including semantic modeling within a domain — preferably life sciences, clinical trial operations, or specimen/biobanking workflows. Demonstrated experience delivering production-grade GenAI applications, predictive models, and self-service analytics tools supporting critical clinical or research business functions. Working knowledge of LLM and GenAI-driven approaches, including RAG, Chain-of-Thought, fine-tuning, vectorization, agentic frameworks, and prompt engineering techniques for improving the accuracy of LLM-based responses. Strong stakeholder engagement and communication skills; ability to clearly articulate technical concepts to non-technical audiences and drive adoption of data solutions across functional teams. Commitment to engineering excellence, documentation, and process improvement; functional knowledge of Life Sciences R&D and clinical trial operations is highly preferred. 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: Princeton - NJ - US: $87,810 - $106,399 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