Data Analyst (II, III or Senior)

*LIVE, WORK AND PLAY!*

Chelan County PUD is located in central Washington State at the confluence of the Columbia and Wenatchee Rivers. As a public power leader, we embrace the challenges and opportunities of our dynamic operations.

Powered by the Columbia River, we generate hydropower while prioritizing environmental stewardship. Each year, we invest millions of dollars and countless hours to protect fish, wildlife, and plant ecosystems. Our efforts also include creating 14 parks, welcoming over 3 million visitors annually.

*APPLICATION MATERIALS*

Applicants are required to submit a *combined cover letter and resume in one PDF document.* Your cover letter must summarize your interest, education and experience relevant to the Data Analyst (II, III, Senior) position. *Incomplete materials will not be considered.*

*The cover letter must be no more than two pages and must address these bullet points:*

* What specific aspects of the job you find appealing/challenging, and what specifically can you offer to be successful in this position.

* Experience in designing, developing, and utilizing data analytics and business intelligence solutions to empower users with better access to data and insightful information.

* In your data analytics and business intelligence experience, briefly describe the tools you have used and your level of proficiency.

This position is OPEN UNTIL FILLED and applicants are encouraged to apply immediately. *The first review date for application materials is scheduled for May 19, 2025.*

Interested parties are also invited to contact Human Resources at to discuss the position.

*SALARY RANGE*

The *starting* salary range for Data Analyst II is $86,800 - $108,500 (based on qualifications). With tenure and strong performance _in this role_ an employee may earn up to a maximum of $130,200, annualized.

The *starting* salary range for the Data Analyst III is $101,120 - $126,400 (based on qualifications). With tenure and strong performance _in this role_ an employee may earn up to a maximum of $151,680, annualized.

The *starting* salary range for the Data Analyst Senior is $114,960 - $143,700 (based on qualifications). With tenure and strong performance _in this role_ an employee may earn up to a maximum of $172,440, annualized.

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

*BENEFITS EPOA*

In addition to competitive wages Chelan PUD employees also enjoy outstanding benefits which include zero cost employer funded medical, dental, and vision healthcare benefits, access to the employee assistance program, a VEBA health reimbursement account, and long-term care.

Washington state retirement PERS participation and optional 457 plan participation with an employer matching 401(a) plan.

Leave, life & disability benefits including paid leave starting at 21 days per calendar year up to 35 with tenure, 11 paid holidays per calendar year, paid jury duty, short-term disability & long-term disability, and basic life, AD&D, and optional voluntary life.

The work life benefits include optional flexible spending accounts for healthcare and dependent care, educational assistance, various rewards and recognition programs and position specific stipends.

For more explanation of the district benefits please visit our benefits website

*JOB POSTING*

_*Data Analyst II*_

*Overview*

The Data Analyst II will design, develop, enhance and utilize data analytics and business intelligence information, with assistance from higher level Analysts, and will contribute to the development of business processes as assigned 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.

*Responsibilities*

* Data Analytics – Contribute to the design, development, enhancement, and the use of data analytics and tools to meet customer and business decision-making needs. Analyze structured data and related information and formulate a wide range of insights. Contribute to changes and recommendations provided by senior analysts. Perform research and analysis on data analytics practices and techniques. Be a resource for data analytics in special projects, client requests and reports requiring analytics. May Programmatically evaluate noisy data and develop automated analytics processes. Explore data sources, processes, uses, definitions, clean, process and translate data into model designs that are later moved to production and maintained.

* Business Intelligence - Collaborate on design, development, and troubleshoot new and existing business intelligence reporting tools. Identify data-driven information, metrics and reporting needs and requirements. Seek opportunities for stakeholders to utilize data analytics and business intelligence tools to enhance District’s capabilities in being a data-driven organization. Test and validate tools and data for accuracy. May Conduct quality assurance checks, create recurring reports and assist the development of reporting dashboards.

* Reporting, Communications and Collaboration - Build and maintain strong collaborative working relationships. Provide regular progress updates and feedback to management and customers. Leverage internal subject matter expertise. Perform ad-hoc requests, including data analytics, reporting needs, process improvements and automations. Make written and verbal recommendations to management to provide ongoing insight into strategy and operations.

* Participates on project teams. Assist with data analytics, business intelligence initiative, or research efforts with small scope and impact.

*Overtime exemption*

Exempt

*Qualifications*

*Education*

Equivalent experience (year for year) may substitute for required education.

* Bachelor's Degree in mathematics, analytics, business, information technology, management information systems, or related field required.

* Master’s Degree is desired.

*Experience*

* 3+ years Progressively responsible experience in a data analytics or business intelligence role with demonstrated examples of designing, developing and implementing technology solutions to support user needs, complex data analytics, corporate performance reporting, and dashboards is required.

* Experience related to the area of the organization this role will support, such as asset management or hydro operations is desired.

*Skills and Abilities*

A fully skilled incumbent will have the following knowledge skills & abilities:

* Demonstrated skills in analytics around large structured production data and operational datasets using a variety of general mathematic techniques.

* Working knowledge of quantitative analysis and programming techniques, such as R, Python SQL, and other tools to translate complex and diverse data structures into useful insights to support decision-making.

* Demonstrated knowledge of business intelligence tools like Power BI, Tableau, Oracle Business Intelligence, or similar.

* Ability to build relational data and reporting models in BI tools such as Power BI.

* Knowledge of online analytical processing (OLAP), software as a service application, data cubes, SQL tools, business objects and data mining tools, and similar tools.

* Knowledge of analytics, data mining, and data cleansing.

* Working knowledge of analytical, data visualization, and machine learning techniques, such as cluster analysis and neural networks.

* Familiarity with time-series data and tools such as AVEVA PI and work management tools such as Maximo or Primavera.

