Senior 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.

Career Information

Compensation Overview Tampa – FL - US: $147,948.00 - $157,550.00

• 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.

Duties

• Integrate data products from diverse source systems to ensure quality, performance and scalability using cloud platforms.
• Collaborate with business users to gather requirements and translate them into comprehensive mapping documents that can be implemented as data products.
• Define requirements for accessing and managing clinical, pre-clinical, and translational medicine databases.
• Design and implement effective incremental load strategies to facilitate efficient data processing.
• Conduct unit testing, quality assurance, and troubleshoot data quality issues to enhance data integrity across platforms.
• Provide support for enterprise data warehousing operations, ensuring seamless data extraction, transformation, and loading (ETL).
• Work on integrating multiple data platforms and ensure standardized data processes.
• Engage with scientific teams to understand and support the integration of biospecimen data, patient annotation datasets, and results of preclinical and translational studies.
• Understand and implement Data Mesh strategies to align decentralized data ownership with business objectives.

Requirements

• Employer will accept a Bachelor’s degree or foreign equivalent degree in Computer Science, or a related field, and five (5) years of progressive post-baccalaureate related work experience as a Data Scientist or related occupation.
• Requires five (5) years of experience in the following skills (which may be gained concurrently):
  • Migrating various types of clinical databases from on-premise to cloud-based data lakes and data warehouses;
  • Working with clinical databases and tools such as LabMatrix, Informatica, Myriad, Informatica Big Data Management (BMD), Apache Hadoop, Hive, and Snowflake;
  • Leveraging Amazon Web Services, including Glue, Lambda, Athena, Redshift, S3, and Data Zone to design and implement scalable data solutions;
  • Developing Extract, Transform, and Load (ETL) processes using AWS Glue, AWS Lambda, and Informatica PowerCenter to create serverless applications;
  • Optimizing queries for data processing using SQL and NoSQL engines such as SQL server, Oracle, Postgres, and Impala;
  • Integrating Apache Spark with AWS Athena for real-time data processing and analytics;
  • Data visualization using Spotfire, Tableau, or Dotmatics;
  • Applying protocols and standards in biopharmaceutical research and development, including preclinical research, clinical trials, biologics data management, genetic biomarkers, translational research, and non-clinical (In Vivo) data management.
• 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/.

Telecommuting

Telecommuting permitted up to 3 days per week.

Travel

• Up to 10% domestic travel may be required based on business need.

Benefits

• 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
• Global Shutdown: An annual Global Shutdown between Christmas and New Years Day.
• Summer Hours Flexibility: Available for some employees.

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.
• 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.

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.