Job Description

The Global Clinical Supply (GCS) organization is within our Research and Development division and is accountable for managing the 'end-to-end' integrated clinical supply chain across our Research & Development division portfolio to enable the execution of any clinical trial using our company's asset. GCS supports more than 300 Phase I-IV clinical trials run in-house, 400+ outsourced or run by partners as well as our company's ISS clinical trials (300+). GCS is accountable for the planning, sourcing, labeling, packaging and delivery of clinical supplies to clinical sites across more than 60+ countries, all in accordance with US and WW regulations, company policies and Standard Operating Procedures.

The Associate Director, Business Insights and Analytics (BI&A), is responsible for

• Developing the GCS strategy for business insights and analytics

• Setting appropriate business measures with key stakeholders to drive GCS performance

• Delivering tools and solutions for digital visualizations of KPIs

The Associate Director, BI&A, will:

• Execute solutions to business needs by designing and implementing new data management systems

• Employ innovation and technology solutions to manage data warehousing more effectively

• Automate reporting and visualizations efficiently

• Work strategically and tactically to streamline processes and eliminate manual work in current reporting processes

• Focus on reports to increase business efficiency and metrics as KPIs, contributing to the overall performance within GCS

This role will also be responsible for upskilling GCS in the applications used for reporting. The Associate Director, BI&A will help in driving the strategic performance of the overall GCS organization through visualization of key business insights via data analytics. This role will contribute to the advancement of the GCS Data Strategy and Strategic Roadmap, supporting the organization’s transition toward future-ready systems and modern data architectures.

Primary Activities

• Design and develop interactive dashboards, reports, and visualizations using enterprise systems (Qlik Sense, Power BI ThoughtSpot).
• Write and optimize complex SQL queries to extract, transform, and load (ETL) data from various sources into BI platforms.
• Support Microsoft Power Platform integration by developing solutions (Power Apps, and Power Automate) to enhance business processes.
• Work with data architects to ensure scalable and efficient data models and pipelines.
• Use GitHub for version control of scripts, data models, and BI artifacts to ensure collaboration and code quality.
• Experience leveraging Databricks for big data processing, advanced analytics, or machine learning workflows, as needed.
• Collaborate with business stakeholders to gather requirements, translate them into technical specifications, and deliver actionable insights.
• Ensure data accuracy, consistency, and security across all BI solutions.
• Document processes, data models, and solutions; provide training to end-users during tool transitions.

Required Skills and Qualifications

• Experience: 3+ years in BI development, data analysis, or a related role.
• Proficiency with BI Tools (Qlik Sense, Power BI, ThoughtSpot is a plus).
• Strong expertise in writing and optimizing SQL queries for data extraction and transformation.
• Familiarity with Power Apps, and/or Power Automate is preferred, with a willingness to upskill.
• Experience with GitHub or similar platforms for version control and collaboration.
• Understanding of data modeling, ETL processes, and data warehousing concepts.
• Strong analytical, problem-solving, and communication skills to work with technical and non-technical stakeholders.
• Aptitude to integrate data solutions
• Strong Influencing and negotiation skills
• Ability to lead, create future state, and deliver results
• Demonstrated ability to develop strong, trust based, collaborative relationships to drive change and execute on priorities with a diverse group of stakeholders
• Strategic thinking and independent decision-making abilities
• Demonstrated ability to communicate clearly, effectively and tactfully to interact with different global professional levels and external stakeholders
• Excellent written and verbal communication

Education and Skills

Bachelor's degree or equivalent experience required.

#eligibleforERP

#GCSCareer

Current Employees apply HERE

Current Contingent Workers apply HERE

US and Puerto Rico Residents Only:

Our company is committed to inclusion, ensuring that candidates can engage in a hiring process that exhibits their true capabilities. Please click here if you need an accommodation during the application or hiring process.

As an Equal Employment Opportunity Employer, we provide equal opportunities to all employees and applicants for employment and prohibit discrimination on the basis of race, color, age, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status, or other applicable legally protected characteristics. As a federal contractor, we comply with all affirmative action requirements for protected veterans and individuals with disabilities. For more information about personal rights under the U.S. Equal Opportunity Employment laws, visit:

EEOC Know Your Rights

EEOC GINA Supplement​

We are proud to be a company that embraces the value of bringing together, talented, and committed people with diverse experiences, perspectives, skills and backgrounds. The fastest way to breakthrough innovation is when people with diverse ideas, broad experiences, backgrounds, and skills come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively.

Learn more about your rights, including under California, Colorado and other US State Acts

U.S. Hybrid Work Model

Effective September 5, 2023, employees in office-based positions in the U.S. will be working a Hybrid work consisting of three total days on-site per week, Monday - Thursday, although the specific days may vary by site or organization, with Friday designated as a remote-working day, unless business critical tasks require an on-site presence.This Hybrid work model does not apply to, and daily in-person attendance is required for, field-based positions; facility-based, manufacturing-based, or research-based positions where the work to be performed is located at a Company site; positions covered by a collective-bargaining agreement (unless the agreement provides for hybrid work); or any other position for which the Company has determined the job requirements cannot be reasonably met working remotely. Please note, this Hybrid work model guidance also does not apply to roles that have been designated as “remote”.

The salary range for this role is

$126,500.00 - $199,100.00

This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. An employee’s position within the salary range will be based on several factors including, but not limited to relevant education, qualifications, certifications, experience, skills, geographic location, government requirements, and business or organizational needs.

The successful candidate will be eligible for annual bonus and long-term incentive, if applicable.

We offer a comprehensive package of benefits. Available benefits include medical, dental, vision healthcare and other insurance benefits (for employee and family), retirement benefits, including 401(k), paid holidays, vacation, and compassionate and sick days. More information about benefits is available at https://jobs.merck.com/us/en/compensation-and-benefits.

You can apply for this role through https://jobs.merck.com/us/en (or via the Workday Jobs Hub if you are a current employee). The application deadline for this position is stated on this posting.

San Francisco Residents Only: We will consider qualified applicants with arrest and conviction records for employment in compliance with the San Francisco Fair Chance Ordinance

Los Angeles Residents Only: We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance

Search Firm Representatives Please Read Carefully
Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.

Employee Status:

Regular

Relocation:

No relocation

VISA Sponsorship:

No

Travel Requirements:

No Travel Required

Flexible Work Arrangements:

Hybrid

Shift:

Not Indicated

Valid Driving License:

No

Hazardous Material(s):

n/a

Required Skills:

Agile Data Warehousing, Agile Data Warehousing, Business Data Analytics, Business Intelligence Development, Business Process Automation, Business Processes, Business Process Management (BPM), Business Support, CAPA Management, Clinical Supply Chain Management, Clinical Testing, Communications Support, Customer Experience Optimization, Customer-Focused, Databricks Unified Data Analytics Platform, Driving Continuous Improvement, Enterprise Systems, Financial Accounting Controls, Financial Operations, GitHub, Human Resources (HR) Shared Services Advisory, Meeting Leadership, Outsourcing, Quantitative Analytics, Standard Operating Procedure (SOP) {+ 2 more}

Preferred Skills:

Job Posting End Date:

07/18/2025

*A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.

Requisition ID:R356802