Manufacturing Data Analyst - Internship

Description

The company is a regulated pharmaceutical manufacturer. This internship sits in the Dispensing Operations team and works with the Senior Scheduler.

The work centers on dispensing activities that support sterile manufacturing. You will look at workloads, material flows and how resources are allocated, and help improve the planning and reporting tools the team uses.

The role is an internship and is based in the office, Monday to Friday.

Responsibilities

• Gather and organize operational data on dispensing work for the different sterile manufacturing processes.
• Track preparation lead times, activity durations and how workload is spread across manufacturing requests.
• Help define performance indicators that show departmental efficiency, trends and likely bottlenecks.
• Review historical data to find ways to balance workload and streamline processes.
• Assist the Senior Scheduler with workforce allocation, Full-Time Equivalent (FTE) use and operational capacity.
• Study how preparation volumes, processing times and required resources relate to each other.
• Help assess space use, operational constraints and capacity limits in dispensing areas.
• Build analytical tools that make workload easier to see and support resource planning.
• Look for ways to improve resource allocation and operational scheduling.
• Analyze material movement between Dispensing and manufacturing areas, including returns and the handling they involve.
• Track return volumes, frequency, processing times and recurring problems.
• Spot inefficiencies, unnecessary handling and chances to simplify steps.
• Create reports and KPIs that make material movements easier to see and trace.
• Work with relevant stakeholders to improve material flow coordination.
• Review the Excel-based tracking, scheduling and reporting tools to find manual work, duplicate entries and inefficiencies.
• Help simplify, standardize and digitize data collection and reporting.
• Contribute to automated reports and dashboards built with Excel, Power Query, Power BI or other tools the company uses.
• Help merge information currently spread across several spreadsheets.
• Improve data consistency, reporting reliability and access to operational information.
• Support continuous improvement through structured data analysis and process mapping.
• Build dashboards and recurring reports that track key operational indicators.
• Spot trends, repeat issues and improvement opportunities in operational data.
• Work with the Senior Scheduler and department stakeholders to support data-driven decisions.
• Help standardize operational reporting and performance monitoring.

Requirements

• Currently enrolled in or recently completed a degree in Industrial Engineering, Management Engineering, Supply Chain Management, Economics, Statistics or a related field.
• Good working knowledge of Microsoft Excel, including advanced formulas, Pivot Tables and data analysis.
• Strong analytical skills and the ability to interpret operational data.
• Strong analytical mindset and a problem-solving attitude.
• Attention to detail and data accuracy.
• Good organizational and time management skills.
• Proactive, with a continuous improvement mindset.
• Able to work well with cross-functional teams.
• Curious and willing to learn in a dynamic manufacturing environment.
• Good command of English.
• Nice to have: familiarity with Power Query, Power BI or other data visualization tools.
• Nice to have: basic understanding of manufacturing processes, resource planning or operational performance analysis.
• Nice to have: knowledge of ERP systems such as SAP.

Conditions

Internship, office-based, Monday to Friday, standard hours.

Benefits

• Hands-on experience in pharmaceutical manufacturing support operations.
• Build analytical skills in manufacturing performance, workload analysis and resource utilization.
• Learn the basics of operational scheduling and capacity planning.
• Take part in digitalization and reporting automation projects.
• See how data analysis can improve efficiency in a regulated pharmaceutical setting.
• Work alongside experienced manufacturing and scheduling professionals on real operational problems.