SIGN IN
Analytics Developer - Customer Analytics Team jobs in United States
cer-icon
Apply on Employer Site
company-logo

Salt River Project · 1 day ago

Analytics Developer - Customer Analytics Team

Salt River Project 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. The Analytics Developer will work on dashboards, interactive visualizations, data pipelines, and reports, collaborating with business partners to develop and implement analytical data models and dashboards.
Energy
check
Comp. & Benefits
badNo H1Bnote

Responsibilities

Define and develop dashboards including business metrics and performance indicators that drive action and insights (PowerBI experience preferred)
Be able to perform complex data queries, as well as build and maintain ETL pipelines utilizing data migration services (Azure Data Factory, SSIS), languages, and tools that connect various data sources (Snowflake, SQL Server, DB2)
Apply query, data exploration and transformation, basic statistical methods and visualization techniques to create business insights or improve data quality
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

Qualification

SQLPowerBIAzure Data FactorySnowflakeETL processesData modelingPythonSSISData integrationAnalytical skillsCritical thinkingProblem solvingOrganization skillsCommunication skills

Required

Experience with all Business Intelligence (BI) domains from translating requirements to sourcing, profiling, and modeling data, to ETL and dashboard development
Ability to define and develop dashboards including business metrics and performance indicators that drive action and insights
Ability to perform complex data queries, as well as build and maintain ETL pipelines utilizing data migration services (Azure Data Factory, SSIS)
Experience with languages and tools that connect various data sources (Snowflake, SQL Server, DB2)
Ability to apply query, data exploration and transformation, basic statistical methods and visualization techniques to create business insights or improve data quality
Experience in performance tuning and query optimization
For a Level 1 (Associate), a minimum of no previous years of experience to two years related experience is required (if no degree, four-six years of relevant experience or equivalent combination of education and related experience totaling four-six years)
For a Level 2 (Journey), a minimum of two years of experience to four years related experience is required (if no degree, six-eight years of relevant experience or equivalent combination of education and related experience totaling six-eight years)
For a Level 3 (Senior), a minimum of five years of related experience is required (if no degree, nine years of relevant experience or equivalent combination of education and related experience totaling nine 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
All candidates must be legally authorized to work in the United States

Preferred

Degree in Computer Sciences, Information Technology, Computer Engineering, Analytics, or related discipline
Advanced proficiency with PowerBI, Power Query, Paginated Reports, and related tools
Strong proficiency with Snowflake SQL and SQL Server T-SQL
Experience coding ETL processes in Azure Data Factory and SSIS
Expertise in modern database technologies, data integration, reporting
Solid understanding of data warehousing concepts and data modeling (Prefer 3+ years)
Knowledge of SAP and its data-related tools (Datasphere, Analytics Cloud, etc) is a plus
A bachelor's degree relevant to the assignment from an accredited institution is preferred

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

Company

Salt River Project

company-logo
As one of Arizona's largest utilities, Salt River Project has delivered low-cost, reliable power and water for more than 100 years.