Materials & Production Planner

What You Will Do Manage the SIOP cycle (data collection, demand reviews, supply reviews, executive SIOP reviews and financial reconciliation) and all deliverables for a value stream or site. Deliver timely reporting and analysis of customer data to drive visibility, alignment and decisions across the business. Collaborate with Finance, Supply Chain, Engineering, and Operations to align business strategies with operational capabilities and recommend plans that meet inventory and financial targets. Leverage data analytics and planning tools to optimize inventory by developing strategies to reduce excess. Support executive level SIOP reporting, including Actuals, Latest Estimates, and Plans, supporting ELT and SLT decision‑making. Serve as the primary data and analytics subject‑matter specialist and technical lead for the SIOP process. Ensure data quality, accuracy, and consistency by following established data standards and validation checks. Takes ownership to align the consensus supply and demand plans established in the SIOP reviews while identifying and highlighting any gaps or risks. Creates strategy scenarios for the site / value stream. Conduct multi‑level cadence reviews within each site / value stream. Collect all key points of data using the standardized site / value stream SIOP review template (in collaboration with Demand Planners, Master Schedulers, and Materials Managers) to prepare and facilitate. Connect demand, supply, inventory, supply chain, capacity, and critical business metrics to look at 90‑day to 18‑month (minimum) profile. Identify risks and opportunities to assist each site / value stream in planning inventory, overdue goals, and scenario planning. Lead the collection, validation, reconciliation, and reporting of executive metrics on monthly, quarterly, and annual cadences, including Sales Overdue, and racks metrics to drive results and continuous improvement. Support the monthly, quarterly, and annual reporting cycles by collecting, validating, and reconciling operational metrics. Support the SBU Executive review, SIOP maturity across all sites, and alignment with Collins standard. Qualifications You Must Have Typically requires a university degree and minimum 5 years prior relevant experience or an advanced degree in a related field and minimum 3 years of experience. Demonstrated proficiency in analytics‑based reporting, including the use of Microsoft Excel or database management of large datasets. Experience in inventory management. Qualifications We Prefer Operations experience (indirect). Operations capacity planning. Financial planning. Production planning/scheduling. What We Offer Medical, dental, and vision insurance. Three weeks of vacation for newly hired employees. Generous 401(k) plan that includes employer matching funds and separate employer retirement contribution, including a Lifetime Income Strategy option. Tuition reimbursement program. Student loan repayment program. Life insurance and disability coverage. Optional coverages you can buy: pet insurance, home and auto insurance, additional life and accident insurance, critical illness insurance, group legal, ID theft protection. Birth, adoption, parental leave benefits. Ovia Health, fertility, and family planning. Adoption assistance. Autism benefit. Employee assistance plan, including up to 10 free counseling sessions. Healthy You incentives, wellness rewards program. Doctor on Demand, virtual doctor visits. Bright Horizons, child and elder care services. Teladoc Medical Experts, second opinion program. And more. May be eligible for relocation. Salary range for this role is 86,800 USD - 165,200 USD. RTX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. RTX provides affirmative action in employment for qualified individuals with a disability and protected veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans’ Readjustment Assistance Act. #J-18808-Ljbffr