Intern, D&L Data Analyst

Merck Gruppe - MSD Sharp & Dohme; Singapore; Hybrid; SGD 17,000 - 25,000; Part time

Benefits offered by this job

Hybrid work arrangement

Job summary

Merck Gruppe - MSD Sharp & Dohme in Singapore is seeking a motivated Intern/Co-op to support the distribution and logistics team with data collection, analysis, and cross‑functional coordination.

You will update material master data, support month-end accruals, and enhance reports using Python and Excel, then publish dashboards in Power BI for management review.

The role begins for the January 2027 intake, with a hybrid work arrangement and exposure to end-to-end supply chain processes.

Qualifications

• Bachelor's degree or equivalent.

Responsibilities

• The role involves data collection and analysis to support distribution and logistics activities.
• Update material master data with shipping matrix to facilitate PP/Forecast.
• Support month-end accruals.
• Enhance existing reports using Python scripts for monthly and forecast reporting in Excel; perform data cleansing on Freight Spend Report.
• Build dashboards for volume, budget forecast, and actual comparison.
• 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

Data Analysis

Data Collection Methods

Distribution Management

Driving Continuous Improvement

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

Education

Bachelor's degree or equivalent

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

Requisition ID

R403554