Supply Chain Support Services | Data and Reporting Analyst / Analyst, Senior

Apply now »

Date: May 2, 2024

Location: PHOENIX, AZ, US, 85004-3903

Company: APS

Our employees are important to the success and future of our organization and our customers’ experiences. At APS, our pay and benefits, along with retirement, recognition, time off, career development and well-being, make up our Total Rewards program. It is an important part of the employee experience at APS and supports your personal well-being and professional satisfaction. We are committed to providing programs that matter to our employees throughout all life and career phases.

Summary

Supply Chain Support Services - Data and Reporting Analyst / Analyst, Senior is responsible for Supply Chain Management (SCM) Data Analytics and Supply Chain business applications and systems support

What your day would be like:

You are responsible for:

• 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

  *Employees in Flex roles are required to reside in Arizona (or NM for Four Corners-based employees). Role types are subject to change based on business need.

Minimum Requirements

Supply Chain Support Services - Data and Reporting Analyst

• BS/BA equivalency OR an equivalent combination of four (4) years relevant business work experience and relevant college coursework in business, information technology or a related area.

• Additional two (2) 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.

  Supply Chain Support Services - Data and Reporting Analyst, Senior

• BS/BA equivalency OR an equivalent combination of four (4) years relevant work experience and relevant college coursework in business, information technology or a related area.

• Additional five (5) years of progressively responsible experience where strong understanding of database design, structure, functions and processes and experience with database tools is obtained.

  Preferred

• Strong analytical ability to review data and see relationships and patterns.

• Demonstrated communication, interpersonal and organizational skills.

• 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

*Employees in Flex roles are required to reside in Arizona (or NM for Four Corners-based employees). Role types are subject to change based on business need.

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) Researches, and analyzes 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 sound cost/benefit analysis.

7) Maintains and supports a variety of reports or queries utilizing appropriate reporting tools. Assists in the development of standard reports for customers. Assists in the development and maintenance of standardized Business reporting protocol and ensures data integrity and consistency in all reporting aspects.

8) Participates in project team assignments as a key team member. May coordinate activities within the functional business areas. Participates in business needs analysis, project scope definition, testing strategy, roll out and user acceptance.

9) Assist in developing, validating, and execution of all levels of testing.

10) Maintains documentation of system changes, business processes, guidelines and procedures, and tools and training aids needed to support business unit as defined.

11) Supports application/system training to functional Super users and/or other employees.

May monitor, and track business goals, activities, performance monitoring and issues for an assigned unit to keep management apprised of business unit activities.

12) Actively seeks knowledge and understanding of business/technical environment, priorities, procedures and processes. Keeps apprised of current and emerging trends for business unit business systems.

13) Conducts research, analyzes data, reports findings and assists in developing formal presentations.

14) May manage security for all business systems including documentation of processes associated with security. Responsible for ensuring appropriate data security controls, process and system documentation.

Export Compliance / EEO Statement

This position may require access to and/or use of information subject to control under the Department of Energy's Part 810 Regulations (10 CFR Part 810), the Export Administration Regulations (EAR) (15 CFR Parts 730 through 774), or the International Traffic in Arms Regulations (ITAR) (22 CFR Chapter I, Subchapter M Part 120) (collectively, 'U.S. Export Control Laws'). Therefore, some positions may require applicants to be a U.S. person, which is defined as a U.S. Citizen, a U.S. Lawful Permanent Resident (i.e. 'Green Card Holder'), a Political Asylee, or a Refugee under the U.S. Export Control Laws. All applicants will be required to confirm their U.S. person or non-US person status. All information collected in this regard will only be used to ensure compliance with U.S. Export Control Laws, and will be used in full compliance with all applicable laws prohibiting discrimination on the basis of national origin and other factors. For positions at Palo Verde Nuclear Generating Stations (PVNGS) all openings will require applicants to be a U.S. person.

Pinnacle West Capital Corporation and its subsidiaries and affiliates ('Pinnacle West') maintain a continuing policy of nondiscrimination in employment. It is our policy to provide equal opportunity in all phases of the employment process and in compliance with applicable federal, state, and local laws and regulations. This policy of nondiscrimination shall include, but not be limited to, recruiting, hiring, promoting, compensating, reassigning, demoting, transferring, laying off, recalling, terminating employment, and training for all positions without regard to race, color, religion, disability, age, national origin, gender, gender identity, sexual orientation, marital status, protected veteran status, or any other classification or characteristic protected by law.

For more information on applicable equal employment regulations, please refer to EEO is the Law poster. Federal law requires all employers to verify the identity and employment eligibility of every person hired to work in the United States, refer to E-Verify poster. View the employee rights and responsibilities under the Family and Medical Leave Act (FMLA).

Arizona Public Service is a smoke free workplace.

Flex Role:

This position is not required to be performed at a specific APS facility as long as adequate technology and a solid ergonomic set up are present. Pending agreement with leadership, employees hired into this role will be able to choose where they prefer to perform their work. Employees will have two options to choose from:

• APS office based: The employee prefers to work most of the time from an APS facility.

• Home based: The employee prefers to work most of the time from his/her home.

  *Employees in Flex roles are required to reside in Arizona (or NM for Four Corners-based employees). Role types are subject to change based on business need.