Water Utility Financial Data Analyst (70.26)

International Executive Service Corps; San Dimas (CA); On-site; USD 90,416 - 150,813; Full time

Benefits offered by this job

Medical/Dental/Vision

401(k) plan

Paid holidays

Job summary

Golden State Water Company is seeking a Water Utility Financial Data Analyst to transform raw financial and operational data into actionable insights that drive forecasting, budgeting, profitability analysis, and strategic decision-making.

This role collaborates with stakeholders across GSWC, develops BI dashboards (PowerBI/Tableau/Excel), ensures data quality and governance, and supports GAAP and Sarbanes‑Oxley compliance while advancing performance metrics for the Water Utility Group.

Qualifications

• Bachelor’s degree in applied Math, Computer Science, Finance or related discipline
• 6+ years of progressive experience in data management and financial accounting
• Proven experience as a Data Analyst or similar role preferred

Responsibilities

• Collaborates to develop and execute analytics/BI strategy for GSWC
• Extracts, cleanses and validates financial data from multiple sources
• Conducts robust analysis to identify gaps, trends and patterns for strategic decision-making
• Applies advanced techniques in large-scale data compilation and mining
• Ensures data integrity by resolving discrepancies
• Develops and maintains lookup/mapping tables for data consistency
• Utilizes relational databases with data quality/governance
• Develops/ designs key business metrics to evaluate Water Utility Group performance
• Creates interactive dashboards (PowerBI, Tableau, Excel) to visualize KPIs
• Automates and streams financial reporting using Excel, SQL, Python, BI platforms
• Collaborates with end users to enhance data management and analytics infrastructure
• Performs Data Quality analysis for accuracy
• Troubleshoots issues to improve system efficiency
• Supports GAAP and Sarbanes-Oxley compliance in rate cases

Skills

Advanced Excel

SQL

Python

R

Power BI

Data visualization

Education

Bachelor’s degree in related field

Tools

SQL

Python

R

ETL

Azure

Power Platform

Job description

Water Utility Financial Data Analyst (70.26) Location SAN DIMAS, CA (Via Verde) Job Code 70.26 Pay range $90,416 - $150,813 Annually

Golden State Water Company is one of the largest investor‑owned water utilities in the United States. We deliver quality, reliable water to more than 1 million people in over 80 communities throughout California. Golden State Water has been in business for more than 90 years because we put customers first.

Position Description

The Water Utility Financial Data Analyst (Analyst) transforms raw financial and operational data into actionable insights to drive business strategy and performance. This role requires a blend of financial expertise, technical data analysis skills, and business acumen to support forecasting, budgeting, profitability analysis, and decision‑making. The ideal candidate will be proficient in data manipulation, statistical analysis, and financial modeling, with the ability to communicate findings effectively to both financial and non‑financial stakeholders.

The Analyst collaborates with key GSWC stakeholders to understand business objectives, identify analytical needs, and develop business intelligence deliverables that assess performance against goals.

Accountability

The Analyst reports to the Operation Financial Analyst Supervisor and works closely with a number of stakeholders and executive leaders across GSWC. The Analyst also works in an environment that includes sensitive and confidential data and information; therefore, the Analyst must have the ability to achieve policy objectives related to data and information control and governance, including accountability for confidentiality of information. The incumbent in this position must work independently, exercise initiative and judgment in the performance of a broad range of responsibilities, including the ability to communicate with a diverse group of employees, executives and external consultants, to ensure understanding of P&A goals, objectives and organizational policies and procedures.

Essential Duties and Responsibilities

