Intern, D&L Data Analyst

MSD Malaysia; Singapore; On-site; SGD 17,000 - 28,000; Part time

Benefits offered by this job

Hybrid work arrangement

Internship program

Job summary

MSD Malaysia is seeking an intern to assist the distribution and logistics team with data collection and analysis. You will collaborate with internal and external providers, build dashboards, and publish reports in Power BI for management review.

Responsibilities include updating master data, supporting accruals, and improving monthly forecast reporting using Python and Excel. This role offers a hybrid work arrangement and a fixed-term internship for January 2027 intake.

Qualifications

• Bachelors or equivalent degree required.
• Intern/Co-op position for January 2027 intake.
• Experience with data analysis and dashboard creation is preferred.

Responsibilities

• Update material master data with shipping matrix for PP/Forecast.
• Support month-end accruals and enhance reporting.
• Develop Python-based monthly forecast reports and Excel dashboards.
• Build dashboards for volume, forecast, and actual comparisons.
• Publish reports in Power BI for management review.
• Assist in investigations of outliers and update user guides.

Skills

Clinical Supply Chain Management

Cross-Functional Communications

Dashboard Creation

Dashboards Design

Data Analysis

Data Collection Methods

Distribution Management

Driving Continuous Improvement

Freight Management

Inventory Control Management

Logistics

Logistics Coordination

Logistics Management

Logistics Planning

Material Logistics

Materials Procurement

Process Integration

Production Planning

Supply Chain Coordination

Supply Chain Metrics

+ 2 more

Education

Bachelors or equivalent

Tools

Python

Excel

Power BI

Job description

Job Description

The role involves assisting the distribution and logistics team with data collection and analysis. The position requires communication within the supply chain team and coordination with both internal and external providers.

• Update material master data with shipping matrix to facilitate PP/Forecast
• Support month-end accruals
• Enhance existing reports (FG: PP vs Forecast vs Actual; Bulk: PP vs Forecast; Bulk: GR vs IR) using Python scripts for monthly reporting and forecast reporting in Excel reports. This includes on-going data cleansing on Freight Spend Report maintained manually by FBA Team
• To build dashboard for volume & budget forecast and actual comparison
• To publish these reports in PBI for management review
• To facilitate investigation on outliners
• To update user guide

Requirements

• Bachelors or equivalent *Please note this role is for the January 2027 intake

Required Skills

• Clinical Supply Chain Management
• Clinical Supply Chain Management
• Cross-Functional Communications
• Dashboard Creation
• Dashboards Design
• Data Analysis
• Data Collection Methods
• Distribution Management
• Driving Continuous Improvement
• Facilitated Communication
• Freight Management
• Inventory Control Management
• Life Cycle Logistics
• Logistics
• Logistics Coordination
• Logistics Management
• Logistics Planning
• Material Logistics
• Materials Procurement
• Outsourcing Management
• Process Integration
• Production Planning
• Proposal Review
• Supply Chain Coordination
• Supply Chain Metrics
• {+ 2 more}

Preferred Skills

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: Intern/Co-op (Fixed Term) Relocation: VISA Sponsorship: Travel Requirements: Flexible Work Arrangements: Hybrid Shift: Valid Driving License: Hazardous Material(s): Job Posting End Date: 11/30/2026

Our company is a global health care leader with a diversified portfolio of prescription medicines, vaccines and animal health products. The difference between potential and achievement lies in the spark that fuels innovation and inventiveness; this is the space where we have codified our legacy for over a century. Our success is backed by ethical integrity, forward momentum, and an inspiring mission to achieve new milestones in global healthcare.