Business Intelligence Technology Analyst (II or Sr.)

LIVE, WORK AND PLAY!

Chelan County PUD is located 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.  The cover letter must contain information specific to the applicant’s direct experience with analyzing, administering, designing and maintaining enterprise business intelligence solutions. Incomplete materials will not be considered.

To expedite the application process, combine your cover letter and resume into one PDF or WORD 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. 

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 BI Tech Analyst II ( $69,680-$87,100)  BI Tech Analyst Sr. ($86,320-$107,900) (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

JOB FUNCTIONS: To perform this job successfully, an individual must be able to perform each essential function of the job satisfactorily.  Essential functions are those activities that, if not performed, would significantly and fundamentally alter the position.  

  % of Time    Job Functions

1.  30%         BI Systems Development: Leads the monitoring and maintenance of existing data extracts and data models and recommends development of new models packages, reporting cubes, relational data models and Excel-based data extracts and transformations of high complexity for systems that are critical to financial and operational reporting.  Develops strategies to ensures published models and reports reflect changes in underlying data schemas and definitions. Creates and maintains system data model documentation. Develops reporting to support business processes.

2.  25%     Business Intelligence Systems Administration:   Independently administers the end-to-end BI systems environment(s) with support from technical, operational, and management staff and working teams. Develops and executes strategies for efficiently managing and improving  BI system content, including the District's balanced scorecard, reporting cubes, data extraction packages and reports through improved testing, monitoring, validating, and publishing BI metadata. Administers user accounts and security and troubleshoot/resolve user and software technical issues. Leads relationship with software vendors and account representatives for licensing and release management. Works with vendor support on new release upgrades/rollout, including end-user communication and education.  Works closely with software support to escalate system issues and potential bugs, submitting support tickets as necessary.  Maintains technical documentation and procedures for administering the Cognos ecosystem.  Provides end-user support.

3. 25%      BI Systems Analysis:   Analyzes, expands and/or modifies Business Intelligence systems and address issues of high complexity to serve new purposes or improve workflow. Identifies BI processing business requirements and translates into specific systems capabilities, data, and/or process designs used to develop BI solutions.  Collaborates to determine software and data architecture solutions that meet performance, scalability, reliability and security needs. Participates in cross-functional teams to make architectural decisions related to data, technology and systems tradeoffs.  Leads feasibility study development and alternatives to complex problems.

4.    10%  System Documentation & Training: Produces detailed documentation of systems and processes developed. Provides training to other departments on BI technologies and techniques as well as the systems, processes and data.

5.    10%  BI and Data Analysis: Creates new reports and dashboards utilizing the business intelligence tools. Supports the monthly and quarterly enterprise financial reporting cycle through data source and reporting cube management. Creates and maintains financial reporting cycle documentation. Leads business intelligence projects with broader scope and participate in enterprise project teams.

6. Ongoing         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).

QUALIFICATIONS: The qualifications listed below are representative of those required, but reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job. 

Post-Secondary Education:                                                      

Bachelor’s Degree (B.A., B.S.) in Computer Science, Information Systems, Information Technology, or closely related field; or the equivalent combination of education and experience.  Advanced degree, training, or certification desired.

Experience:

BI Technology Analyst II: Typically requires a minimum of three (3) years analyzing and administering enterprise reporting platforms, developing complex data models, reports, and dashboard design, and performing financial and operational reporting and analysis.   Utility experience is desired. 

BI Technology Analyst Sr. : Typically requires a minimum of six (6) years analyzing and administering enterprise reporting platforms, developing complex data models, reports, and dashboard design, and performing financial and operational reporting and analysis.  Experience including a minimum of 2 (two) years direct experience with IBM Cognos Analytics is desired.  Utility experience is desired. 

Specific KSA's: A fully skilled incumbent will have the following specific knowledge, skills, and abilities.

Knowledge

• Advanced knowledge analyzing, administering, and designing enterprise business intelligence solutions (advanced knowledge of IBM Cognos Analytics is desired).
• Advanced knowledge of business and process analysis functions. Knowledge of the design, development and application of technology and systems to meet business needs.
• Deep knowledge of business intelligence and information processing such as data integration, reporting and analysis. Experience with logical data design and data mapping or data conversion.
• Advanced knowledge of analytical and statistical techniques.
• Business Intelligence tools and concepts (IBM Cognos Framework Manager and Transformer are desired).
• Technology architecture and designs 
• Business performance measurement methods
• Intermediate knowledge of Excel, Word and PowerPoint

Skills & Abilities:

• System and security administration for enterprise BI solutions.
• Project management skills, including ability to lead cross-functional teams.
• Experience creating multi-prompt reports with drill-through capabilities
• Experience scheduling and monitoring data acquisition jobs
• Excellent analytical, problem-solving and research ability as evidenced by experience in the identification of requirements and the definition, evaluation, and selection of appropriate solutions to business problems or opportunities
• Advance abilities in multidimensional cube modeling. 
• Skilled t in creating relational data packages. 
• Advanced skills in creating dashboards and visualizations.
• Communicate effectively both orally and in writing to executive level audiences
• Strong technical documentation skills
• System analysis and design
• Strong abilities in developing and deploying effective analytical solutions
• Ability to lead and facilitate group work process development or improvements through project management
• Proven skills in observing and interpreting trends
• Ability to analyze data and identify key relationships
• Ability to develop logical conclusions and recommendations for management review
• Skilled in facilitation between operations and technical support staff
• Self-directed & motivated
• Proven ability to set priorities effectively & meet critical deadlines

Language Skills:  Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public. Must be proficient in reading, writing and speaking English.                                                         

Mathematical Skills:    Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.                                                 

Reasoning Ability:  Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.                                                           

Complexity:  Manages and performs an extensive range and variety of complex technical or professional work activities, some without precedent.  Takes a broad perspective to identify solutions.

Decision Making:  Works independently, under limited supervision.  Acts as a resource for colleagues with less experience.  Trains and mentor’s others.  May act as a team leader.  Advises management on best work methods, processes and/or application of policy.  Receives guidance in complex situations.                                                 

Computers & Equipment: A fully skilled incumbent will have the ability to utilize the following software, hardware, or equipment: To perform this job successfully, an individual is required to have intermediate knowledge of Microsoft PowerPoint, Microsoft Word and Microsoft Excel.

PHYSICAL REQUIREMENTS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit.  The employee is frequently required to use hands to finger, handle, or feel; use repetitive hand or arm motion; talk, hear.  The employee is occasionally required to stand; walk; reach with hands and arms; carry or lift unassisted up to 10 pounds; lift above shoulder up to 10 pounds.  Vision requirements include close vision.

WORK ENVIRONMENT: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level is usually moderate.

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)