Principal Data Engineer

Requisition ID: 17772

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

The mission of the Analytics Center of Excellence (ACE) is to develop cutting edge analytic solutions that empower Salt River Project to deliver innovative and cost-effective solutions related to the delivery of power and water to its customers across the Phoenix Metro area.

As the Principal Data Engineer in ACE, your role is to help create and communicate the data platform strategic direction, architect tools and platforms for all three ACE departments (Data Engineering, Data Visualization, and Data Science), implement and reinforce best practices, support and advise fellow data professionals, and architect complex data solutions. The solutions you will help architect and develop include data models, data flows, and algorithms which solve interesting business problems. Day to day you can expect to be working with data analysts, data scientists, and business users across the enterprise, including occasional presentations to leadership.
 

What You’ll Do

Responsible for guiding the implementation of data platforms and development of data solutions

• Acting as a consultant to large, strategic projects and SRP’s Analytics Community
• Driving the implementation and rollout of platforms and technologies that best serve SRP’s analytical needs
• Defining frameworks, standards, and governance policies for the use of ACE’s analytics platforms of Snowflake, Dataiku, and Power BI
• Helping develop, update, and implement SRP’s analytics strategy
• Evaluating and implementing of platforms in support of our customers’ data needs and SRP’s cloud first strategy

 
Responsible for providing project and technical direction to ACE

• Evaluating business needs/problems and determining the proper application of technology to address them
• Interpreting and translating business stakeholders’ requirements to viable and sustainable technical solutions
• Sharing knowledge and skills with your teammates to increase the team’s overall capabilities and help ensure reliable support coverage

 
Responsible for leading efforts to grow SRP’s analytics culture

• Maintaining awareness of trends and technologies related to data and analytics
• Being an advocate for self-service analytics across the enterprise
• Consulting and advising on the effective use of data, analytics, and technology
• Providing leadership in SRP’s Analytics Community

What It Takes To Succeed

• Experience architecting data models, building ETL/ELT pipelines, writing complex queries, creating visual analytics, and implementing predictive/prescriptive algorithms in a business analytics setting
• Ability to write and troubleshoot extremely complex data queries written in T-SQL, PL/SQL, HiveQL, Impala, ABAP, etc.
• Experience with evaluating data sources to improve data quality, availability, usability, and integrity
• Curiosity and passion about utilizing data in innovative ways to solve problems
• Highly organized and efficient at managing multiple projects in a fast-paced continuous delivery environment
• A proven track record of relationship building with both technical and non-technical resources at various levels of the organization
• Experience collaborating with Storage, Network, Server Management, and Cyber Security with the ability to productively influence outcomes that align with SRP’s analytics goals
• Ability to translate complicated or technical information into clear communications for non-technical audiences
• Excellent communication skills and comfort presenting to people at all levels of the organization
• Results driven, self-reliant, and able to thrive in an fast-paced collaborative team environment
• Ability to create technical documentation

Desired Skills:

• Knowledge and experience in Azure Data Factory, DBT, Snowflake, Dataiku, PowerBI
• Certifications in Azure Data Factory, DBT, Snowflake, Dataiku, PowerBI
• Ability to write code in scripting languages such as Python, sql, PowerShell, and R
• Knowledge of Data Management and Governance for analytics products with tools such as Collibra
• Experience with other technologies Microsoft BI Stack, Microsoft Power Platform, SAP ECC, SAP BW & Business Objects, SQL Server, SSRS, Databricks, SAS, Hadoop, Tableau
• Strong Knowledge in various areas such as Cloud Operations, Storage, Networking, Security, Operating Systems, General Troubleshooting

Experience

Minimum of 10 years cumulative and progressive post-degree experience Master’s Degree Preferred
 

Education

Completion of a Bachelor’s Degree from an accredited institution plus an additional 18 graduate level college credits in an area of specialty.

Hybrid Workplace

SRP currently offers a hybrid workplace, which allows employees whose jobs can be performed remotely, and who have sufficient technical capability, to telework up to three days per week. Although teleworking is available, all employees must live and work in Arizona. We are taking steps to protect the health and well-being of all team members, and by following a number of health and safety protocols, to reduce the risk of the coronavirus (COVID-19).

Drug/Alcohol Policy Statement

To promote the safety and well-being of our employees, customers, and the communities we serve, SRP is committed to maintaining a drug/alcohol free work environment. Although marijuana may now be legal in Arizona, except as otherwise specified under Arizona law, SRP considers it to be an illegal drug for the purpose of our drug/alcohol policy because marijuana remains illegal at the federal level. Any candidate found to be impaired during the hiring process or who has the presence of an illegal drug or unauthorized substance in their system during the pre-employment drug/alcohol test may be disqualified from further consideration in the hiring process.

Equal Opportunity Employer Statement

Salt River Project (SRP) is committed to equal employment opportunity regardless of race, color, religion, sex (including pregnancy), gender identity, sexual orientation, national origin, age, disability, genetic information, military status, or any other protected status under applicable federal, state or local law.

Work Authorization

All candidates must be legally authorized to work in the United States.
Currently, SRP does not sponsor H1B visas, OPT, or other employment-related visa’s.