Senior Data Engineer | Phoenix, AZ

Detailed Information

  • Location: Phoenix, AZ

  • Company: SRP

D. Power. 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. Job Brief As a Senior Data Engineer in the Analytics Center of Excellence (ACE) at Salt River Project, your role is to be an expert at understanding SRP's data and then use it to create meaningful models and solutions.

You will create & support data models, data pipelines, transformation SQL queries, and algorithms, solve interesting business problems for data analysts, data scientists, and business users across SRP. If you are a sharp coder, can identify problems in complex data,

enjoy making information more accessible and easier to use for analytics, willing to learn and quickly adapt to new technologies, love to produce innovative solutions to solve tricky data problems, this is a great opportunity for you.

Job Responsibilities • Creating and maintaining efficient data pipeline architecture • Assembling large, complex data sets that meet functional/non-functional business requirements • Identifying, developing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. • Building the infrastructure for efficient extraction, transformation, and loading (ETL)

of data from a wide variety of data sources using Azure Data Factory, DBT, Snowflake and SAP • Working with technical and non-technical stakeholders to assist with data-related technical issues and support their data infrastructure needs • Strive for clean and meaningful data within our consolidated data analytics platform Education Completion of a Bachelor's Degree from an accredited institution that prepares the employee for the assignment.

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.

Additional Information Knowledge & Experience • 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 • Required: Snowflake, DBT, ANSI SQL, Azure Data Factory, Azure Dev Ops • Preferred: Cloudera Hadoop, Azure Data Lake Storage • Desired: Power BI, Python Requisition Details Requisition ID: 16403 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). Equal Opportunity Employer Statement Salt River Project (SRP) recognizes diversity and inclusion as key drivers of innovation and growth, and seeks to attract a diverse employee base that reflects our community.

We are committed to equal employment opportunity regardless of race, color, religion, interaction (including pregnancy), gender identity, interactionual orientation, national origin, age, disability, genetic information, military status or any other protected status under applicable federal, state or local law. Ultimately, SRP aspires to fully apply the power of diversity and inclusion to build a more equitable and sustainable future for our customers, employees and community. Drug/Alcohol Policy Statement SRP is committed to maintaining a work environment that promotes the health, safety and well-being of our employees, visitors, customers, and the communities we serve.

This commitment includes maintaining a work environment that is free from drugs and alcohol. Any candidate that tests positive for an illegal drug or unauthorized substance, including non-medical marijuana, during the pre-employment drug and alcohol screening will be disqualified from further consideration in the hiring process. Although marijuana is legal in the state of Arizona, SRP abides by federal laws where it remains illegal. All candidates must be legally authorized to work in the United States.

Currently, SRP does not sponsor H1B visas. Why Work at SRP 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: • 401(k) plan with employer matching • Retirement pension • Paid vacation • Parental leave • Holiday pay • Sick leave • Medical, vision, dental and life insurance • Wellness programs • Pre-tax benefits • Short and long-term disability plans • Tuition assistance

View Jobs by Category >>

Related Jobs