Production Planner II

ZipRecruiter; City Of London; Hybrid; GBP 40,000 - 55,000; Full time

Job summary

A leading staffing company is seeking a candidate for a hybrid role that combines elements of a Planner II and a Data Analyst. Responsibilities include collecting data, analyzing sales forecasts, and generating production schedules. A BA or BS degree and 2-5 years of related experience are required. Proficiency in SQL, Python, Power BI, and Advanced Excel is essential, along with strong analytical and communication skills.

Qualifications

• Working knowledge of MRP2 and computerized inventory control system.
• Extensive knowledge of material master maintenance, BOMs, routings, recipes, and work centers.
• Knowledge of cost accounting fundamentals and labor reporting.

Responsibilities

• Collects and organizes data for analysis.
• Analyzes sales forecasts for assigned direct sales materials.
• Generates production schedules and raw material requirements.

Skills

SQL

Python

Power BI

Advanced Excel

Analytical skills

Detail-oriented

Communication

Education

BA or BS

Tools

Tableau

MRP2 system

Microsoft Office

Job description

Overview

Duration: 03 months

Shift: 1st shift (Onsite but have some flexibility on remote schedule)

Intake Notes: Position will be a hybrid between a Planner II and a Data Analyst building reports & dashboards to support business needs. Technology Requirements include SQL, Python, Power BI, Advanced Excel, Oracle. Background/prior work experience: Computer science & supply chain. Priority soft skills: Independent worker, good communication & analytical skills, detail & deadline oriented.

Summary of Duties and Responsibilities

• Collects and organizes data for analysis.
• Analyzes sales forecasts for assigned direct sales materials.
• Generates production schedules and raw material requirements.
• Releases production work orders to Manufacturing.
• Analyzes sales performance and establish Production and QC priorities.
• Maintains inventory to achieve assigned levels.
• Participates in the transfer of new products from research and development to Mfg.
• Ensures that internal departments are kept abreast of work order status, inventory levels and projects.
• Ensures compliance with applicable regulations and policies.
• Maintains work center schedules to ensure proper jobs are scheduled and capacity limitations are understood and communicated when necessary.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the basic knowledge, skills, and or abilities required.

• Working knowledge of MRP2 and computerized inventory control system.
• Extensive knowledge of material master maintenance, BOMs, routings and/or recipes and work centers.
• Knowledge of cost accounting fundamentals and labor reporting.
• Proficiency in SQL, Excel, Python/R, and data visualization tools like Tableau or Power BI.
• Working knowledge of Microsoft Office or equivalent.
• CPIM certification desired.

Education

• Typically requires BA or BS.

Experience

• 2-5 years related experience.

About the Company

Select Source International (SSI) is a distinguished staffing company with nearly 25 years of experience, renowned for delivering top-tier workforce solutions encompassing staffing, recruiting, and managed services. Based in Minneapolis, Minnesota, USA, SSI has established itself as a global leader, serving a broad clientele across industries with unwavering dedication and excellence. SSI is ISO 9001, 14001, and SOC 2 Type 2 certified, underscoring our commitment to quality and security. SSI has garnered numerous sustainability and supplier awards, further validating our industry-leading capabilities.