Address
Form of workSalary : $88,800.00 - $111,000.00 Annually
Location : City of Pasadena, CA
Job Type: Full -Time
Job Number: 24-183
Department: Water & Power
Opening Date: 03/14/2024
Closing Date: 4/11/2024 11:59 PM Pacific
The City of Pasadena Water and Power Department (PWP) seeks a Financial/Rate Analyst with strong analytical skills and financial acumen to perform journey-level functions of a complex financial nature.
The successful candidate will assist in preparing and implementing short and long-term financial plans for the City's Water and Power Department; examine, develop and prepares financial and operational alternatives to existing and proposed utility conditions and projects; prepare and present highly technical and financial studies and analyses to a broad spectrum of audiences; and perform related work as assigned. The candidate must be proficient in using Microsoft Excel for various financial tasks and have the ability to create and manipulate financial models.
There are currently two vacancies in Finance and Administration Division in PWP.
Essential Functions
For more detailed information about the essential functions, please review the job description for :
1. Assists in the development of sound fiscal policies and long-range financial planning for the Water and Power department; assesses, evaluates, develops and improves short and long-term financial planning strategies including the preparation of plans leading to utility bond financing and issuance.
2. Plans, directs, organizes and implements research and data-gathering activities needed for the preparation of cost and delivery estimates, financial and strategy planning of utility service projects or assigned area(s) of responsibility.
3.Conducts varied and routine service and delivery studies for the determination of service and revenue requirements, rates structures, increases and timing, and other cost and operating elements and/or requirements; provides recommendations on the optimum course of action and alternate options.
4. Conducts varied routine financial and statistical analyses to include feasibility, performance and productivity; prepares funding and service proposals, council agendas, ordinance documents and an array of other financial reports.
5. Prepares or assists with the preparation and review of the department's capital and operational budgets; maintains monitoring activities and interfaces with accounting and other finance and department personnel on reported expenditures and encumbrances; reconciles the budget and maintains budgetary and accounting files and data.
6. Assists in preparing financial and cash flow forecasts for Water and Power funds and performs financial analysis; monitors financial results compared with budgets and prepares budget amendments; identifies significant issue and recommends corrective actions.
7. Performs various accounting tasks including financial reporting, accounts reconciliation, month/year-end close, cost accounting; reviews and prepares adjusting journal entry requests and other supporting documents; assists in development of financial policies and procedures.
8. Assists in the preparation of financial annual reports in compliance with standard accounting principles, Federal Energy Regulatory Commission, and California Public Utility Commission; prepares supporting documents for financial audits.
9. Conducts assigned department business with appropriate governmental entities, including state and local agencies.
10. May serve as consultant on other department/City projects or programs (for which the incumbent is not directly responsible) on aspects needing particular expertise (e.g. financial planning, accounting, forecasting, design, and/ or controls).
11. Performs related work as assigned.
12. Regular attendance is an essential function of this classification.
Qualification Guidelines
COMPETENCIES
The following list represents the core competencies needed for success in this position.
The selection process may consist of a training and experience evaluation, written test, interview panel, department-level interviews and possibly an online assessment.
Probationary work period is one year. This position is in the Pasadena Management Association bargaining unit.
VACANCY INFORMATION
There are currently two vacancies in the Finance and Administration Division of the Water and Power Department.
The resulting eligibility list from this recruitment may be used to fill these vacancies and similar vacancies in the future.
Effective January 1, 2013, new members to CalPERS or an agency with CALPERS' reciprocity or who have more than a six month break in service between employment in a CalPERS (or reciprocal) agency will be subject to the provisions of the Public Employees' Pension Reform Act of 2013 (PEPRA) and will receive the 2% @ 62 benefit formula.
Employees who are current members of CalPERS or an agency with CalPERS' reciprocity, or who have less than a six month break in service between employment in a CalPERS (or reciprocal) agency and employment with the City will be enrolled in the 2.5% @ 55 benefit formula.
All employees are required to pay the full employee contribution to CalPERS.
Click link below to review the City's excellent benefits package
The City is closed on alternate Fridays and most staff observe a 9/80 work schedule.
01
Please note: A resume may NOT be submitted in lieu of a completed employment application, and a "see resume" response is not acceptable. You may attach a copy of your resume, but your employment history and other qualifications will only be considered from your application. Check the "yes" box to acknowledge this. Yes
02
To further assist us with reviewing your qualifications, please answer the following questions. Please complete all sections of this form truthfully and completely. Your responses will be validated if you are considered one of the most qualified applicants. Please enter your initials to reflect that you have read and understood this statement:
03
Select the option that best describes the years of experience you have in utility accounting, economics and financial planning, forecasting and budgeting in a public utility organization or similar agency.
04
In 200 words or less, describe your work experience using Excel and Excel based models. Please provide examples of the specific work performed using Excel and any experience in developing worksheets/workbooks. If you do not have any experience in this area, please respond "no experience."
05
In 200 words or less, describe your experience with preparing year-end closing and/or performing cost of services analysis and rate design studies including revenue requirements and recommended rate adjustments in a utility environment. If you do not have any experience in this area, please respond "no experience."
06
In 200 words or less, describe your experience in developing operating and Capital Improvement Programs expenditure budgets and accompanying funding and implementation plans. If you do not have any experience in this area, please respond "no experience."
07
In 200 words or less, describe your involvement in assisting in the development of monitoring short-term and long- term financial plans, including the development of workbooks, policies, and presentations. If you do not have any experience in this area, please respond "no experience."
08
In 200 words or less, describe your involvement in preparation of annual budgets; monitoring and control of the budget; forecasting revenues and expenditures; researching variances. If you do not have any experience in this area, please respond "no experience."
Required Question
Location : City of Pasadena, CA
Job Type: Full -Time
Job Number: 24-183
Department: Water & Power
Opening Date: 03/14/2024
Closing Date: 4/11/2024 11:59 PM Pacific
The City of Pasadena Water and Power Department (PWP) seeks a Financial/Rate Analyst with strong analytical skills and financial acumen to perform journey-level functions of a complex financial nature.
The successful candidate will assist in preparing and implementing short and long-term financial plans for the City's Water and Power Department; examine, develop and prepares financial and operational alternatives to existing and proposed utility conditions and projects; prepare and present highly technical and financial studies and analyses to a broad spectrum of audiences; and perform related work as assigned. The candidate must be proficient in using Microsoft Excel for various financial tasks and have the ability to create and manipulate financial models.
There are currently two vacancies in Finance and Administration Division in PWP.
Essential Functions
For more detailed information about the essential functions, please review the job description for :
1. Assists in the development of sound fiscal policies and long-range financial planning for the Water and Power department; assesses, evaluates, develops and improves short and long-term financial planning strategies including the preparation of plans leading to utility bond financing and issuance.
2. Plans, directs, organizes and implements research and data-gathering activities needed for the preparation of cost and delivery estimates, financial and strategy planning of utility service projects or assigned area(s) of responsibility.
3.Conducts varied and routine service and delivery studies for the determination of service and revenue requirements, rates structures, increases and timing, and other cost and operating elements and/or requirements; provides recommendations on the optimum course of action and alternate options.
4. Conducts varied routine financial and statistical analyses to include feasibility, performance and productivity; prepares funding and service proposals, council agendas, ordinance documents and an array of other financial reports.
5. Prepares or assists with the preparation and review of the department's capital and operational budgets; maintains monitoring activities and interfaces with accounting and other finance and department personnel on reported expenditures and encumbrances; reconciles the budget and maintains budgetary and accounting files and data.
6. Assists in preparing financial and cash flow forecasts for Water and Power funds and performs financial analysis; monitors financial results compared with budgets and prepares budget amendments; identifies significant issue and recommends corrective actions.
7. Performs various accounting tasks including financial reporting, accounts reconciliation, month/year-end close, cost accounting; reviews and prepares adjusting journal entry requests and other supporting documents; assists in development of financial policies and procedures.
8. Assists in the preparation of financial annual reports in compliance with standard accounting principles, Federal Energy Regulatory Commission, and California Public Utility Commission; prepares supporting documents for financial audits.
9. Conducts assigned department business with appropriate governmental entities, including state and local agencies.
10. May serve as consultant on other department/City projects or programs (for which the incumbent is not directly responsible) on aspects needing particular expertise (e.g. financial planning, accounting, forecasting, design, and/ or controls).
11. Performs related work as assigned.
12. Regular attendance is an essential function of this classification.
Qualification Guidelines
COMPETENCIES
The following list represents the core competencies needed for success in this position.
- Professional & Technical Expertise - Applying technical subject matter to the job related to finance and accounting.
- Learning Agility - Seeking learning opportunities and applying the lessons to one's work.
- Adaptability - Responding positively to change and modifying behavior as the situation requires.
- Informing - Proactively obtaining and sharing information.
- Teamwork - Collaborating with others to achieve shared goals.
- Analyzing & Interpreting Data - Drawing meaning and conclusions from quantitative or qualitative data.
- Graduation from an accredited college or university with a specialization in economics, accounting, finance and/or business administration; and
- Two years of increasing experience in utility economics and financial planning, forecasting and budgeting in a public utility organization or similar agency.
- Experience has shown that individuals with a Bachelor's degree (Master's Degree preferred) in one of the aforementioned or a similar disciplines are most successful in this position.
- Experience in utility accounting preferred.
The selection process may consist of a training and experience evaluation, written test, interview panel, department-level interviews and possibly an online assessment.
Probationary work period is one year. This position is in the Pasadena Management Association bargaining unit.
VACANCY INFORMATION
There are currently two vacancies in the Finance and Administration Division of the Water and Power Department.
The resulting eligibility list from this recruitment may be used to fill these vacancies and similar vacancies in the future.
Effective January 1, 2013, new members to CalPERS or an agency with CALPERS' reciprocity or who have more than a six month break in service between employment in a CalPERS (or reciprocal) agency will be subject to the provisions of the Public Employees' Pension Reform Act of 2013 (PEPRA) and will receive the 2% @ 62 benefit formula.
Employees who are current members of CalPERS or an agency with CalPERS' reciprocity, or who have less than a six month break in service between employment in a CalPERS (or reciprocal) agency and employment with the City will be enrolled in the 2.5% @ 55 benefit formula.
All employees are required to pay the full employee contribution to CalPERS.
Click link below to review the City's excellent benefits package
The City is closed on alternate Fridays and most staff observe a 9/80 work schedule.
01
Please note: A resume may NOT be submitted in lieu of a completed employment application, and a "see resume" response is not acceptable. You may attach a copy of your resume, but your employment history and other qualifications will only be considered from your application. Check the "yes" box to acknowledge this. Yes
- Yes
- No
02
To further assist us with reviewing your qualifications, please answer the following questions. Please complete all sections of this form truthfully and completely. Your responses will be validated if you are considered one of the most qualified applicants. Please enter your initials to reflect that you have read and understood this statement:
03
Select the option that best describes the years of experience you have in utility accounting, economics and financial planning, forecasting and budgeting in a public utility organization or similar agency.
- No experience
- Less than 1 year
- 1-2 years
- 2-3 years
- More than 3 years
04
In 200 words or less, describe your work experience using Excel and Excel based models. Please provide examples of the specific work performed using Excel and any experience in developing worksheets/workbooks. If you do not have any experience in this area, please respond "no experience."
05
In 200 words or less, describe your experience with preparing year-end closing and/or performing cost of services analysis and rate design studies including revenue requirements and recommended rate adjustments in a utility environment. If you do not have any experience in this area, please respond "no experience."
06
In 200 words or less, describe your experience in developing operating and Capital Improvement Programs expenditure budgets and accompanying funding and implementation plans. If you do not have any experience in this area, please respond "no experience."
07
In 200 words or less, describe your involvement in assisting in the development of monitoring short-term and long- term financial plans, including the development of workbooks, policies, and presentations. If you do not have any experience in this area, please respond "no experience."
08
In 200 words or less, describe your involvement in preparation of annual budgets; monitoring and control of the budget; forecasting revenues and expenditures; researching variances. If you do not have any experience in this area, please respond "no experience."
Required Question
