Water Utility Financial Data Analyst - Data Insights Lead

American States Water Company; San Dimas (CA); On-site; USD 90,000 - 151,000; Full time

Benefits offered by this job

Medical, dental, and vision plans

401(k) retirement plan with company匹配

Paid holidays and vacation

Life, AD&D, and LTD insurance

HSA and FSA options

Job summary

American States Water Company seeks a Water Utility Financial Data Analyst in San Dimas, CA to transform raw financial and operational data into actionable insights that support forecasting, budgeting and profitability analyses. The role combines financial expertise with data science to empower strategic decision making.

The candidate will build BI reports, validate data from ERP, CRM and data warehouses, and collaborate with stakeholders to deliver accurate metrics and dashboards while ensuring

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 in a similar role preferred

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.
• Performs data quality analysis to ensure accuracy and reliability of data used for decision‑making.
• Assists in the development of the General Rate Case with GAAP/SOX compliance.

Skills

Analytical thinking

Detail oriented

Communication skills

Education

Bachelor’s degree in applied Math, Computer Science, Finance or related discipline

Tools

SQL

Python

R

ETL

Azure

Power Platform

PowerBI

Tableau

Job description

American States Water Company seeks a Water Utility Financial Data Analyst in San Dimas, CA to transform raw financial and operational data into actionable insights that support forecasting, budgeting and profitability analyses. The role combines financial expertise with data science to empower strategic decision making.

The candidate will build BI reports, validate data from ERP, CRM and data warehouses, and collaborate with stakeholders to deliver accurate metrics and dashboards while ensuring