Senior Data Analyst

Requisition ID: 18210

 

Join us in building a better future for Arizona!

SRP is one of the largest public power and water utilities in the U.S. providing electricity to approximately one million customers in the greater metropolitan Phoenix area. Since its founding in 1903, SRP has fostered a culture of stewardship and customer service consistently ranking as an industry leader in customer service according to J.D. Power and named one of Arizona's best employers by Forbes. SRP continues to adapt to its changing business environment by seeking innovative ways to reimagine utility service and the provision of critical resources essential to the life and economy of Arizona.

 

Why Work at SRP

At SRP, we foster an inclusive work environment and believe everyone should have a fair chance to work, regardless of who they are. That’s why we value teams with diverse perspectives, experiences, and backgrounds to help SRP deliver on its mission of providing reliable, affordable and sustainable water and power.

 

SRP's success is rooted in our employees' happiness, health, and safety. That's why we offer a comprehensive benefits package to meet the needs of our employees and enhance their well-being. In addition to competitive pay and performance incentives, eligible employees can take advantage of the following benefits:

 

• Pension Plan (at no cost to the employee)
• 401(k) plan with employer matching
• Available your first day: Medical, vision, dental, and life insurance
• Over 200+ hours of PTO (includes vacation days, holidays, floating holidays, and sick leave)
• Parental leave (up to 4 weeks) and adoption assistance
• Wellness programs (including access to a recreation and fitness facility)
• Short and long-term disability plans
• Tuition assistance for both undergraduate and graduate programs
• 10 Employee Resource Groups for career development, community service, and networking

 

Summary

Performs IT studies in Data Analysis that requires significant knowledge of related fields. Develops, maintains, and manages advanced reporting, analytics, and dashboards. Creates processes/tools to access data from various sources.

What You'll Do

• Create and maintain automated dashboards, metric reports, and data visualizations to inform leadership and aid in decision making  
• Develop tools to manage processes such as goal and project tracking 
• Explore, gather, and organize data from various applications/systems to use in analysis and reporting 
• Troubleshoot and resolve data issues 
• Support the organization with ad hoc reporting 

What It Takes To Succeed

• In-depth knowledge of SQL (structured query language) for querying databases
• Familiar with SQL environments (Microsoft SQL Server, Oracle, IBM DB2, MySQL, etc.
• Knowledge of the following SQL Tools:
  • SSMS (SQL Server Management Studio)
  • Oracle SQL Developer
  • IBM Data Studio
• Knowledge of the following Data visualization tools:
  • Tableau
  • Power BI
  • SSRS (SQL Server Reporting Services)
• ETL (Extract – Transform – Load) tools such as SSIS (SQL Server Integration Services), GoldenGate, etc.
• Cloud storage tools (Snowflake, DataIKU)
• MS Office tools
  • Excel
  • Access
  • Sharepoint
• Development tools such as Visual Studio are helpful
• Knowledge of Work Management tools such as Maximo, SAP are also helpful.

Experience

• For an associate level, a minimum of no previous years of experience to two years related experience plus a bachelor's degree is required. (If no degree, four-six years of relevant experience o