Water Utility Financial Data Analyst (70.26)

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

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

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.

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 QualificationsEducation 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.