Hydro Data Analyst I, II or Sr

  • Chelan County PUD
  • Wenatchee, WA, USA
  • Jul 11, 2022
Full-time Analytics Big Data Business Analytics Business Intelligence (BI) Data Analysis Data Modeling Data Reporting Data Warehousing Quantitative Research

Job Description

LIVE, WORK AND PLAY!

Chelan County PUD is in the geographical center of Washington State at the confluence of the Columbia and Wenatchee rivers. A public power leader, the complex and progressive nature of PUD operations offer a unique mix of challenges and opportunities.

We rely on the mighty Columbia River for much of our hydropower generation and we're proud to take a leadership role in environmental stewardship as related to this great river system. Each year we dedicate millions of dollars and thousands of work hours to protect and enhance fish, wildlife, and plant ecosystems. As part of hydropower operations, we've also built 14 parks that serve more than 3 million visitors each year.

Rated by Forbes in 2017 and 2019 as one of the top 25 places to retire, Wenatchee is a recreational paradise with an abundance of adventure. The natural scenic beauty of the Wenatchee Valley provides a vivid backdrop to its thriving economy, where the quality of life is high and the climate is moderate with four distinct seasons, including more than 200 days of sunshine!

We are a small town to some and big city to others. We invest in our children and believe that education is the key to our future success.

We live a life of abundant choices and enjoy water sports on the Wenatchee and Columbia rivers, hiking, biking, rock climbing and unlimited golfing. Downhill and cross-country skiing are just minutes away. The area is also known for producing quality wines.

Consider Chelan PUD as a career choice today! The community is waiting for you.

Chelan PUD is an Affirmative Action/Equal Opportunity Employer and values diversity at all levels of its workforce. M/F/Vet/Disabled

APPLICATION MATERIALS

Applicants are required to submit a combined cover letter and resume in one document. Your cover letter must summarize your interest, education, and experience relative to this position. Incomplete materials will not be considered.

To expedite the application process, combine your cover letter and resume into one PDF document before applying and upload electronically when requested in the online application process.

This position is OPEN UNTIL FILLED and applicants are encouraged to apply immediately.  The first review date for application materials is scheduled for July 18, 2022.

Interested parties are also invited to contact Human Resources at joblist@chelanpud.org to discuss the position.

SALARY RANGE

In addition to a competitive starting salary range of $69,520 - $86,900 (Data Analyst I); $83,680 - $104,600 (Data Analyst II); $99,520 - $124,400 (Data Analyst Sr) (based on qualifications, skills and abilities), Chelan PUD employees also enjoy outstanding benefits which include the option of a zero cost medical plan (medical, dental and vision for all eligible dependents), short and long-term disability, Washington State Public Employee's Retirement System, Deferred Compensation (with company matching funds up to 5%), 11 holidays and initial personal leave accrual at 21 days per year. 

Introductory Period: New employees holding regular positions must complete an introductory period of twelve months.

JOB POSTING

This position will be filled at either the I, II or Senior level, based on candidate qualifications. Below is a summary of duties for all three levels. Job descriptions for each specific level will be provided prior to interviews. This role will be focused on Hydro Operations.

JOB SUMMARY

The Data Analyst will support the design, development, enhancement and utilization of advanced data analytics and business intelligence information, and support process improvement to enable the District to build and sustain a 'best in industry' data-driven decision making environment, supporting a culture of continuous learning and continuous process improvement.

Job Functions

To perform this job successfully, an individual must be able to perform each essential function of the job satisfactorily.  
       
Data Analytics - Support the design, development and use of advanced data analytics and tools to meet customer and business needs. Analyze data, formulate and communicate insights. Perform basic analysis of large and diverse datasets, such as advanced metering data, hydro operational data, etc. Programmatically evaluate noisy data and develop automated analytics processes. Explore data sources, processes, uses and definition. Clean, process and translate data into model designs that are tested, refined, moved to production, and maintained. At level II or Senior: Draw conclusions and recommend new or changes to existing analytics. Be a resource for special projects, client requests and reports. Provide mentoring and guidance to peers.

