Manager, Clinical Data Warehousing & Delivery

Scorpion Therapeutics; United States; Remote; USD 109,000 - 134,000; Full time

Job summary

A leading company in the pharmaceutical industry is seeking a Manager for Clinical Data Reporting & Analytics. This role involves driving innovative ETL solutions to support clinical data reporting and statistical analysis activities. Candidates should possess a BS degree in a relevant field and have at least 3 years of experience in the industry. The position is based in Princeton, New Jersey, and offers a competitive salary along with a comprehensive benefits package.

Benefits

Medical, pharmacy, dental and vision care

401(K) plan

Paid vacation and holidays

Tuition reimbursement

Qualifications

• Minimum 3 years' experience in the Pharmaceutical Industry.
• Experience with varied Data warehouse tools.
• Strong understanding of relational databases.

Responsibilities

• Interface with end users to define feasible solutions.
• Develop and implement ETL routines according to the Data Warehouse design.
• Supervise design throughout implementation process.

Skills

Analytic skills

Problem-solving skills

Stakeholder engagement

Communication skills

Education

BS in computer science, programming, data management, scientific or analytic discipline

Tools

Informatica

SQL

MySQL

ORACLE DB

elluminate

Job description

If you're aiming for a job like this, you need an edge.

JobsAI gives you that edge—by helping you upgrade your resume, analyze hiring managers’ LinkedIn profiles, and prepare with a built-in interview coach.

This is the smarter, faster way to compete in today’s job market.

Check out JobsAI

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.

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

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

This position is required onsite in Princeton, New Jersey

• 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

Minimum 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
• Travel Required: Not expected

The starting compensation for this job is a range from 109,850 to 133,100, plus incentive cash and stock opportunities (based on eligibility). The starting pay rate takes into account characteristics of the job, such as required skills and where the job is performed. Final, individual compensation will be decided based on demonstrated experience.

Eligibility for specific benefits listed on our careers site may vary based on the job and location. For more on benefits, please visit http://careers.bms.com/life-at-bms/

Benefit Offerings

Benefit offerings are subject to the terms and conditions of the applicable plans then in effect and may include the following:

• Medical, pharmacy, dental and vision care.
• Wellbeing support such as the BMS Living Life Better program and employee assistance programs (EAP).
• Financial well-being resources and a 401(K).
• Financial protection benefits such as short- and long-term disability, life insurance, supplemental health insurance, business travel protection and survivor support.
• Work-life programs include paid national holidays and optional holidays, Global Shutdown Days between Christmas and New Year's holiday, up to 120 hours of paid vacation, up to two (2) paid days to volunteer, sick time off, and summer hours flexibility.
• Parental, caregiver, bereavement, and military leave.
• Family care services such as adoption and surrogacy reimbursement, fertility/infertility benefits, support for traveling mothers, and child, elder and pet care resources.
• Other perks like tuition reimbursement and a recognition program.

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

Responsibilities

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. For these roles, onsite presence is considered an essential job function and is critical to collaboration, innovation, productivity, and a positive Company culture.
• For 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.

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 [e-mail]. Visit careers.bms.com/eeo-accessibility to access our complete Equal Employment Opportunity statement.

BMS cares about your well-being and the well-being of our staff, customers, patients, and communities. As a result, the Company strongly recommends that all employees be fully vaccinated for Covid-19 and keep up to date with Covid-19 boosters.

BMS will consider for employment qualified applicants with arrest and conviction records, pursuant to applicable laws in your area.

If you live in or expect to work from Los Angeles County if hired for this position, please visit this page for important additional information: https://careers.bms.com/california-residents/

Any data processed in connection with role applications will be treated in accordance with applicable data privacy policies and regulations.