Data Analyst (I, II, III or Senior)

APPLICATION MATERIALS

SALARY RANGE

BENEFITS EPOA

JOB POSTING

• Data Analytics - Support the design, development, and use of data analytics and tools to meet customer and business needs. Analyze data, formulate and communicate insights. Perform entry level analysis of large and diverse datasets, such as 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. 
• 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. Assist in the development of reporting dashboards. Participate in the support of business intelligence tools, data environment, performance reporting metrics, and financial data cubes. Assist senior analysts in testing, monitoring, validating and publishing business intelligence content.
• Reporting, Communications and Collaboration - Perform basic ad-hoc requests, including data analytics, reporting needs, and process improvements and automations. Provide entry level data analytics insights and actively participate on Data Analytics and Business Intelligence core team. Collaboratively work and communicate with members of cross-functional teams and internal stakeholders.
• Project Teams - Participates on project teams performing individual assignments.
• Maintain regular and predictable attendance: Perform related duties and responsibilities as required. Comply with District policies. Complete all required training. Maintain a working knowledge and comply with District safety procedures and specific safety requirements of this position, and those in accordance with applicable provisions of the Revised Code of Washington (RCW) and Washington Administrative Code (WAC).

• Bachelor's Degree in mathematics, analytics, business, information technology, management information systems, engineering, or related field is required. 
• Equivalent experience (year for year) may substitute for required education. 

• 0 years of experience required. 
• This is an entry-level role in data analytics and business intelligence. A college degree with demonstrated skills in designing, developing, and implementing technology solutions to support user needs—such as data analytics, corporate performance reporting, and dashboards—is preferred. 

• Working knowledge of data analytics around large production data and operational datasets using a variety of techniques using mathematics and statistics. 
• Working knowledge of quantitative analysis and programming techniques. 
• Working knowledge of analytics, data mining, and data cleansing. 
• Working knowledge of data warehousing/business intelligence best practices, methodologies, standards, and data architectures. 
• Working knowledge of operating systems, relational database design, logical data modeling, data warehousing, and relational database management systems. 
• Familiarity with management decision making subjects and concepts, such as finance and accounting. 
• Familiarity with process improvement techniques such as operational excellence, six sigma or similar. 
• Strong interpersonal and teamwork skills to solve problems creatively. 
• Good communication skills that can effectively communicate basic subjects to a variety of audiences. 
• Strong customer service skills and orientation. 
• Detail oriented with a high level of intellectual curiosity. 
• Strong logic and reasoning skills. 
• Strong critical thinking skills. 
• Able to analyze data and issues in a disciplined, structured, and analytical manner. 
• Leverage various tools and techniques such as mathematics, statistics and data science to create solutions. 
• Able to formulate a solution to a business problem, translate it into requirements or quantitative terms using analytical tools, analyze the results, iteratively refine the solution and effectively communicate results. 
• Ability to translate user requests into functional and technical requirements and effectively communicate with both the end user and technical team. 
• Ability to utilize information in both quantitative and qualitative form to inform development of actions. 
• Able to identify and weigh strengths and weaknesses of alternative solutions. 
• Ability to work constructively and maintain a positive outlook when facing tight deadlines. 
• Ability to plan, organize and prioritize work to optimize progress on multiple assignments and successfully meet deadlines. 
• Ability to work collaboratively on a team. 
• Ability and desire to solve problems and develop solutions. 
• Ability to accept constructive feedback. 
• Must enjoy the challenge and nuances of applying technology solutions to complex and often imperfect datasets. 
• Must be proficient in reading, writing and speaking English.