Business Intelligence - Support the design, development and use of new and existing business intelligence processes and reporting tools. Conduct quality assurance checks. Create recurring reports. Develop reporting dashboards. Perform ad-hoc requests as assigned, etc. Provide direct support of business intelligence tools, data environment, performance reporting metrics, and financial data cubes. Test, monitor, validate and publish business intelligence content.   

Reporting, Communications & Collaboration - Perform basic ad-hoc requests, including data analytics, reporting needs, and process improvements and automations. Provide data analytics insights and expertise and actively participate on Data Analytics and Business Intelligence core team. Collaboratively work and communicate with members of cross-functional teams and internal stakeholders. At level II or Senior: Provide regular progress updates and feedback to management and customers. Train and coach users of business intelligence and data analytics tools. Make written and verbal recommendations to management to provide ongoing insight into strategy and operations. Perform extensive analysis on complex ad-hoc requests, including data analytics, reporting needs, and process improvements and automations. 

Project Teams - Participates on project teams performing individual assignments. Coordinates and facilitates project team meetings. May lead data analytics, business intelligence initiative, or research efforts of a limited nature. At level II or Senior: Lead data analytics, business intelligence initiative, or research efforts with small to moderate scope and impact. Provide training and guidance to junior level staff.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Post Secondary Education

  • Required:  Bachelor's Degree in mathematics, engineering, business, information technology, management information systems, or related field or equivalent combination of education and experience.
  • At level II or Senior: Master's Degree preferred. 

Minimum Experience

  • Required: 1 year in a data analytics, business intelligence, or closely related role. Candidates will have demonstrated experience designing, developing and implementing one or more of the following:
    • Technology solutions to support user needs
    • Data analytics
    • Corporate performance reporting
    • Dashboards    
  • At level II: 4+ years progressively responsible experience in data analytics or business intelligence role with demonstrated examples of designing, developing, and implementing all of the above. 
    • Desired: Experience related to the area of the organization this role will support, such as asset management or hydro operations.
  • At Senior level: 7+ years progressively responsible experience in data analytics or business intelligence role with demonstrated in-depth experience designing, developing, and implementing technology solutions to support user needs, including complex data analytics in a variety of subjects, corporate performance reporting, and development of dashboards.
    • Desired: Experience related to the area of the organization this role will support, such as asset management or hydro operations. 

Knowledge, Skills and Abilities

  • Working to extensive knowledge of data analytics around large production data and operational datasets using a variety of techniques using mathematics and statistics.
  • Working to extensive knowledge of quantitative analysis and programming techniques.
  • Working to extensive knowledge of analytics, data mining, and data cleansing.
  • Knowledge of data warehousing/business intelligence best practices, methodologies, standards, and data architectures.
  • Knowledge to strong knowledge of operating systems, relational database design, logical data modeling, data warehousing, and relational database management systems.
  • Familiarity with to strong working knowledge of process improvement techniques such as six sigma or similar.

Background Screening

Background screening is required prior to position entry for the following reason(s):

  • Pursuant to the North American Electric Reliability Corporation (NERC) standards, Chelan County Public Utility District #1 conducts background screening of personnel who have access to the District's critical physical and/or cyber assets.

BACKGROUND SCREENING

Pursuant to the North American Electric Reliability Corporation (NERC) standards, Chelan County Public Utility District #1 conducts background screening of personnel who have access to the District's critical physical and/or cyber assets.

DISCLAIMER

The statements contained herein reflect general details as necessary to describe the principal functions for this job, the level of knowledge and skill typically required, and the scope of responsibility. This should not be considered an all-inclusive listing of work requirements.  Individuals may perform other duties as assigned, including work in other functional areas to cover absences or relief, to equalize peak work periods or otherwise to balance the workload.

EEO

Chelan PUD is an Equal Employment Opportunity employer (EOE Minorities/Females/Protected Veterans/Disabled). We value diversity at all levels of the organization. All qualified applicants will receive consideration for employment without regard to any protected classifications as defined by law.

EEO Law Posters can be found on the main Careers page in English and Spanish. 

Chelan PUD will not be offering any work visa sponsorship for this role.

Pay Transparency Nondiscrimination Provision

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-I.35(c)

Salary

69,520 - 124,400