Water Utility Data Analytics & Finance Expert

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

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.