Supply Chain Analyst III

Back to search results Apply now Job no:928968
Work type:Support Staff
Pay Grade: 12
Major Administrative Unit / College: University Procurement And Logistics
Department: Upl Administration 10074876
Sub Area: AP- Professionals
Salary: Salary Commensurate with Experience
Location:East Lansing
Categories:Administrative/Business/Professional, Administrative Professionals- AP, Full Time (90-100%), Union, Remote-Friendly

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 https://hr.msu.edu .  

This is a shadow posting, meaning based on the skills and experience of the final candidate, they will be offered the role of Supply Chain Analyst I, II, or III.  

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. 

Unit Specific Education/Experience/Skills

Supply Chain Analyst III – APA Level 12:

Knowledge equivalent to that which normally would be acquired by completing a four-year college degree program in Supply Chain Management, Operations Management, Business, Industrial Engineering or a related field; three to five years of related and progressively more responsible or expansive work experience in data analysis, modeling, forecasting, data mining, database design, project management, strategic planning, operations planning, statistical research, and/or business analysis; experience with database and spreadsheet software; or an equivalent combination of education and experience.

Supply Chain Analyst II – APA Level 11:

Knowledge equivalent to that which normally would be acquired by completing a four-year college degree program in Supply Chain Management, Operations Management, Business, or related field; one to three years of related and progressively more responsible or expansive work experience with database design, reporting, and analysis; process mapping; experience with supply chain operations; experience with database and spreadsheet software; or an equivalent combination of education and experience.

Supply Chain Analyst I – APA Level 10:

Knowledge equivalent to that which normally would be acquired by completing a four-year college degree program in Supply Chain Management, Operations Management, Business, or related field; six months to one year of related and progressively more responsible or expansive work experience with database and/or spreadsheet software for data collection and organization; implementing financial procedures; and experience with supply chain operations; or an equivalent combination of education and experience.

Desired Qualifications

This is an open-rank position, so all applicants are encouraged to apply. Direct experience in Python and Jupyter Notebooks. Specifically, experience with scikit-learn, regular expression and data transformation methods. 

• Three-to-five years SQL experience, designing complex queries. Experience running SQL queries through Python is also desired.  

• Experience with IBM Cognos and utilizing data cubes to develop self-service reporting. 

• One to two years’ experience with data visualization tools, such as Tableau and Power BI. 

Equal Employment Opportunity Statement

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, age, disability or protected veteran status.

Required Application Materials

Resume and Cover Letter

Work Hours

STANDARD 8-5

Website

upl.msu.edu

Remote Work Statement

MSU strives to provide a flexible work environment and this position has been designated as remote-friendly. Remote-friendly means some or all of the duties can be performed remotely as mutually agreed upon.

The Bidding Eligibility ends on 02/06/2024 at 11:55 PM

Advertised:Jan 31, 2024 Eastern Standard Time
Applications close:Feb 20, 2024 Eastern Standard Time