Supply Chain | Data and Reporting Senior Analyst

Arizona Public Service generates clean, reliable and affordable energy for 2.7 million Arizonans. As the state’s largest and longest-serving energy provider, our more than 6,000 dedicated employees power our vision of creating a sustainable energy future for Arizona.

Summary

As a Supply Chain Support Services | Data and Reporting Senior Analyst (Business Systems Senior Analyst), is responsible for Supply Chain Management (SCM) Data Analytics and Supply Chain business applications and systems support.

 

Key Skills and Responsibilities

• Data Analysis & Management – Analyze, manage, provide insight, and improve large data sets to support Procurement Operations and Strategic Procurement.
• Database Development – Develop and optimize database designs, structures, functions, and processes using SQL and other relevant applications.
• Reporting & Visualization – Collect and interpret data to create dynamic reports on Supply Chain Management (SCM) metrics and initiatives using Power BI and other reporting tools.
• Training & Consultation – Provide training and consultation to system end users on system functionalities and data analysis capabilities.

We’re looking for professionals who:

• Analyzing, managing, providing insights on, and improving large data sets in support of Procurement Operations and Strategic Procurement. 
• Developing database designs, structures, functions and processes using SQL and other applications
• Collecting data to develop dynamic reports on SCM metrics and initiatives using PowerBI and other applications
• Providing training and consultation to system end users regarding system functionalities and data analysis capabilities

Minimum Requirements

• Four (4) year bachelor's degree in business, information technology or related area
• In lieu of bachelor's degree, an equivalent combination of four (4) years relevant business work experience and relevant college coursework in business, information technology or a related area.
• Five (5) years of progressively responsible experience where general knowledge and understanding of business unit business systems, basic knowledge of database design, structure, functions and processes and experience with database tools is obtained.

 

Preferred Knowledge or Skills:

• Supply Chain experience
• Strong analytical ability to review data and see relationships and patterns.
• Proficient in PC applications, including advanced skill level in Microsoft Excel, PowerBI, and Word.
• Proficiency in SQL.
• Demonstrated knowledge of Supply Chain business processes and operational knowledge including functions, procedures, processes, and computer systems. 
• Google Data Analytics Certification
• Demonstrated communication, interpersonal and organizational skills. 

Major Accountabilities

1) With general direction provides support for business unit business systems including, but not limited to, researching and resolving problems, system setup and maintenance, and data integrity audits.
2) Research and analyze routine to moderate business/operations problems related to systems utilized within the business unit.  Interfaces with Information Services or vendor to resolve issues as necessary.  Follows up with resolution of problems to ensure timely response and customer satisfaction.
3) With general direction, participates in the analysis and recommendation, installation and maintenance of new and enhancement of existing systems.  Ability to gather and write routine to moderate in scope business and functional requirements and identify future business system needs.  
4) Supports upgrades, patches and new implementations by performing testing, process and system documentation, and support user training and rollout efforts.
5) Works within areas of responsibility on process improvement initiatives.   Analyzes work process design, workflow and technology solutions to streamline, automate and improve work processes.
6) With general direction, participates in the development of effective business cases using