Analytics Developer 1, 2, Senior

Analytics Developer 1, 2, Senior

Location:

Tempe, AZ, US

Date: Nov 13, 2024

**Requisition ID** : 18044

**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 Customer Analytics team is dedicated to empowering the Customer Services organization with actionable insights. The team analyzes data, identifies trends, and provides strategic recommendations to enhance customer satisfaction, optimize processes, and drive informed decision-making. The team's mission is to enable exceptional customer experiences through data-driven excellence.

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 should complement their analytical skills with a technical understanding of data pipelines and be versed in multiple data systems.

This role will be split 75% analytics development, 25% data engineering. You will work alongside Data Scientists, Business Representatives, Data Engineers, Programmers, and Analytics Developers.

**What You'll Do**

- Define and develop dashboards including business metrics and performance indicators that drive action and insights (PowerBI experience preferred)

- Build and maintain ETL pipelines utilizing data migration services (SSIS, Azure Data Factory), languages, and tools that connect various data sources (Snowflake, SQL, DB2)

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

- Experience in performance tuning and query optimization

- Ability to analyze and design physical databases and their definitions

**What It Takes To Succeed**

The successful candidate will possess these capabilities:

- Advanced proficiency with PowerBI

- Strong proficiency with T-SQL in a SQL Server environment

- Experience coding ETL processes in SSIS and Azure Data Factory

- Expertise in modern database technologies, data integration, reporting

- Solid understanding of data warehousing concepts and data modeling (Prefer 3+ years)

- 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

Desired Technical Skills:

- Development/Query languages: SQL (T-SQL, PL/SQL, SnowSQL, etc.), Python

- Platforms/Tools: PowerBI, Snowflake, Microsoft Azure, Dataiku, Azure Data Factory, Legacy Databases (SQL Server, DB2, Oracle), SSIS, SSRS

- Knowledge of SAP and its data-related tools (Datasphere, Analytics Cloud, etc) is a plus

Prefer degree in Computer Sciences, Information Technology, Computer Engineering, Analytics, or related discipline.

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

**Education**

Completion of a Bachelor's 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 visa's.

**Nearest Major Market:** Phoenix