EG-100 - Information Technology / Data Architecture

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.

• The Data Engineer will be responsible for designing, building, and maintaining the ETL pipelines, data products, evolution of the data products, and utilize the most suitable data architecture required for our organization's data needs.
• Responsible for delivering high quality, data products and analytic ready data solution
• Work with an end-to-end ownership mindset, innovate and drive initiatives through completion.
• Develop and maintain data models to support our reporting and analysis needs
• Optimize data storage and retrieval to ensure efficient performance and scalability
• Collaborate with data architects, data analysts and data scientists to understand their data needs and ensure that the data infrastructure supports their requirements
• Ensure data quality and integrity through data validation and testing
• Implement and maintain security protocols to protect sensitive data
• Stay up-to-date with emerging trends and technologies in data engineering and analytics
• Closely partner with the Enterprise Data and Analytics Platform team, other functional data teams and Data Community lead to shape and adopt data and technology strategy.
• Serves as the Subject Matter Expert on Data & Analytics Solutions.
• Knowledgeable in evolving trends in Data platforms and Product based implementation
• Has end-to-end ownership mindset in driving initiatives through completion
• Comfortable working in a fast-paced environment with minimal oversight
• Mentors other team members effectively to unlock full potential
• Prior experience working in an Agile/Product based environment

• 5-8 years of hands-on experience working on implementing and operating data capabilities and cutting-edge data solutions, preferably in a cloud environment.  Breadth of experience in technology capabilities that span the full life cycle of data management including data lakehouses, master/reference data management, data quality and analytics/AI ML is needed. 
• Expertise in Databricks – SME grade.
• Expertise in designing and building real time data ingestion data pipelines in AWS
• Expertise in CloudFormation  
• Developing and using Custom Resources in CFTs 
• Expertise in developing GitHub Workflows & integrating GitHub workflows with AWS
• Expertise with using boto3 apis for Lambda, S3, Glue, Crawlers, Data Zone (preferred)
• Expert in building APIs using AWS services  
• In-depth knowledge and hands-on experience with ASW Glue services and AWS Data engineering ecosystem.
• Hands-on experience developing and delivering data, ETL solutions with some of the technologies like AWS data services (Redshift, Athena, lakeformation, etc.), Cloudera Data Platform, Tableau labs is a plus
• 5+ years of experience in data engineering or software development
• Create and maintain optimal data pipeline architecture, assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Strong programming skills in languages such as Python, R, PyTorch, PySpark, Pandas, Scala etc.
• Experience with SQL and database technologies such as MySQL, PostgreSQL, Presto, etc.
• Experience with cloud-based data technologies such as AWS, Azure, or Google Cloud Platform
• Strong analytical and problem-solving skills
• Excellent communication and collaboration skills Functional knowledge or prior experience in Lifesciences Research and Development domain is a plus
• Experience and expertise in establishing agile and product-oriented teams that work effectively with teams in US and other global BMS site.  
• Initiates challenging opportunities that build strong capabilities for self and team
• Demonstrates a focus on improving processes, structures, and knowledge within the team. Leads in analyzing current states, deliver strong recommendations in understanding complexity in the environment, and the ability to execute to bring complex solutions to completion.​

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.

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.

R1601138 : EG-100 - Information Technology / Data Architecture