Supply Chain Data Analyst Co-op (Hybrid)

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

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.