IT Bus Intell Analyst I

Apply now »

Date: Apr 9, 2024

Location: PHOENIX, AZ, US, 85004-3903

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

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

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

Preferred Special Skills, Knowledge or Qualifications:

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)

Nuclear requirement: Any PVNGS employee may be called upon to serve as a member of the Emergency Response

Organization (ERO) and will be expected to fulfill their obligation as an ERO member.

Any PVNGS employee may be called upon to support a refueling or short-notice outage.

This includes line roles and responsibilities as necessary to execute outage activities.

These are a condition of employment at PVNGS.

Major Accountabilities

1) Maintains the quality of metadata repository by adding, modifying, and deleting data

2) Monitors and assists with processes and controls that maintain data integrity

3) Participates in planning process including inception, technical design, development, testing and delivery of BI solutions

4) Works with internal clients and IT partners to gather requirements

5) Develops and writes business requirements for the design of solutions

6) May determine and analyze commonly used queries and reports

7) Assists in the development of end user training materials

Key Level Differentiators:

Works to achieve operational targets within job area with direct impact on information design and business intelligence results

Under limited supervision, implements or supports

projects/assignments

May influence others through explanation of facts, policies, and practices regarding information design and business intelligence

Analyzes standard to moderately complex technical information design and business intelligence problems and solves them using judgment and prior experience

Ability to make decisions in areas outside of direct responsibility

Decision making has low impact on own and related IT job family and department

LAST REVISION DATE:

02/26/2018

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.