Job Information
Michigan State University(MSU) Supply Chain Analyst / Supply Chain Analyst II in Michigan
Working/Functional Title
Supply Chain Analyst
Position Summary
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 .
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.