Customer Demand & Forecast Analyst

Constellium Deutschland GmbH; Van Buren Charter Township (MI); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid work arrangement

401k with company match

Maternity/Paternity leave

Student loan repayment program

Annual swag allowance

Gym/fitness reimbursements

Job summary

Constellium Van Buren is seeking a Customer Demand & Forecast Analyst to develop demand forecasts and analyze inventory, sales data, and production metrics to guide production planning. The role primarily supports the Van Buren Twp. plant in a fast-paced manufacturing environment.

Responsibilities include daily meetings, cycle counting, customer portal updates, and coordinating with sales for commercial issues. This position requires meticulous data analysis and collaboration with OEM customers.

Qualifications

• Bachelor’s degree or GED with equivalent work experience is required.
• Minimum of three (3) years of materials scheduling experience in a tier 1 automotive facility is required.
• Experience with OEM customer releases and demand schedules is preferred.
• Minimum of 1 year’s experience with supplier planning/ordering is preferred.
• Detail-oriented in nature is preferred.
• Excellent problem resolution skills are required.
• Proficient with Word, Excel, PowerPoint is required.
• Proficient with MRP systems; PLEX experience is required.

Responsibilities

• Attend the plant daily Flash Meeting and report customer and supplier concerns.
• Manage the cycle count program.
• Support Constellium onsite employees at Subcon locations.
• Update the customer portal (e.g., Ford, FCA, GM, BMW).
• Contact sales and customers if potential commercial issues are identified.
• Enter customer shippers to support daily shipments.
• Prepare demand plans and lead the monthly S&OP process.
• Analyze EDI forecast weekly for planning and capacity constraints.
• Be main point of contact for customers and notify them of interruptions.
• Perform Item Parameter Reviews and reconcile customer cums weekly.
• Attend Program Management and ECR meetings and communicate changes to the plant team.
• Lead engineering changes and customer build out at year end.
• Prepare data for obsolescence claims and provide to sales.
• Follow ISO 14001, 9001, 45001, IATF 16949, and other regulatory requirements.
• Backup when the Materials Manager or Master Scheduler is out of the office.
• All other duties as assigned.

Skills

Problem solving

Attention to detail

Education

Bachelor’s degree or equivalent experience

Tools

Word

Excel

PowerPoint

MRP systems

PLEX

Job description

Select how often (in days) to receive an alert:

Job Summary

The Customer Demand & Forecast Analyst develops demand forecasts to support operational planning, inventory management, and business decision-making and analyzes inventory levels, sales data, production metrics, and product demand trends to determine the amount of finished product to be produced.This position primarily supports the Van Buren Twp. plant.

Responsibilities

• Attend the plant daily Flash Meeting and report out customer and supplier concerns as well as reviewing the Flow board daily.
• Responsible for managing the cycle count program.
• Support Constellium onsite employees at any Subcon offsite location.
• Update the customer portal as required (example Ford, FCA, GM, BMW).
• Contact sales and customer if potential commercial issues are identified.
• Enter customer shippers to support daily customer shipments.
• Prepare demand plans and lead the monthly S&OP process.
• Analyze customer EDI forecast weekly for accurate planning and capacity constraints and communicate any concerns.
• Main point of contact for all customers; notify customer of any potential interruptions.
• Perform Item Parameter Reviews annually on all customer end items and WIP assemblies and reconcile customer cums weekly.
• Attend Program Management and ECR meetings weekly and communicate changes to the plant team.
• Manage and lead engineering changes and customer build out at the end of a program model year.
• Prepare data for obsolescence claims to the customer and provide to sales.
• Follow ISO 14001, 9001, 45001, IATF 16949, and other regulatory requirements.
• Backup when the Materials Manager or Master Scheduler is out of the office.
• All other duties assigned and necessary to perform the job.

Qualifications

• Bachelor’s Degree in related field, preferred or High School Diploma or GED with equivalent work experience, required.
• Minimum of three (3) years of materials scheduling experience in a tier 1 automotive facility, required.
• Experience working with OEM customer releases and demand schedule, preferred.
• Minimum of 1 years’ experience with supplier planner/ordering, preferred.
• Detailed oriented in nature, preferred.
• Excellent problem resolution skills, required.
• Proficient with Word, Excel, PowerPoint, required.
• Proficient with MRP systems, PLEX experience is required.

Physical Requirements

• Ability to sit, stand, walk, and use a computer for extended periods.
• Frequent interaction with manufacturing floor personnel.
• Occasional lifting of up to 25 pounds.
• Combination of office and manufacturing floor environment.
• Exposure to production equipment, moving machinery, and varying noise levels.
• Occasional extended hours may be required to support customer requirements and production demands.

Constellium Van Buren is a state-of-the-art production facility which produces customized aluminum automotive structures and crash management systems for our OEM customers, and features advanced development and prototyping capabilities. Located at the heart of the automotive industry in metro Detroit, the plant works closely with our OEM customers and suppliers to ensure our products meet precise performance specifications.

Benefits

• Benefits are the cherry on top of any job and what Constellium has to offer is definitely a treat!
• Day 1, employees automatically receive an 3% contribution to their 401k.
• On top of that, if the employee choses to contribute to their 401k, Constellium matches 100% of the first 6%.
• That money adds up fast!
• Constellium also offers a hybrid work arrangement, where employees at times are able to work remotely from home!
• If you miss office parties and socializing with coworkers, Constellium has their own Constellium Cares Committee at each site where they plan activities for employee engagement and community outreach.
• These are great opportunities to connect with others and do good for our communities!
• Like free stuff? Employees are given an annual allowance to buy company swag and have the option to submit fitness reimbursements for gym memberships, new workout equipment and more!
• Are kids in your future? Constellium offers 16 weeks 100% paid maternity leave and 4 weeks 100% paid paternity leave.
• Constellium will also help cover child care expenses for your children.
• Also, beginning in 2023 Constellium will be offering a Student Loan Repayment Program, where the Company will pay up to $3,000 per year to help employees tackle student debt.
• All in all, Constellium is a great place to work, period.

Constellium is an Equal Opportunity Employer

Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law.