Senior Data Engineer

Overview Senior Data Engineer role at Bristol Myers Squibb. The position involves integrating 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. Design and implement effective incremental load strategies to facilitate efficient data processing. Conduct unit testing and quality assurance, troubleshoot data quality issues to enhance data integrity across platforms. Provide support for enterprise data warehousing operations, ensuring seamless ETL. 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. Telecommuting permitted up to 3 days per week. Up to 10% domestic travel may be required based on business need. 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. Telecommuting permitted up to 3 days per week and travel as required (up to 10% domestically). Qualifications Employer will accept a Bachelor’s degree or foreign equivalent 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 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. Notes Eligibility for specific benefits and other information vary by job and location. For more on benefits, please visit the company careers site. #J-18808-Ljbffr