• Sitting Regularly 67-100% 
• Standing Occasional 11-33% 
• Walking Occasional 11-33% 
• Lifting 1-10 lbs Floor-Waist: Hand/Power tools, small parts/equipment Occasional 11-33% 
• Lifting 1-10 lbs Waist-Shoulders: Same Occasional 11-33% 
• Reach Waist to Shoulder Occasional 11-33% 
• Handle/Grasp Regularly 67-100% 
• Repetitive Motions Regularly 67-100% 
• Talking Frequent 34-66% 
• Hearing Frequent 34-66% 
• Visual - Near Acuity Regularly 67-100% 
• Visual - Far Acuity Regularly 67-100%
• Visual - Color Discrimination Regularly 67-100% 
• Feeling Regularly 67-100% 

• Noise Intensity Level: - Moderate

• Safety - Protect public and employee health and safety
• Stewardship - Acting on behalf of customer-owners, protecting public resources entrusted to us
• Trustworthy - Competence, integrity, respect
• Operational Excellence - High-quality innovative work execution

• 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.
• Maintain regular and predictable attendance: Perform related duties and responsibilities as required. Comply with District policies. Complete all required training. Maintain a working knowledge and comply with District safety procedures and specific safety requirements of this position, and those in accordance with applicable provisions of the Revised Code of Washington (RCW) and Washington Administrative Code (WAC).

• Bachelor's Degree in mathematics, analytics, business, information technology, management information systems, or related field required. 
• Master’s Degree is desired. 

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

• 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. 
• Working knowledge of business process notation and common methods such as operational excellence and six sigma. 
• Knowledge of finance and accounting concepts. 
• Working knowledge of data warehousing/business intelligence best practices, methodologies, standards, and data architectures. 
• Knowledge of operating systems, relational database design, logical data modeling, data warehousing, and relational database management systems. 
• Strong communication skills to effectively communicate complex subjects to a variety of audiences, including management. 
• Facilitation skills with ability to lead effective and productive meetings. 
• Strong customer service skills and orientation. 
• Strong detail orientation with a high level of intellectual curiosity. 
• Strong logic and reasoning skills. 
• Strong critical thinking skills. 
• Ability to translate Intermediate user requests into technical requirements and effectively communicate with both the end user and technical team, including both staff and management. 
• Ability to exercise a high degree of independent judgment and demonstrated self-starter. 
• Ability to utilize information in both quantitative and qualitative form to inform development of actions, draw conclusions and make recommendations. 
• Able to weigh strengths and weaknesses of alternative solutions, both quantitatively and qualitatively. 
• Able to analyze, conclude and make recommendations on best approach considering multiple factors such as cost and risk. 
• Able to facilitate cross-functional team discussions including both technical and non-technical participants. 
• Ability to plan, organize and prioritize work to optimize progress on multiple assignments and successfully meet deadlines. 
• Ability to work collaboratively on a team. 
• Ability to accept constructive feedback. 
• Ability to overcome roadblocks, and effectively work through an entire process. 
• Strong ability to understand operational data and effectively apply analytics to formulate useful information. 
• Able to work independently. 
• Must be proficient in reading, writing and speaking English. 

• Sitting Regularly 67-100% 
• Standing Occasional 11-33% 
• Walking Occasional 11-33% 
• Lifting 1-10 lbs Floor-Waist: Hand/Power tools, small parts/equipment Occasional 11-33% 
• Lifting 1-10 lbs Waist-Shoulders: Same Occasional 11-33% 
• Lifting 1-10 lbs Above Shoulders: Same Occasional 11-33% 
• Reach Floor to Waist Occasional 11-33% 
• Reach Waist to Shoulder Occasional 11-33% 
• Wrist/hand/fingers manipulation (keyboarding, manual tool usage, etc.) Frequent 34-66% 
• Handle/Grasp Frequent 34-66% 
• Forceful Grasp Frequent 34-66% 
• Repetitive Motions Regularly 67-100% 
• Visual - Near Acuity Regularly 67-100% 
• Visual - Far Acuity Regularly 67-100%
• Visual - Color Discrimination Regularly 67-100% 
• Feeling Frequent 34-66% 

• Noise Intensity Level: - Moderate

• Safety - Protect public and employee health and safety
• Stewardship - Acting on behalf of customer-owners, protecting public resources entrusted to us
• Trustworthy - Competence, integrity, respect
• Operational Excellence - High-quality innovative work execution