_*Data Analyst III*_

*Overview*

The Data Analyst III will independently design, develop, enhance and utilize data analytics and business intelligence information, and will participate in complex business process design or redesign projects as a team member 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.

*Responsibilities*

* Data Analytics - Initiate and coordinate design, development, enhancement and the use of data analytics and tools and provide mentoring and guidance to peers and subordinate staff to respond to internal analytical requests. Analyze more unstructured data, draw conclusions, and make recommendations. Perform extensive analysis of large and diverse datasets. May Programmatically evaluate noisy data and develop automated analytics processes. Explore data sources, processes, uses, definitions, clean, process and translate data into model designs that are later moved to production and maintained.

* Business Intelligence - Initiate and coordinate the design, development and implementation of business intelligence solutions. Participate and potentially lead discussions with the Data Analytics and Business Intelligence core team. Research and evaluates new and existing data analytics and business intelligence reporting tools. May Test and validate tools and data for accuracy; conduct quality assurance checks, create recurring reports, and develop reporting dashboards.

* Reporting, Communications and Collaboration - Foster strong collaborative working relationships with members of cross-functional teams and internal stakeholders, prioritizing, and resolving roadblocks, and seeking ways to improve methods for utilization of data analytics and business intelligence. Develop executive level presentations and management communications. Perform ad-hoc requests as assigned and make recommendations to management related to strategy and operations insights. Perform extensive analysis on intermediate ad-hoc requests, including data analytics, reporting needs, and process improvements and automations.

* Project and People Leadership – Performs data analytics, business intelligence or research projects with a moderate scope and impact. Supports senior analysts in coordinating activities and action items of others involved in planning processes. Trains and mentors junior level staff, across divisions.

*Overtime exemption*

Exempt

*Qualifications*

*Education*

Equivalent experience (year for year) may substitute for required education.

* Bachelor's Degree in mathematics, analytics, business, information technology, management information systems, or related field is required.

* Master’s Degree is desired.

*Experience*

* 5+ years Progressively responsible experience in a data analytics or business intelligence role with demonstrated examples of designing, developing and implementing technology solutions to support user needs, complex data analytics, corporate performance reporting, and dashboards is required.

* Experience related to the area of the organization this role will support, such as asset management or hydro operations is desired.

*Skills and Abilities*

A fully skilled incumbent will have the following knowledge skills & abilities:

* Knowledge of complex analytics around large production data and operational datasets. Uses a variety of techniques using mathematics and statistics, such as K-means clustering, parametric and non-parametric regressions, time series analysis, Monte Carlo simulations, and decision trees, etc.

* Demonstrated skills in at least one quantitative analysis and programming technique, such as R, Python SQL, or other tool to translate complex and diverse data structures into useful insights to support decision-making.

* Knowledge of analytical, data visualization, and machine learning techniques, such as cluster analysis and neural networks.

* Knowledge of data warehousing/business intelligence best practices, methodologies, standards, and data architectures.

* Demonstrated skills in building relational data and reporting models in data warehouse environments such as Fabric, Snowflake, Oracle, SQL.

* Demonstrated knowledge in utilizing time-series data analytics tools and software, such as AVEVA PI.

* Knowledge of online analytical processing (OLAP), software as a service application, data cubes, SQL tools, business objects and data mining tools, and similar tools.

* Knowledge of management decision making subjects and concepts such as finance and accounting.

_*Data Analyst Sr*_

*Overview*

The Data Analyst Sr. will design, develop, enhance and utilize advanced data analytics and business intelligence information in multiple business systems in use in multiple business units, and will take a lead role in complex business process design or redesign, 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. May assign work to lower-level analysts.

*Responsibilities*

* Data Analytics - Initiate, coordinate and lead the design, development and use of advanced data analytics and tools and provide mentoring and guidance to peers and subordinate staff to respond to internal analytical requests. Analyze complex and sometimes unstructured data, draw conclusions, and make recommendations. Perform complex and extensive analysis of large and diverse datasets through advanced mathematical or machine learning methods. Programmatically evaluate noisy data and develop automated analytics processes; explore data sources, processes, uses and definition and clean, process and translate data into model designs that are tested, refined, moved to production, and maintained.

* Business Intelligence – Lead the design, development, and implementation of business intelligence solutions. Lead discussions with the Data Analytics and Business Intelligence core team. Recommend new and existing data analytics and business intelligence reporting tools. Test and validate tools and data for accuracy; conduct quality assurance checks, create recurring reports and develop reporting dashboards.

* Reporting, Communications and Collaboration - Foster strong collaborative working relationships with members of cross-functional teams and internal stakeholders, prioritizing, and resolving roadblocks, and seeking ways to improve methods for utilization of data analytics and business intelligence. Develop Board level presentations and management communications. Lead ad-hoc requests as assigned and make recommendations to management related to strategy and operations insights. Perform extensive analysis on complex ad-hoc requests, including data analytics, reporting needs, and process improvements and automations.

* Project and People Leadership - Leads data analytics, business intelligence or research projects with broad, enterprise scope and impact. Coordinates activities and action items of others involved in complex planning processes. Trains and mentors junior level staff, across divisions.

*Overtime exemption*

Exempt

*Qualifications*

*Education*

Equivalent experience (year for year) may substitute for required education.

* Bachelor's Degree in mathematics, analytics, business, information technology, management information systems, or related field is required.

* Master’s Degree is desired.

*Experience*

* 7+ years Progressively responsible experience in a 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. required.

* Experience related to the area of the organization this role will support, such as asset management or hydro operations is desired.

*Skills and Abilities*

A fully skilled incumbent will have the following knowledge skills & abilities:

* Organizational thought leader of advanced analytics around large production data and operational datasets. Uses a variety of

Full Time