Data Engineer – Supply & Trading

Data Engineer – Supply & Trading

Location:

Tempe, AZ, US

Date: Sep 26, 2024

Requisition ID : 17844

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

SRPs success is rooted in our employees happiness, health, and safety. Thats 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

As a Data Engineer in the Supply & Trading Support Team at Salt River Project (SRP), you will be expected to collaborate with our business partners, understand their business requirements, and develop data driven solutions to meet their needs. 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 that will be delivered to users across the business units.

What Youll Do

Understand your business stakeholders objectives and guiding them in a process to explore relevant data and analytical methods.

Code interactive and effective visualizations of data.

Meet regularly with customers to review and demonstrate delivered functionality, and to capture new or changed requirements.

Build the 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, etc.

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.

What It Takes To Succeed

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

Familiarity with reporting and visualization tools.

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

Experience

Promotion to Level 2 requires a minimum of two years experience at Level 1 and demonstrated capability to perform advanced and more difficult work as determined by the supervisor.

Promotion to Senior Level requires a minimum of 3 years experience at Level 2, is fully competent in all aspects of functional area of assignment and as such would be recognized as a specialist in area of assignment and may have periodic or occasional lead responsibilities.

Note: our preferred candidate is a mid-level candidate with 2-4 years of experience

Education

Completion of a Bachelors Degree from an accredited institution that prepares the employee for the assignment.

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

Nearest Major Market: Phoenix