• 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. 
• Maintain regular and predictable attendance: Perform related duties and responsibilities as required. Comply with District policies. Complete all required training. Maintain a working knowledge and comply with District safety procedures and specific safety requirements of this position, and those in accordance with applicable provisions of the Revised Code of Washington (RCW) and Washington Administrative Code (WAC).

• Bachelor's Degree in mathematics, analytics, business, information technology, management information systems, or related field is required. 
• Master’s Degree is desired. 

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

• 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. 
• Knowledge of operating systems, relational database design, logical data modeling, data warehousing, and relational database management systems. 
• Knowledge of common process improvement methods and techniques such as operational excellence six sigma. 
• Outstanding interpersonal and teamwork skills with the ability to resolve conflict, remove barriers and roadblocks and solve problems creatively. 
• Strong verbal and written communication skills that can effectively communicate complex subject matter up, down and across the organization. 
• Project management skills, including development and management of scope, schedule, budget, and resource allocation.
• Facilitation skills with ability to lead effective and productive meetings. 
• Excellent customer service skills and orientation. 
• High detail orientation with a high level of intellectual curiosity. 
• Outstanding logic, reasoning, and critical thinking skills. 
• Ability to translate complex user requests into technical requirements and effectively communicate with both the end user and technical team, including both staff and management. 
• Ability and desire to solve problems, identify data-driven opportunities and develop solutions. 
• Able to facilitate cross-functional team discussions including both technical and non-technical participants. 
• Ability to overcome roadblocks, and effectively work through an entire process. 
• Strong ability to understand operational data and effectively apply analytics to formulate useful information. 
• Able to lead and mentor junior level staff. 
• Able to weight strengths and weaknesses of alternative solutions, both quantitatively and qualitatively. 
• Able to analyze, conclude and make recommendations on best approach considering multiple factors such as cost and risk. 
• Ability to exercise a high degree of independent judgment and demonstrated self-starter. 
• Ability to utilize information in both quantitative and qualitative form to inform development of actions, draw conclusions and make recommendations. 
• Ability to work collaboratively on a team. 
• Ability to accept constructive feedback. 
• Able to work independently. 
• Ability to plan, organize and prioritize work to optimize progress on multiple assignments and successfully meet deadlines. 
• Must be proficient in reading, writing and speaking English. 

• Sitting Regularly 67-100% 
• Standing Occasional 11-33% 
• Walking Occasional 11-33% 
• Lifting 1-10 lbs Floor-Waist: Hand/Power tools, small parts/equipment Occasional 11-33% 
• Lifting 1-10 lbs Waist-Shoulders: Same Occasional 11-33% 
• Lifting 1-10 lbs Above Shoulders: Same Occasional 11-33% 
• Reach Floor to Waist Occasional 11-33% 
• Reach Waist to Shoulder Occasional 11-33% 
• Wrist/hand/fingers manipulation (keyboarding, manual tool usage, etc.) Frequent 34-66% 
• Handle/Grasp Frequent 34-66% 
• Forceful Grasp Frequent 34-66% 
• Repetitive Motions Regularly 67-100% 
• Visual - Near Acuity Regularly 67-100% 
• Visual - Far Acuity Regularly 67-100%
• Visual - Color Discrimination Regularly 67-100% 
• Feeling Frequent 34-66% 

• Noise Intensity Level: - Moderate

• Safety - Protect public and employee health and safety
• Stewardship - Acting on behalf of customer-owners, protecting public resources entrusted to us
• Trustworthy - Competence, integrity, respect
• Operational Excellence - High-quality innovative work execution

• 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. 
• Maintain regular and predictable attendance: Perform related duties and responsibilities as required. Comply with District policies. Complete all required training. Maintain a working knowledge and comply with District safety procedures and specific safety requirements of this position, and those in accordance with applicable provisions of the Revised Code of Washington (RCW) and Washington Administrative Code (WAC).

