Data Engineer

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 . Key Responsibilities   The Data Engineer will   be responsible for   d evelop ing   and maintain ing   ETL /ELT   pipelines for ingesting data from various sources into our data warehouse .   Work with an end-to-end ownership mindset, innovate and drive initiatives through completion .   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   enable   adopt ion of   data and technology strategy.    Knowledgeable   in evolving trends in   Data platforms and Product based implementation   Comfortable working in a   fast-paced environment   with minimal oversight   Prior experience working in an Agile/Product based   environment .   Qualifications & Experience   3-5   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   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