IT Business Intelligence Analyst II / III | Power BI

Arizona Public Service; Phoenix (AZ); On-site; USD 70,000 - 110,000; Full time

Job summary

Join a forward-thinking company as an IT Business Intelligence Analyst III, where your passion for transforming data into actionable insights will play a key role in enhancing decision-making. This innovative firm seeks a highly skilled professional to drive business intelligence solutions using Power BI, collaborating with teams to develop and optimize BI applications. You'll tackle complex technical challenges and champion the growth of the Power BI community. If you're looking to make a significant impact in a data-driven environment, this opportunity is perfect for you.

Qualifications

• 6+ years of experience in business intelligence and data analysis.
• Strong technical knowledge in Power BI and SQL.

Responsibilities

• Develop and maintain Power BI dashboards for real-time insights.
• Collaborate with business leaders to prioritize data needs.

Skills

Power BI

DAX

SQL

Data Visualization

Data Modeling

Performance Tuning

Mentoring

Education

Bachelor's degree in Information Technology

Tools

Tableau

Business Objects

Oracle

Job description

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

IT Business Intelligence Analyst III | Power BI

Are you passionate about transforming data into actionable insights? We are looking for a highly skilled IT Business Intelligence Analyst III with expertise in Power BI to drive business intelligence solutions that enhance decision-making across APS.

Why Join Us?

This role is a key player in the growth of APS’s Power BI community, enabling teams to leverage data for strategic insights and operational efficiency. You’ll work with business leaders and stakeholders to design, develop, and optimize BI applications, ensuring that critical data is accessible, accurate, and impactful.

What You’ll Do:

1. Collaborate with business leaders to gather and prioritize data and reporting needs.
2. Develop and maintain Power BI dashboards that provide real-time insights and drive business performance.
3. Optimize BI tools by refining data models, indexing, and filtering for efficiency and scalability.
4. Solve complex technical challenges related to data visualization, integration, and performance tuning.
5. Champion the growth of the Power BI community, enabling self-service analytics and fostering best practices.
6. Ensure data integrity and accuracy, supporting decision-making at all levels of the organization.

What We’re Looking For:

1. Strong Power BI expertise, including DAX, Power Query, and data modeling.
2. Experience with SQL, data visualization best practices, and BI architecture.
3. Ability to bridge the gap between business needs and technical solutions.
4. Proven experience in optimizing performance and troubleshooting BI tools.
5. Passion for mentoring and empowering others in data-driven decision-making.

Join us and play a critical role in shaping the future of business intelligence at APS!

Apply today to be part of an innovative and data-driven team!

Minimum Requirements

IT Business Intelligence Analyst III | Power BI

• Bachelors' degree in Information Technology or related field
• PLUS six (6) years of prior relevant experience or equivalent combination of education and directly related experience.
• Requires in-depth level of technical knowledge within a job area and working knowledge of other technical areas to make large decisions within area of direct responsibility

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).

Major Accountabilities

1. Manages large complex projects and systems relating to information design and business intelligence
2. Evaluates internal customers' needs and abilities in order to provide appropriate solutions
3. Conducts analyses of functional business processes and requirements for a wide range of requests using data in different formats and from various platforms
4. Interprets business requirements and determines BI solutions to meet needs; Provides input to business requirements for the design of solutions
5. Provides input to new technology opportunities with impact on the enterprise-wide BI systems
6. Designs enterprise-wide custom reports/views
7. Researches business problems and creates models that support analysis
8. Analyzes testing results to ensure the solution meets the needs of the business
9. Researches tools, frameworks and mechanisms for BI needs
10. Provides input to standards, policies and procedures for the form, structure, and attributes of the BI tools and systems.
11. Serves as a highly experienced and knowledgeable resource within the organization on information design and business intelligence
12. Leads information design training and provides assistance/expertise to employees
13. Responsible for providing guidance, coaching and training to other information design and business intelligence within job area

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.