• Bachelor's Degree in mathematics, analytics, business, information technology, management information systems, or related field is required. 
• Master’s Degree is desired. 

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

• Organizational thought leader of advanced 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 Advanced in multiple quantitative analysis and programming techniques, such as R, Python SQL, or other tools to translate disparate and diverse data structures into useful insights to support decision-making. 
• Demonstrated skills in 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 multi-source data acquisition, transformation and relational data and reporting models in a data warehouse environment such as Microsoft Fabric, Snowflake, Oracle or SQL in a cloud or hybrid architecture. 
• Demonstrated knowledge of time-series data analytics tools and software, such as AVEVA PI and familiarity with data organization through asset hierarchies. 
• 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. 
• Knowledge of operating systems, relational database design, logical data modeling, data warehousing, and relational database management systems. 
• Knowledge of, and ability to lead, common process improvement methods and techniques such as operational excellence or six sigma. 
• Outstanding interpersonal and teamwork skills with the ability to resolve conflict, remove barriers and roadblocks and solve problems creatively. 
• Outstanding verbal and written communication skills that can effectively communicate complex subject matter up, down and across the organization, including the Board and General Manager. 
• Project management leadership skills, including development and management of scope, schedule, budget, and resource allocation. 
• Strong Facilitation skills with ability to lead effective and productive meetings. 
• Excellent customer service skills and orientation. 
• High detail orientation with a high level of intellectual curiosity. 
• Outstanding logic, reasoning, and critical thinking skills. 
• Ability to translate complex user requests into technical requirements and effectively communicate with both the end user and technical team, including both staff and management. 
• Ability and desire to solve problems, identify data-driven opportunities and develop solutions. 
• Able to facilitate cross-functional team discussions including both technical and non-technical participants. 
• Ability to overcome roadblocks, and effectively work through an entire process. 
• Strong ability to understand operational data and effectively apply analytics to formulate useful information. 
• Able to lead and mentor junior level staff. 
• Able to weight strengths and weaknesses of alternative solutions, both quantitatively and qualitatively. 
• Able to analyze, conclude and make recommendations on best approach considering multiple factors such as cost and risk. 
• Ability to exercise a high degree of independent judgment and demonstrated self-starter. 
• Ability to utilize information in both quantitative and qualitative form to inform development of actions, draw conclusions and make recommendations. 
• Ability to work collaboratively on a team. 
• Ability to accept constructive feedback. 
• Able to work independently. 
• Ability to plan, organize and prioritize work to optimize progress on multiple assignments and successfully meet deadlines. 
• Must be proficient in reading, writing and speaking English. 

• Sitting Regularly 67-100% 
• Standing Occasional 11-33% 
• Walking Occasional 11-33% 
• Lifting 1-10 lbs Floor-Waist: Hand/Power tools, small parts/equipment Occasional 11-33% 
• Lifting 1-10 lbs Waist-Shoulders: Same Occasional 11-33% 
• Lifting 1-10 lbs Above Shoulders: Same Occasional 11-33% 
• Reach Waist to Shoulder Occasional 11-33% 
• Wrist/hand/fingers manipulation (keyboarding, manual tool usage, etc.) Frequent 34-66% 
• Handle/Grasp Frequent 34-66% 
• Repetitive Motions Regularly 67-100% 
• Talking Frequent 34-66% 
• Hearing Frequent 34-66% 
• Visual - Near Acuity Regularly 67-100% 
• Visual - Far Acuity Regularly 67-100%
• Visual - Color Discrimination Regularly 67-100% 
• Feeling Frequent 34-66% 

• Noise Intensity Level: - Moderate

• Safety - Protect public and employee health and safety
• Stewardship - Acting on behalf of customer-owners, protecting public resources entrusted to us
• Trustworthy - Competence, integrity, respect
• Operational Excellence - High-quality innovative work execution

BACKGROUND SCREENING

DISCLAIMER

EEO