Data Engineer 1, 2, Senior

SRP • Tempe, AZ

4d • Hybrid

About The Position

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 Generation Applications team is dedicated to empowering the Power Generation organization with actionable, data-driven insights. The team analyzes data, creates efficient data models, builds complex data pipelines, and delivers high impact dashboards and data visualizations. As an Analytics Developer/Data Engineer on this team, you will work on dashboards, interactive visualizations, data pipelines, and reports. The successful candidate will utilize their experience with all Business Intelligence (BI) domains from translating requirements to sourcing, profiling, and modeling data, to ETL and dashboard development. This role will work closely with business partners to develop and implement analytical data models and dashboards. To excel in this role, the candidate will have strong communication skills to complement their technical ones. You will work alongside Application Developers, Business Representatives, Data Engineers, Business Analysts, Engineers, and Power Plant personnel.

Requirements

• Advanced proficiency with PowerBI
• Strong proficiency with T-SQL in a SQL Server environment
• Experience coding ETL processes in SSIS
• Expertise in modern database technologies, data integration, reporting
• Solid understanding of data warehousing concepts and data
• Strong critical thinking, problem solving, organization and analytical skills
• Demonstrated ability to communicate and present analysis or technical concepts to a non-technical audience in a clear and understandable manner

Nice To Haves

• Development/Query languages: SQL (T-SQL, Python)
• Platforms/Tools: PowerBI, Snowflake, Dataiku, SQL Server, Oracle, SSIS, SSRS
• Knowledge of SAP and Maximo is preferred
• Visual studio experience preferred

Responsibilities

• Define and develop dashboards including business metrics and performance indicators that drive action and insights (PowerBI experience required).
• Build and maintain ETL pipelines utilizing data migration services (SSIS), languages, and tools that connect various data sources (Snowflake, SQL, Oracle).
• Apply query, data exploration and transformation, basic statistical methods and visualization techniques to create business insights or improve data quality.
• Write, implement, and schedule ETL and other operational packages and scripts using SSIS and SQL.
• Collaborate with operational/IT business leads to recognize and help adopt best practices in data delivery, analysis, integrity, and validation.
• Ability to analyze and design physical databases and their definitions.
• Design, test, build, and manage complex, high-performing multi-user analytic solutions.
• Coordinate technical interactions between Power Generation personnel and other information technology teams.
• Visit Power Generation power plants to support customers.
• Participate in on-call rotation for 24/7 support needs.

Benefits

• Pension Plan (at no cost to the employee)
• 401(k) plan with employer matching
• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level