Senior Data Engineer
About The Position
Bristol Myers Squibb is seeking a Senior Data Engineer to integrate data products from diverse source systems, ensuring quality, performance, and scalability using cloud platforms. This role involves collaborating with business users to gather requirements, defining data access and management needs for clinical, pre-clinical, and translational medicine databases, and designing effective incremental load strategies. The engineer will conduct unit testing, quality assurance, and troubleshoot data quality issues, while also providing support for enterprise data warehousing operations. The position requires integrating multiple data platforms, understanding and supporting the integration of biospecimen data, patient annotation datasets, and study results, and implementing Data Mesh strategies. Telecommuting is permitted up to 3 days per week, with up to 10% domestic travel potentially required.
Requirements
- 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.
- Five (5) years of experience in migrating various types of clinical databases from on-premise to cloud-based data lakes and data warehouses.
- Five (5) years of experience working with clinical databases and tools such as LabMatrix, Informatica, Myriad, Informatica Big Data Management (BMD), Apache Hadoop, Hive, and Snowflake.
- Five (5) years of experience leveraging Amazon Web Services, including Glue, Lambda, Athena, Redshift, S3, and Data Zone to design and implement scalable data solutions.
- Five (5) years of experience developing Extract, Transform, and Load (ETL) processes using AWS Glue, AWS Lambda, and Informatica PowerCenter to create serverless applications.
- Five (5) years of experience optimizing queries for data processing using SQL and NoSQL engines such as SQL server, Oracle, Postgres, and Impala.
- Five (5) years of experience integrating Apache Spark with AWS Athena for real-time data processing and analytics.
- Five (5) years of experience in data visualization using Spotfire, Tableau, or Dotmatics.
- Five (5) years of experience 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.
Responsibilities
- 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.
Benefits
- Medical, pharmacy, dental, and vision care.
- BMS Well-Being Account, BMS Living Life Better, and Employee Assistance Programs (EAP).
- 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.
- Flexible time off (unlimited, with manager approval) for US Exempt Employees.
- 11 paid national holidays (with exceptions for specific locations/employees).
- 160 hours annual paid vacation for new hires (Phoenix, AZ, Puerto Rico and Rayzebio Exempt, Non-Exempt, Hourly Employees) with manager approval.
- 3 optional holidays.
- Unlimited paid sick time (based on eligibility).
- Up to 2 paid volunteer days per year.
- Summer hours flexibility (for eligible US office-based employees).
- Leaves of absence for medical, personal, parental, caregiver, bereavement, and military needs.
- Annual Global Shutdown between Christmas and New Years Day.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
