Senior Supply Planning Analyst
Job-ID: 13742; Location(s): Broomfield, CO
JOB DESCRIPTION SUMMARY
Provide supply chain & analytical expertise / leadership (no direct reports) to the Supply Chain Excellence team. Help develop the future IBP advance planning solutions as well as analytics using Power Query, Power BI, Snowflake and RPA’s. Help put together metrics decks and help lead various meetings based on manual data pulls and in Excel as needed. Also help establishing best in class Supply Chain processes. Provide technical training and support to increase team’s supply chain knowledge and analytical capability.
JOB DESCRIPTION DETAILS
Sales and Operations Planning
- Recognized as an expert in supply chain processes and analytics
- Work cross functionally to transform existing business processes and create new best in class global planning & analytics processes.
- Coach and train other supply chain staff in supply chain analytics topics
- Help roll out IBP advanced planning and S/4 ERP technology solutions.
- Help architect the data structure in Snowflake to enable deployment of reporting in PowerBI, SAC, Fiori, Excel, etc.
Analytics/Metrics
- Working with IT and other stakeholders, develop and deploy analytical tools and custom models to observe, progress, uncover insights in the data and automate analysis
- Provide In- depth analyses and insights for strategic and business initiatives
- Utilize and update business intelligence tools, systems, spreadsheets or outputs
- Drive data initiatives cross functionally and support the rollout of new tools
- Support preprocessing of structured and unstructured data, analyze large amounts of information to discover trends and patterns
Master Data/ERP (IT)
- Configure and Maintain background process and master data tables in various programs
- Support definition and implementation of new business processes that will be used within the supply chain
- Train new hires and provide support to material master settings and the corresponding effects
Projects / Continuous Improvement/Commutation
- Lead technical and analytical projects and CI initiatives
- Continuously works to streamline processes, develop data tools, enhance reporting, and suggest improvements to improve efficiencies
- Provides presentations and reports supporting business initiatives
- Support definition and implementation of new business processes
Other
- Operate independently with limited oversight from manager.
- Helps define what needs to be done and then deliver results
REQUIRED QUALIFICATIONS
Knowledge, Skills and Abilities
- Expert knowledge of MS Excel (Power Query, BW/AFO, macros)
- Advanced knowledge of Power BI & Snowflake (data consolidation, visualization)
- Deep understanding of MRP/ERP systems (SAP preferred)
- Working experience with IBP advanced planning tools (SAP IBP, etc.)
- Experience working for a manufacturing company/within a manufacturing environment
Education, Certification/License & Work Experience
- 10+ years of relevant working experience
- Bachelor’s or Master’s degree (preferred)
- Power Query, Power BI, Snowflake, SQL (preferred)
- CPIM or CSCP certification (preferred)
- Green Belt or Black Belt in Six Sigma (preferred)
Equivalent combinations of education and experience may be considered.
Total Rewards Package:
Compensation:
- Base: $90,000 - $115,000 annually (CO), based on specific compensable factors including, but not limited to education, work experience, and geographic market.
- This role will be eligible for participation in a discretionary annual bonus program, pursuant to which an employee may be awarded a percentage of their salary based on the company’s performance and their own individual performance.
Benefits:
- Medical, Dental, Vision
- Wellness Program
- Health Savings Account (HSA) with a company contribution
- Voluntary Benefits (Life, AD&D, Disability)
- 401(k) retirement plan with a 7.5% company contribution
- Time Off Programs - 22 days Paid Time Off (PTO), 9 Company Holidays, 2 Volunteer Days
Posting Date: 12/22/23
The application deadline for this job is between 3 days and 3 months from date of posting.
Your contact person:
Johnathan Nuthall
#LI-LS1
Nearest Major Market: Denver