Supply Chain Data Analyst

Xcel Energy•Maryville, MO

18h•Onsite

About The Position

Prepare reporting/statistical analysis for Supply Chain processes and understand how analysis impacts overall Supply Chain processes. Support data management needs and activities. Identify and implement process/system improvements in Supply Chain. Standardize and optimize process design. Develop and conduct training for internal/external customers on Supply Chain processes. Position may concentrate in specific business areas, processes, and systems.

Requirements

Bachelor's degree in Supply Chain Management, Business, or related technical/analytical field. Relevant experience may be considered in lieu of a degree.
Three years of experience in a supply chain related field.
Excellent customer/communication skills.
Must be approachable, flexible, customer focused, self-motivated, results and team oriented.

Nice To Haves

Working knowledge of SQL (joins, filters, aggregations)
Exposure to Power BI or a comparable reporting/visualization tool.
Experience with Databricks or cloud-based data platforms.
Familiarity with Supply Chain or procurement data (purchasing, inventory, logistics).
Exposure to ERP systems such as SAP.
Experience supporting audit or compliance reporting activities.

Responsibilities

Perform in-depth research on complex audit questions, software system, or transactional problems.
Support data management needs and activities.
Provide customer service support by assisting as a technical and informational resource to resolve questions/issues.
Utilize report writing tools to create insightful reporting from various data sources to monitor Supply Chain key performance metrics and exceptions.
Perform analysis (e.g., statistical, trend/correlation/control charts) to identify and proactively communicate trends, root causes, performance, etc.
Analyze reports to ensure data accuracy.
Perform analysis and research of audit questions.
Lead the development of Process and System User documentation utilized by Supply Chain.
Develop and provide training on department systems and processes.
Review data quality issues and coordinate solutions with data owners.
Assist with ad-hoc data maintenance and analysis.
Utilize project management skills to lead large projects to improve processes.
Develop and implement project plans.
Communicate project milestones, obstacles, and progress.
Prepare management reports on program usage and compliance.
Analyze reports to ensure data accuracy.
Develop, maintain, and modify templates.
Facilitate interaction throughout Supply Chain to ensure proper procedures are followed.
Reconcile and validate reports, troubleshoot technical problems, conduct testing, support system updates, and coordinate with IT staff.
Schedule independent reviews of processes, policy, procedures and/or contract quality.
Perform SOX assessment tests on Supply Chain controls.
Serve as a single point of contact for internal audits.
Accountable to correct & follow through on audit findings.
Identify, recommend, and write process controls, test scripts, and communications.
Audit, correct errors, and advise personnel on procedures to process Supply Chain transactions accurately.
Ensure compliance with associated corporate and regulatory requirements, such as sales tax, SOX, IRS, FERC.