Customer Demand & Forecast Analyst

Constellium; Detroit (MI); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid work

401k matching

Swag allowance

Gym reimbursement

Maternity leave

Paternity leave

Student loan aid

Job summary

Constellium Van Buren is a state-of-the-art production facility in metro Detroit. The Customer Demand & Forecast Analyst develops demand forecasts to support operational planning, inventory management, and business decision-making.

This role analyzes inventory levels, sales data, production metrics, and product demand trends to determine the amount of finished product to be produced. It serves as the main contact for OEM customers and coordinates with the plant and sales teams.

Qualifications

• Bachelor's degree preferred or HS diploma with equivalent experience.
• 3+ years materials scheduling in tier 1 automotive facility.
• Experience with OEM releases and demand schedule preferred.
• 1+ year supplier planner/ordering experience preferred.
• Detail oriented and strong problem resolution skills.
• Proficient with Word, Excel, PowerPoint; experienced with MRP systems including PLEX.

Responsibilities

• Attend plant daily meetings and report customer/supplier concerns.
• Manage cycle count program and update customer portal as needed.
• Support onsite employees at Subcon offsite locations.
• Prepare demand plans and lead monthly S&OP process.
• Analyze weekly EDI forecast for planning and capacity.
• Be main contact for customers; notify of interruptions.
• Lead engineering changes and customer build-out at program end.
• Ensure ISO and regulatory compliance; backup when needed.

Skills

Attention to detail

Problem resolution

Communication skills

Education

Bachelor’s Degree in related field

High School Diploma or GED with experience

Tools

Word

Excel

PowerPoint

MRP systems

PLEX

Job description

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).
• Manage customer delivery ratings.
• 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.

Work Environment

• 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.

About Constellium Van Buren

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.