Northern Wasco County PUD is searching for an experienced Data Analyst III to join our growing and dynamic organization. This position is full-time, 40 hours per week, and offers a flexible hybrid and 4/10 work schedule.
*** First review of applications will be the week of September 30, 2024
GENERAL SUMMARY:
Serves as the data and analytics resource for special projects, client requests, and reports requiring analytics across the organization that cross several functional areas with a strong emphasis in financial analytics. Create, maintain, and train staff on financial reporting tools. Research and analyses system wide District data and data analytic tools to inform and support decision making. Collaborates on designing, developing, and troubleshooting new and existing business intelligence reporting tools, and tests and validates tools and data for accuracy. Compiles data, performs statistical modeling and analysis of structured and unstructured datasets, provides analysis, develops metrics, identifies trends, and patterns and presents analysis through reports and presentations. Works with end-users to understand data and analysis needs and develop technical requirements. Provides written and verbal recommendations to management to provide ongoing insight into strategy and operations.
SUMMARY OF BENEFITS: We are proud to offer a comprehensive and very competitive benefits package including but not limited to:
- Generous PTO Accruals
- 10 Paid Holidays
- 85% employer paid premium for Medical/Rx/Dental for individual and/or family coverage
- 100% employer paid premium for vision coverage for individual and/or family coverage
- 100% employer paid Basic Life Insurance 2X annual salary
- 401(k) 5% base + 7% match = 12% total possible employer contribution
- 457(b)
- 100% Employer paid Short Term Disability and Long Term Disability
- HRA VEBA
- Business Travel Insurance
- Voluntary benefits
GENERAL ACCOUNTABILITIES AND ESSENTIAL FUNCTIONS:
-
Assist Finance Staff and other departments with highly complex analyses and studies on a wide range of financial, budgetary, variances, trends, rate setting and other organizational issues in support of the District goals and objectives. Works with end-users to understand data and analysis needs and develop technical requirements.
-
Compiles data, performs statistical modeling and analysis of structured and unstructured datasets, provides analysis, develops metrics, identifies trends, and patterns and presents analysis through reports and presentations.
-
Assist staff with the preparation of data and review of external reporting to ensure consistent, accurate, and timely data is reported.
-
Creates, maintains, and trains staff on data management and financial reporting tools, including but not limited to; Financial statements, Budget templates, Long Term Financial Plan; Budget to Actual Variance templates, Load Resource Energy Model, kWh Reports, Dashboards, KPI’s, various trending reports, and revenue modeling.
-
Identifies and applies appropriate methodologies, identify, and utilize sound analytical tools and apply accepted project planning and management practices on large projects to ensure timely achievement of goals and objectives.
-
Assists staff to develop, analyze, and maintain the District’s existing systems and models.
-
Works closely with department managers to identify operational budget and capital requests and needs associated with data management and analytical systems.
-
Prepares periodic and ad-hoc reports based on detailed research, critical analyses, and independent judgment. Makes presentations to staff, management and/or Board of Directors on analytical research and analyses performed.
-
Provides and presents both written and verbal recommendations that provide ongoing insight into strategy and operations that align with NWCPUD’s goals and strategic plan.
-
Participates in a variety of special projects including evaluations and analyses of systems, tasks and workflows and internal controls to identify, develop and implement business solutions.
-
Acts as a resource to all other District departments and assists with training other department staff.
-
Demonstrates cultural competency through respectful, inclusive work habits and through the valuing and welcoming of cultural differences in all position responsibilities.
-
Supports the District’s mission to serve our customers and foster a safe and positive work environment by personally exhibiting behavior that aligns with the District’s Core Values & Beliefs.
-
Must perform the duties of this position in a safe and efficient manner and follow all safety regulations and protocols.
-
Other duties as assigned.
Secondary Functions:
-
Update and maintain reports and KPI’s monthly.
-
Performs meter data management maintenance and analysis that supports trending and statistical modeling.
-
Performs other Finance Department duties in the absence of other assigned personnel, or as needed.
-
Assist with mentoring of junior analysts.
-
All PUD employees are expected to work outside of normal business hours when required during emergency restoration activities and to accomplish other special projects.
Skills/Knowledge/Abilities: PLEASE NOTE: This position requires the use of various tools/equipment that are related to performing the essential functions of this job.
-
General computer literacy, Microsoft Windows, intermediate to advanced Microsoft Office.
-
Advanced skill in Excel and PowerPoint.
-
Advanced skill in Tableau, Google Data Studio, or other data visualization software.
-
Working knowledge with Google suite products (Docs, Sheets, and Slides).
-
Understanding of ERP systems; Power BI experience a plus.
-
Analytical mindset: ability to analyze large sets of data and provide meaningful insight.
-
Strong communication and presentation skills; Ability to explain data/results to stakeholders with varying levels of expertise or knowledge on the subject matter.
-
Ability to teach, coach, and conduct training to other staff with diverse levels of expertise and knowledge, in a productive and comprehensible manner.
-
Ability to independently manage and prioritize tasks in a fast-paced, constantly evolving environment.
-
Ability to learn functional business processes of an electric utility.
-
Maintain working knowledge of federal, state, and local codes, ordinances, regulations, practices, and procedures related to the work including government accounting principles and practices and government budgeting laws, principles, and practices.
-
Possess complex critical thinking skills using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
-
Possess advanced problem-solving skills to identify complex problems and review related information to develop and evaluate options and implement solutions.
-
Ability to maintain a high level of focus and attention to detail and produce highly accurate work.
-
Ability to work independently with minim direction while also working as part of a team and consistently demonstrating collaborative, respectful, and productive work habits.
Supervisory and/or Functional or Technical Responsibility or Oversight:
-
No supervisory responsibilities.
- Is relied on for training as subject matter expert on systems and processes on data analytics in area of responsibility.
QUALIFICATIONS: Recommended Education, Training & Experience (includes licenses or certifications): Other combinations of education and/or experience demonstrating the knowledge, skills, and abilities required to do the work will also be considered.
Education/Experience:
-
Bachelor's degree in information systems, accounting, mathematics, statistics, economics, computer science, engineering or other related business or technical area. Master’s degree preferred.
-
Master’s degree in a related field preferred.
-
Seven to ten (7-10) years’ experience in a data analytics or business intelligence role demonstrating complex data analysis, reporting and automation.
-
Governmental reporting of electric utility accounting and financial systems experience or energy and environmental attributes is highly desirable as well as experience with SCADA, energy asset management systems, PowerPivot and Power BI tools.
Job Scope:
-
Works on extremely complex non-routine assignments where analysis of situations or data requires an evaluation of intangible variables. Exercises judgment in developing methods, techniques, and evaluation criteria for obtaining results.
-
Activities and decisions affect work accuracy, reliability, service quality, systems, or operations with moderate to significant financial impact and moderate impact to the general public, policyholders, business partners, and other customers through multiple contacts or activities that require the relationship management and impact the District's image and reputation.
-
Tasks and information relative to this position are of a confidential and/or sensitive nature requiring strict confidentiality and professional conduct.
-
Priority of tasks or projects can change quickly and might require multiple projects being worked at the same time while waiting for additional information or direction of project.
Mental or Visual Demand: Concentrated mental and/or visual attention; the work involves performing complex tasks to very close accuracy and quality specifications; or a high degree of hand and eye coordination for sustained periods of time.
Working Conditions: The job is typically performed under very comfortable working conditions; any disagreeable elements are generally absent during normal performance of job.
Physical Requirements: Requirements are those consistant with normal office administrative or clericlal positions such as sitting, standing, walking, keyboarding. May push up to 50lbs, and/or lift, pull, or carry up to 25lbs.
This organization believes that each employee makes a significant contribution to our success. That contribution should not be limited by the assigned responsibilities. Therefore, this job description is designed to outline primary duties, qualifications, and job scope, but not to limit the incumbent nor the organization to just the work identified. It is our expectation that each employee will offer their services wherever and whenever necessary to ensure the success of our endeavors. Northern Wasco County PUD reserves the right to revise or change job duties and responsibilities. This job description does not constitute a written or implied contract of employment.
***Northern Wasco County PUD is an Equal Opporunity Employer