IT Business Intelligence Analyst II

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 IT Business Intelligence Analyst I/II partners with business and APS managers to understand and prioritize data and information requirements. Focuses on design and support of business intelligence ("BI") applications and architecture. Solves technical problems and optimizes performance of business intelligence tools by defining data to filter and index.

Minimum Requirements

Level I

• Bachelors' degree in Information Technology or related field and 2 years of prior relevant experience or equivalent combination of education and directly related experience. 
• Requires working technical knowledge gained through experience within a job area or system

Level II

• Bachelors' degree in Information Technology or related field and 5 years of prior relevant experience or equivalent combination of education and directly related experience.
• Requires strong technical knowledge within a job area or system and basic knowledge across related technical areas

Preferred Special Skills, Knowledge or Qualifications:
 

• Experience with Azure, Azure SQL Server, Management Studio, PowerBI, or AWS is required. 
• Microsoft O365 is desired. 
• Knowledge of  business intelligence database structures, algorithms, best practices and auditing mechanisms; data warehousing and performance concepts;  common and complex business intelligence tools; change control and business intelligence agility methodologies; performance tuning practices; the development of complex SQL inquiries, business intelligence products such as (Tableau, Business Objects, Oracle); data warehouse objects, dimensions, hierarchies, fact tables, and aggregates; HTML and CSS; practices to create creative designs for information in print, online, and interactive formats; the integration, production, and usability of graphic solutions related to information design; visual design practices; type, illustration, and layout techniques for information design; specialized visualization tools; database and statistical programming languages (SQL or R). 

Major Accountabilities

1) Manages small to moderately complex projects/work streams relating to information design and business intelligence

2) Develops work plans to meet timeframes including inception, technical design, development, testing and delivery of BI solutions

3) Works with internal clients, IT partners, and team members to develop and analyze business intelligence needs

4) Interprets business requirements and determines "best-fit" BI solutions

5) Documents business requirements for the design of solutions

6) Researches business problems and assists in the creation of models

7) May perform analysis for a wide range of requests using data in different formats and from various platforms

8) Reviews test plans and monitors testing process to ensure that business results are tested

9) Develops and improves methods of measuring and analyzing business intelligence datasets and processes

10) Designs and delivers end-user training and training materials

11) Provides advice as a go-to technical resource for APS information design and business intelligence colleagues with less experience or to a small team
 

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