Data Management Analyst / Data Management Analyst Senior - Revenue Protection
Apply now »
Date: Sep 26, 2023
Location: PHOENIX, AZ, US, 85021
Company: APS
Arizona Public Service generates clean, reliable and affordable energy for 2.7 million Arizonans. Our service territory stretches across the state, from the border town of Douglas to the vistas of the Grand Canyon, from the solar fields of Gila Bend to the ponderosa pines of Payson. 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.
Since our founding in 1886, APS has demonstrated a strong commitment to our customers in one of the country’s fastest growing states, earning a reputation for customer satisfaction, shareholder value, operational excellence and business integrity.
Our present and future success depends on the creative and dedicated people of our company who demonstrate the principles outlined in the APS Promise: Design for Tomorrow, Empower Each Other and Succeed Together.
Summary
The Data Management Analyst / Data Management Analyst Senior will assist in furthering the mission of Revenue Protection by supporting and providing innovative techniques to identify energy theft; Research potential energy theft, tampering, and safety concerns for Revenue Protection to investigate; Create queries (SQL, VBA) within various internal (CC&B, MWM, AMI, MDMS, ADMS) and external (Recorder/Assessors Office, Google Earth) systems for indicators of the above, gather statistics using business intelligence (Power BI, Cognos, RPAdmin, GIS) dashboards, conduct additional analysis to further validate potential, maintain those various tracking mechanisms; Handle administration by opening cases, creating work orders, updating notes, scheduling business presentations, working preparation of potential leads, and liaison with internal and external customers on behalf of Revenue Protection.
Responsible for compiling, analyzing and reporting on a variety of statistical data related to Business Unit and/or department operations and effectiveness by leveraging structured and unstructured data, performance measures, costs, and/or other specialized data to support critical management decision making. Coordinate the maintenance and enhancement of databases for tracking of Business Unit statistics and other specialized data. Assist in the development and implementation of special projects related to cost control, competitive research, and other strategies. Serves as a technical resource to department and other personnel.
Minimum Requirements
Data Management Analyst Minimum Requirements:
- Bachelors degree in Business, Science, Engineering, Information Technology, Computer Science, Math, or related field and two (2) years of experience in performance statistics, power cost factors, electric transmission/distribution/plant operations, analytics, and/or data science.
- In lieu of degree, high school diploma/GED and six (6) years of experience in performance statistics, power cost factors, cost/budgeting, electric transmission/distribution/plant operations, analytics, and/or data science.
-Requires strong working knowledge of one or more of the following: budget and forecast techniques, power system operations and maintenance factors, plant performance statistics and power production cost factors.
- To accommodate business unit, operations, system, and/or customer needs, the ability to work outside of normal business hours may be necessary.
Data Management Analyst Senior Minimum Requirements:
- Bachelors degree in Business, Science, Engineering, Information Technology, Computer Science, Math, or related field and five (5) years of experience in performance statistics, power cost factors, electric transmission/distribution/plant operations, analytics, and/or data science.
- In lieu of degree, high school diploma/GED and nine (9) years of experience in performance statistics, power cost factors, cost/budgeting, electric transmission/distribution/plant operations, analytics, and/or data science.
-Requires strong working knowledge of one or more of the following: budget and forecast techniques, power system operations and maintenance factors, plant performance statistics and power production cost factors.
- To accommodate business unit, operations, system, and/or customer needs, the ability to work outside of normal business hours may be necessary.
Preferred special skills, knowledge, or qualifications:
Possess comprehensive technical knowledge of electrical theory and electric utility/power-plant operation, APS financial and/or computer systems including Geographic Information Systems (GIS), Advance Distribution Management System (ADMS), and Maximo, and have the ability to apply this knowledge in proven analytical skills/methods. Knowledge of FERC and ACC regulations for some positions. Experience with data science and data analytics. Strong written and oral communication skills with the ability to present technical and complex information in a clear and understandable manner. Strong organizational and presentation skills. Demonstrate good leadership, time management, and teamwork skills. Proficiency with Microsoft Office Suite including Teams, Microsoft Power BI or other visualization tools, general IT/file management, XML, SQL, scripting, database management and queries, preferred.
Major Accountabilities
1) Perform various operations, performance, cost, and/or specialized data analysis to identify trends and operations issue. Reconcile data and develop explanation of variances as necessary. May develop forecasts and projections on future trends for different operations and performance categories related to energy operations, reliability, and availability.
2) Develop or assist in the development and maintenance of internal database systems to support the tracking and reporting on company operations and performance measures, costs, and/or other specialized data. Verify accuracy and completeness of data to ensure data integrity. Identify data issues and implement corrective actions.
3) Collaborate with multiple departments to coordinate the interface of data from different systems and the development of reporting and analysis for management and other internal and external stakeholders to support critical business decisions. Continually monitor available data and modify reporting and analysis to ensure most relevant information for decision making is provided to stakeholders.
4) Monitor and extract data on key operations and performance measures using various external and internal data sources.
5) Provide support and technical assistance within the department and to other areas of the company including providing performance and cost statistics to regulatory agencies and industry organizations.
6) Develop and produce a variety of monthly and annual reports.
7) Based on interdepartmental needs, utilize software tools to integrate datasets and devices/equipment into the energy management system.
8) Track and trend data, errors, health of various systems, to evaluate and proactively correct system deficiencies before they worsen and become system limitations.
9) Collaborate with multiple departments to provide a good level of internal customer support.
10) May track budget expenses, identify costs overruns and recommend corrections; may analyze and assist in the development of the budgeting activities for the organization as well as coordinating the efforts of all Unit budget activities.
KEY LEVEL DIFFERENTIATORS:
- Works to achieve operational targets within job area with direct impact on department and/or business unit results
- Under limited supervision, implements or supports projects/assignments
- A certain degree of latitude is required within established guidelines and procedures
- Assigned routine to moderate complexity issues
*may vary slightly depending on level hired into
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.