Manager, Clinical Data Warehousing & Delivery

Key Skills

Analytical and Problem solving, Data Architecture, Data Modeling, Data science techniques, Data Warehousing, Database, Effective communication skills, ETL frameworks, Management, MySQL, Oracle, SQL

Job Description

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 rich in diversity. 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.

BMS Hyderabad is an integrated global hub where our work is focused on helping patients prevail over serious diseases by building sustainable and innovative solutions. This important science, technology, and innovation center will support a range of technology and drug development activities that will help us usher in the next wave of innovation.

Functional Area Description

CDR&A is responsible for the ingestion, transformation and delivery of clinical data to internal stakeholders, primarily to Biometrics and Data Sciences. CDR&A also acts as the study interface for delivery of reports and analytics to enable effective data review, trial status and risk identification. Engagement of clinical trial functions for reporting and analytic needs. Technical SMEs to ensure expert consultation on data modeling, transformation, and best-fit reporting tools.

Position Summary / Objective

This position is dedicated to the Data Delivery function within Clinical Data Reporting & Analytics. The Manager, Clinical Data Reporting & Analytics to be responsible for identifying and driving innovative and forward-thinking Extract Transform and Load (ETL) solutions to support downstream clinical data reporting and statistical analysis activities. Serve as a primary data delivery contact for stakeholders including data management, reporting and analytics, and biostatistics. Responsible for planning, connecting to the different data sources, designing and developing mappings, scheduling those mappings within the Clinical Data Warehouse, monitoring and maintaining the ETL process within the Clinical Data warehouse.

Position Responsibilities

• Interface/liaise with a variety of end users and leverage technical expertise to define feasible solutions and understand limitations
• Can translate requirements/specifications to programmers
• Can create/develop prototypes for new solutions as applicable
• Create best practices for data loading, transformation, and extraction.
• Provide support, mentoring and training to the team
• Develop data architecture, data modeling, and ETL mapping solutions within structured data warehouse environment which maintain data integrity and traceability across the transformation lifecycle from the Source to Target.
• Supervise design throughout implementation process.
• Develop and implement ETL routines according to the Data Warehouse (DWH) design and architecture.
• Support the development and validation required through the lifecycle of the DWH, maintain user connectivity and provide adequate security for data warehouse.
• Monitor the DWH systems performance and integrity; provide corrective and preventative maintenance as required.
• Manage multiple assignment and smaller projects at once

Degree Requirements BS computer science, programming, data management, scientific or analytic discipline

Experience Requirements 3 years’ experience in the Pharmaceutical Industry

Key Competency Requirements

• Experience with varied Data warehouse tools such as elluminate®, Informatica/SQL/MySQL/ORACLE DB
• Strong understanding of relational databases
• Strong analytic and problem-solving skills
• Proficient in stakeholder engagement and management
• Solution oriented
• Strong communication skills