• Collaborates with the Operation Financial Analyst Supervisor to develop and execute a comprehensive analytics and business intelligence strategy for GSWC
• Extracts, cleanses and validates financial data from multiple sources (ERP systems, accounting software, CRM, data warehouse, external databases)
• Conducts robust analysis to identify gaps, trends, and patterns, providing actionable insights for strategic decision‑making
• Applies advanced techniques in large‑scale data compilation and mining to uncover meaningful patterns in accounting and operational data
• Ensures data integrity by identifying and resolving discrepancies, missing entries, or anomalies
• Develops and maintains lookup and mapping tables to ensure data consistency and accuracy across various datasets
• Utilizes relational database management skills, adhering to data quality, security, and governance standards
• Develops, designs, and refines key business metrics to evaluate Water Utility Group performance
• Creates interactive dashboards (PowerBI, Tableau, Excel) to visualize KPIs, trends and business performance
• Automates and streamlines financial reporting using tools like Excel, SQL, Python, or BI platforms
• Collaborates with end users to enhance the data management and analytical infrastructure
• Conducts Data Quality analysis to ensure accuracy and reliability of data used for decision‑making
• Performs complex troubleshooting, root‑cause analysis, and solution development to address challenges, and enhance system efficiency
• Facilitates the integration of business processes, people, and relevant technology to deliver actionable insights.
• Assists in the development of the General Rate Case in close coordination with others by providing relevant financial reports and other supporting documents, ensuring compliance with Generally Accepted Accounting Principles (GAAP) and Sarbanes Oxley requirements, in accordance with the Uniform System of Accounting and data security standards for water utility
• Performs other duties as assigned

Minimum Position Qualifications

Education and Experience

• Bachelor’s degree in applied Math, Computer Science, Finance or related discipline
• 6+ years of progressive experience in areas related to data management and financial accounting
• Proven experience as a Data Analyst or in a similar role preferred

Technical Skills

• Advance Excel (Pivot Tables, Power Query, VBA, complex formulas)
• Proficiency in database analysis and programming tools (SQL, Python, R., ETL, Azure, Power Platform) preferred
• Experience with data visualization tools (example PowerBI, Tableau) preferred

Key Competencies

• Strong analytical, quantitative and problem‑solving abilities
• Detail oriented with a high degree of accuracy
• Ability to conduct research, analyze data, and resolve complex issues independently
• Proven ability to multi‑task, meet tight deadlines, and thrive in fast‑paced environment
• Critical thinking skills with minimal supervision required
• High level of discretion, maturity, and professionalism
• Excellent communication, presentation, and interpersonal skills

Qualities of a Successful Data Analyst

• Passion for empirical research data‑driven decision making
• Trustworthy with strong personal integrity
• Accountable, disciplined, and results‑driven
• Strong impact and Influencing skills
• Collaborative and team oriented
• Emotionally mature and professional
• High degree of initiative; a self‑starter

May include but not limited to standing, climbing, walking, lifting, bending, pulling and/or pushing, grasping, reaching, stooping and crouching, sitting, typing, walking, reading, writing, color determination, speaking and listening for extended periods of time.

Benefits

Our Company supports our employees with rich benefit programs and resources to help them thrive today and prepare for tomorrow. Benefit options include medical, dental, and vision plans with the Company currently paying 85% of the monthly premium for employees and their eligible dependents. We also offer paid vacation and sick time and twelve Company paid holidays per year. To help our employees plan for the future, we offer both a 401(k) retirement plan as well as a Defined Contribution Profit Sharing retirement plan. Additional benefits include life, AD&D, and LTD insurance as well as health savings account and flexible spending plans.

Compensation Information

The compensation range provided is in compliance with state specific laws. Multiple factors are used to determine the actual starting rate of pay for all of our positions, including specific skills, years of experience, education, certification(s), and other job related factors.

The responsibilities of this position will involve access to information that may be considered confidential, private and sensitive. Therefore, the individual filling this position will be required to both allow and pass a background check.

NOTE: Reasonable accommodations will be made to enable individuals with special needs to perform the essential functions.

The Company is committed to providing equal employment opportunities for all job applicants and employees. The Company prohibits unlawful discrimination on the basis of race, religion, color, national origin, ancestry, physical disability, mental disability, legally protected medical condition, marital status, sex, gender, gender identity or expression, sexual orientation, age over 40, military or veteran status or any other basis protected by federal, state or local law.