Intern, D&L Data Analyst

msd; Singapore; Hybrid; SGD 20,000 - 27,000; Part time

Job summary

MSD Singapore is offering an internship in the distribution and logistics data analytics team. You will assist the team with data collection, coordinate with internal and external providers, and support forecast processes.

Responsibilities include updating material master data, building dashboards and Power BI reports, performing data cleansing in Freight Spend, and helping with month-end accruals and reports in Excel using Python.

Qualifications

• Bachelor's degree or equivalent required.
• Internship/Co-op eligible for Jan 2027 intake.
• Strong analytical and communication skills.

Responsibilities

• Update material master data with shipping matrix to support PP/Forecast.
• Support month-end accruals.
• Enhance reports (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.
• Build dashboard for volume & budget forecast and actual comparison.
• Publish reports in Power BI for management review.
• Facilitate investigation on outliers.
• Update user guide.

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

Production Planning

Supply Chain Coordination

Supply Chain Metrics

Proposal Review

Life Cycle Logistics

Education

Bachelor's or equivalent

Tools

Python

Power BI

Excel

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}

Employee Status:

Intern/Co-op (Fixed Term)

Flexible Work Arrangements:

Hybrid

Job Posting End Date:

11/30/2026

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