Supply Chain Analyst / Supply Chain Analyst II

Current MSU Benefit Highlights:

Compensation for this support staff position includes generous paid time off; a 10% retirement match with a 5% employee contribution to the base retirement plan; health and dental insurance plan options with premiums paid fully by MSU; education assistance benefits for employee and dependents; employer-paid life insurance; and a large menu of voluntary benefits. Details can be found in the Support Staff Open Enrollment Guide and respective collective bargaining agreements on the MSU Human Resources website at https://hr.msu.edu.

Position Description:

This position will report to the Supply Chain Analytics Supervisor and will be responsible for identifying, designing and managing data collection, data analysis, and reporting in order to analyze complex supply chain functions; collaborating with supply chain and information technology professionals to create or interface with digital data systems or models; recommending enhancements to business processes to improve data collection and results.

This position will assist in analyzing spend for the University, averaging $1.6B per year. In that capacity, this role will create procurement reports within Python, IBM Cognos, SQL, SAP Ariba and Tableau to assist in driving data-informed decision making. Additionally, this position will assist in providing advanced analytics related to Logistics, Capital Asset Management, Accounts Payable and Warehouse Services.

In addition to the development of reports, this role will also assist in model development, the development of data pipelines and exploration of TabPy, providing a production environment for models.

As data-stewards for the University for supply chain related data, this position requires a high-level of integrity to assist with data governance for the University and UPL.

Position Duties:

• Utilize Python to develop predictive models and leverage TabPY as a production environment.

• Develop complex SQL queries to extract information for the MSU Data Warehouse (EDW).

• Leverage Python to extract data from the SCLogic database, and joining with EDW data, to develop reporting for Logistics, Capital Assets and Warehouse Services.

• Model review and validation.

• Design dashboards with visualization tools, such as Cognos, Tableau and Power BI

• Leverage API’s to aggregate data from third parties and provide advanced analytics.

• Perform exploratory data analysis to uncover opportunities for advanced analytics and modeling.

• Develop SSRS reports to provide self-service reporting for UPL staff.

• Participate in paired-programming sessions, allowing for skill-growth for the team.

• Collaborate with stakeholders to understand the root issue and to develop reports/ analytics that will inform decision making.

• Assist with KPI’s and metrics related to the Balanced Scorecard and UPL Leadership Dashboard

• Provide estimates for labor requirements and track hours worked on paid projects.

• Collaborate with UPL IT on the implementation of new systems.

• Develop IBM Cognos reports, providing self-service reports for the University, related to Ariba, KFS and the PCard program.

• Maintain an inclusive and collaborative environment, both internal and external to unit

• Act as a data steward for both UPL and the University, protecting PII, Unit data and potentially student data.

• Present an attitude geared toward continuous improvement and growth.

• Translate technical data terms, and modeling techniques, to a business audience.

• Exhibit excellent written and verbal communication skills.