California Water Service

Job Description:

The Capital Program Reporting Analyst will extract, analyze and report on Capital Project data that is needed for a variety of reasons including:

• Understanding portfolio and program health and performance on a regular basis
• Providing data to decision makers in responses to changes in the capital program
• Enhance the processes for General Rate Case Budget preparation, filing
and data requests

This position will become the functional, subject matter expert on the integration, aggregation, analysis and reporting of capital project and cost estimate data from various sources including Microsoft Project Online (MSPO), Project for the Web, Powerplan, PowerBI, and enterprise cost estimating resources. The goal of this role is to provide meaningful project/program/portfolio data for a variety of users at various levels of the company to make informed, actionable decisions about the capital program. This position will support the expansion of an enterprise-wide Project, Program and Portfolio Management (P3M) information system to other Engineering teams and departments and maintain its planned integration with other data sources mentioned above.

The Capital Program Reporting Analyst reports to the Manager of Capital Budgeting and is not responsible for supervising other employees. This position is located in San Jose, CA, Bakersfield, CA, or Torrance, CA.

Essential Qualifications

• Support the roll out of project/portfolio management tools throughout the organization.

• Develop and maintain reporting tools (PowerBI and Excel) to show the overall California Water Service Group capital program and the individual health and status of portfolios, sub-portfolios and programs within the Group.

• Creating ad-hoc reports to address company needs for analysis of the current and future capital program 

• Support the California General Rate Case filing and data request development by developing new processes for organizing and extracting data related to the capital program

• Support the integration of data between various platforms (Powerplan, MSPO, Project for the Web, various cost estimating resources, PowerBI)

• Develop, assess, and review optimal information models, reporting applications, automation enhancements, dashboards, and performance metrics to support business decisions

• Optimize processes to ensure efficiency and data accuracy

• Liaison with other Cal Water business areas (such as Information Technology, Accounting, other Engineering Departments) on project management and accounting systems implementations and upgrades

• Plan and coordinate the work of consultants, application developers and other service providers

• Document processes and procedures for all of the above functions

• Develops and delivers training materials to internal project managers and report users

• Performs work on-site in the assigned office location

• Other duties may be assigned to fulfill business operational needs and objectives

Minimum Qualifications

• Bachelor’s degree in Engineering, Economics, Data Analytics, or related field and/or equivalent relevant experience

• Knowledge of water systems or construction projects, very desirable

• Project Management Experience

• Familiarity with Program Management concepts

• Ability to perform complex mathematical functions to calculate figures and analyze results

• Ability to collect, analyze, compile and interpret economic and technical data

• Ability to organize work to meet changing schedules and high-pressure situations

• Ability to use logical and creative thought processes to develop solutions according to written specifications and/or verbal instructions

• Ability to use initiative and independent judgement within established guidelines

• Understanding of and experience using analytical concepts and developing actionable recommendations

• Experience working with and creating databases and dashboards using relevant data to inform decisions

• Strong problem solving, quantitative, and analytical abilities

• Exceptional ability to communicate new information effectively, both verbally and in writing, in a tactful and persuasive manner

• Excellent interpersonal skills, enthusiasm, and commitment to outstanding customer service

• Experience with Microsoft Project, PowerPlan, Sage or PowerBI, very desirable

• Must be highly proficient in personal computer skills including Excel, database management, and Office 365

• Valid California Driver License

Salary Range: $66,900 - $142,800

Deadline to submit resume is Monday, January 13, 2025

The Equal Opportunity Policy of the Company is based upon the philosophy that all people should be treated fairly and with dignity. California Water Service, Hawaii Water Service, New Mexico Water Service and Washington Water Service do not discriminate against any applicant or employee because of race, color, religion, sex, national origin, or any other protected class. The Company makes all employment decisions in a non-discriminatory manner. EOE, VET, DISABILITIES.