Senior Analyst

Analyst role at a very stable company with an excellent quality of life. The position is responsible for creating complex financial models used in determining pricing based on various scenarios. In addition to Excel, a lot of the work will be writing out technical memos and presenting the models. The company is one of the few that still offer a pension and the work-life balance will be very close to 40 hours per week.

Responsibilities:

• Writes testimony and testify in formal hearings
• Performs complex analyses and studies regarding the company’s water supply, water use, cost-of-service, infrastructure financing, water rates, and other business, operational, or technical matters
• Writes formal applications and prepares testimony for rate cases and advice letter filings
• Performs primary statistical and analytical studies as it relates to monthly statistical revenues, sales, expenses, rate base reports and other financial data for its impact relative to the water rates
• Supports project teams on rate case filings
• Testifies as a witness in CPUC evidentiary hearings
• Participates in regulatory investigation and rule-making proceedings
• Provides training to company personnel regarding regulatory matters
• Represents the Regulatory Affairs Department in Inter-Company committees, task groups, etc.
• Interfaces with CPUC staff on a project
• Supports the Manager and other team members with long-range planning matters
• Develops and maintains spreadsheets, databases, and other computer tools to input and retrieve data, and to support a variety of business and operational needs
• Prepares routine and complex correspondence, reports and regulatory filings
• Prepares written reports for the Board of Directors and Officers of the Company
• Performs analysis and forecasting that may include access to employee data that is considered confidential, private and sensitive
• Responsible for maintaining internal controls in accordance with Sarbanes Oxley (SOX) and coordinating directly with internal and external auditors
• Performs other duties as assigned

Qualifications:

• Bachelor’s degree in accounting, mathematics, economics, business, engineering, environmental or resource planning, or a related discipline
• Five years of verifiable work experience in accounting or finance or utility regulatory analysis
• Demonstrated knowledge and experience in researching, analyzing and preparing statistical and analytical studies
• Excellent oral and written communication skills
• Ability to prepare statistical and analytical studies using spreadsheets and word processing software
• Proven ability of completing multiple project assignments
• Utility experience preferred
• Proficiency in Microsoft applications (advanced Excel skills preferred)
• Strong written and verbal communication skills
• Collaborative/Team oriented
• Organized with strong attention to detail and time management skills
• High degree of initiative; self-starter