Senior Data Engineer

About SRP

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.

Summary

As a Data Engineer in the Supply & Trading Support Team at SRP, you will collaborate with business partners, understand their requirements, and develop data-driven solutions. You will create and support data models, data pipelines, transform SQL queries and algorithms, and solve interesting business problems. Your outputs will include dashboards, reports, interactive visualizations, datasets, and tools delivered to users across business units.

What You'll Do

• Understand business stakeholders' objectives and guide them in exploring relevant data and analytical methods
• Code interactive and effective visualizations of data
• Meet regularly with customers to review and demonstrate delivered functionality, and capture new or changed requirements
• Build infrastructure for efficient extraction, transformation, and loading (ETL) of data from a wide variety of data sources
• Create and maintain efficient data pipeline architecture
• Assemble large, complex data sets that meet functional/non-functional business requirements
• Identify, develop, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability
• Strive for clean and meaningful data within our consolidated data analytics platform
• Work with technical and non-technical stakeholders to assist with data-related technical issues and support their data infrastructure needs

Experience

Level 3 – Senior: Minimum 5 years of relevant experience required. In lieu of a degree, 9 years of relevant experience or an equivalent combination of education and experience totaling 9 years may be considered.

Qualifications

• Experience in developing and/or maintaining: Data Model, ETL/ELT, SQL Queries, and Data Science Models in a business analytics, data warehousing or business intelligence setting
• Fundamental knowledge of Snowflake, Hadoop, SQL Server, SAP, Oracle, DB2, Postgres, and other common data platforms
• Experience with CI/CD pipelines
• Curiosity and passion about utilizing analytics and data to solve problems
• Willing to ask questions and challenge data accuracy and assumptions
• Creative in solution design to achieve impactful, highly functional, and supportable solutions
• Able to translate or transform complicated or technical information into simple and clear communications for non-technical and business audiences
• Able to translate business needs and data into models that support KPIs, visualizations, or interactive dashboards that influence behavior
• Excellent communication and presentation skills for a variety of audiences from entry-level employees to executive staff
• Thrive in an active collaborative team environment; experience with Agile is a plus
• Sensitive to client needs and able to develop strong relationships
• Eager and able to continually learn new tools
• Familiarity with reporting and visualization tools
• Results driven and self-sufficient

Technical Skills Preferred

• Cloudera Hadoop, Azure Data Lake Storage, Snowflake, DBT, ANSI SQL, Azure Data Factory, Azure DevOps, Python
• Experience with other technologies within the Microsoft BI Stack, Microsoft Power Platform, SQL Server, SSRS, Databricks, SAS, Tableau
• Desired: Dataiku, Alteryx

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. All employees must live and work in Arizona.

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