CalOpps.org Logo
Learn more about CalOpps and working for a Government Agency Check out the public sector's best employment opportunities Get a complete listing of all CalOpps Member Agencies Start your one-on-one relationship with CalOpps today Frequently asked questions
View your Job Cart
placehoder
Section Title placeholder

Search Again
City of Roseville Logo

Electric Business Analyst I/II
(Rates and Financial Services)
City of Roseville, Sacramento/Metro Area

Finance

For more info contact:
humanresources@roseville.ca.us
(916) 774-5475
Close Date: Apr 3, 2013
Salary: $5,819.00 - $8,578.00 Monthly

Open/Promotional Exam: 12.077

Date Opened: 3/20/2013


ELECTRIC BUSINESS ANALYST I/II

(Rates and Financial Services)


Electric Business Analyst I: $5819 - $7798 MONTHLY (26 PAY PERIODS ANNUALLY)

Electric Business Analyst II: $6401 - $8578 MONTHLY (26 PAY PERIODS ANNUALLY)


FINAL FILING DATE: Accepting the first 50 qualified applications or closing at 5:00 pm, Wednesday, April 3 2013, WHICHEVER OCCURS FIRST.


TENTATIVE TEST DATE: Oral Interview Exam: Wednesday, April 17, 2013


IT IS MANDATORY THAT YOU COMPLETE THE SUPPLEMENTAL QUESTIONNAIRE. YOUR APPLICATION WILL BE REJECTED IF YOU DO NOT PROVIDE ALL NECESSARY INFORMATION.


THE POSITION

The Human Resources Department is accepting applications for the position of Electric Business Analyst I/II. The normal work schedule will be Monday through Friday, 8:00 a.m. to 5:00 p.m. A flex schedule may be available.


DEFINITION


To perform complex professional analytical work in support of a variety of Electric Department projects and programs, in support of internal and external customers; to conduct financial and system data analysis; and to participate in the conduct of special studies in support of department business.


DISTINGUISHING CHARACTERISTICS


Electric Business Analyst I - This is the entry level class in the Electric Business Analyst series. This class is distinguished from the journey level by the performance of the more routine tasks and duties assigned to positions within this series. Employees at this level are not expected to perform with the same independence of direction and judgment on matters allocated to the journey level. Since this class is typically used as a training class, employees may have only limited or no directly related work experience. Employees work under general supervision while learning job tasks.


Electric Business Analyst II - This is the journey level class in the Electric Business Analyst series and is distinguished from the I level by the assignment of the full range of duties. Employees at this level receive only occasional instruction or assistance as new, unusual or unique situations arise and are fully aware of the operating procedures and policies within the work unit. Positions in this class are flexibly staffed and are normally filled by advancement from the I level.


SUPERVISION RECEIVED AND EXERCISED


Electric Business Analyst I


• Receives general supervision from assigned supervisor; may receive technical and functional supervision from a Senior Electric Business Analyst II.


Electric Business Analyst II


• Receives direction from assigned supervisor; may receive technical and functional supervision from a Senior Electric Business Analyst II.


EXAMPLES OF ESSENTIAL DUTIES - Duties may include, but are not limited to, the following:


• Assist in budget preparation and data collection related to fixed assets and financial reports; document study methodologies for cost allocation; maintain the Department’s Federal Energy Regulatory Commission (FERC) accounting records; and verify data input regarding approved rate changes.


• Perform cost of service analyses and rate design; develop and analyze retail rate options and provide support for rate case adjustments.


• Forecast revenues and rate increases and analyze current and projected retail revenues; determine and recommend methods for collecting revenues from customers; prepare related reports for presentation to the Public Utilities Commission and to the City Council.


• Develop, update and run electronic models related to retail revenues, operating costs, indirect costs, and capital improvement projects.


• On an annual basis, research and create models for required long-term forecasting; research proposed development, historical data, state of the economy, vacancy rates, and the weather, customers, demographics, system usage, and customer usage patterns.


• Design, implement, modify, and manage complex databases used to input and extract data and prepare regular and custom reports; design, upgrade, and ensure successful migrations to and from various computer programs; update data and ensure maintenance of accurate data.


• Conduct market assessments, including evaluation of customer base and competitive forces in the market place, demand-side analysis and planning, power supply, risk assessment, and business planning.


• Perform analytical research to validate interval load and generator meter data received from multiple data sources.


• Ensure program compliance with Federal, State and local laws, rules and regulations.


• Provide day-to-day support to other divisions regarding rates, budgeting, accounting, and special studies.


• Intervene and/or support intervention during the developing of legislation or regulations consistent with the interests of the City.


• Assist project management from inception to completion; plan, lead, organize, and control project deliverables, schedules, and budgets.


• Participate in the selection and oversight of outside consultants.


• Build and maintain positive working relationships with co-workers, other City employees and the public using principles of good customer service.


• Perform related duties as assigned.


MINIMUM QUALIFICATIONS


Electric Business Analyst I


Knowledge of:


Quantitative analysis, including technical, statistical and financial analysis.


Principles and practices of data management, including database and spreadsheet applications.


Research techniques and documentation


Technical report writing procedures and techniques.


Ability to:


• Perform complex professional analytical work in support of a variety of Electric Department projects and programs, especially as related to financial services.


• On a continuous basis, know and understand all aspects of the job; intermittently analyze work papers, reports and special projects; identify and interpret technical and numerical information; observe and problem solve operational and technical policy and procedures.


• On a continuous basis, sit at desk for long periods of time; intermittently twist to reach equipment surrounding desk; perform simple grasping and fine manipulation; use telephone, and write or use a keyboard to communicate through written means; and lift or carry weight of 10 pounds or less.


• Learn to apply analytical and research methods to a variety of electric utility program areas including utility planning, forecasting, load research, financial planning, electric rate design, utility demand, and demand-side management.


• Learn to manage a project from inception to completion.


• Use complex mathematical, statistical and database models and standard computer applications; analyze large and complex sets of data.


• Present complex and technical information in writing and orally to a wide variety of audiences.


• Communicate clearly and concisely, both orally and in writing.


• Establish and maintain effective working relationships with those contacted in the course of work.


Experience and Training


Experience:

One year of experience performing business case analysis, financial analysis, or econometric analysis.


AND


Training:

Equivalent to a Bachelor’s degree from an accredited college or university with major course work in business administration, public administration, accounting, computer science, economics, mathematics or a related field.


License and Certificate

Possession of, or ability to obtain, a valid California driver’s license.


Electric Business Analyst II


In addition to the qualifications for the Electric Business Analyst I


Knowledge of:


Sophisticated computer applications related to financial analysis, accounting systems, database management, and operational and forecast modeling, preferably as used in the electric utility industry.


Pertinent local, State and Federal laws, rules and regulations.


Project management methodologies.


Principles of economics, accounting, financial planning, utility cost of service, and energy industry fundamentals.


Ability to:


• Independently perform complex professional analytical work in support of a variety of Electric Department projects, programs and activities.


• Read and interpret formulas and results from electronic models and spreadsheets and draw logical conclusions.


• Interpret technical and analytical data of energy usage and electric demand, rates, revenues, and operating costs.


• Develop technical and financial models related to cost, rates, and revenues.


• Design, create and modify databases, and analyze large and complex sets of data.


Experience and Training


Experience:


Two years of responsible experience performing duties similar to an Electric Business Analyst I with the City of Roseville.


AND


Training:


Equivalent to a Bachelor’s degree from an accredited college or university with major course work in business administration, public administration, accounting, computer science, economics, mathematics or a related field.


License and Certificate


Possession of, or ability to obtain, a valid California driver’s license.




SELECTION PROCESS

Applications and responses to supplemental questionnaire will be screened to those most meeting the needs of the department. Those applicants may be invited to an oral interview exam (weighted 100%). Final appointment is contingent upon a check of past employment references, passing a City-paid pre-employment medical exam, a drug and alcohol screening test, and a fingerprint check.


 


SUPPLEMENTAL QUESTIONNAIRE


It Is Mandatory That You Complete This Supplemental Application. Your application will be rejected if you do not provide all the necessary information.


1. How do you meet the minimum experience requirements for an Electric Business Analyst I or II?


2. Please describe your accounting background, including any experience with or knowledge of GASB accounting standards. What is your experience with or knowledge of FERC accounting standards that apply to municipal electric utilities?


3. Please describe your debt management related-background, including any experience working with bond rating agencies, financial advisors, bond counsel, etc. What can Roseville do to optimize its relationship with these partners? What can Roseville do to optimize its overall debt portfolio?


4. What are some of the opportunities, risks, and challenges in developing and managing financial systems, accounting processes, and internal controls in an organization like Roseville Electric?


5. Please describe your experience developing and managing operating and capital budgets, including the approximate size of budgets under your care. What techniques have you employed to reconcile discrepancies, manage ongoing budget changes, and ensure the proper use of public funds?


 

This job is closed

Supplemental Questionnaire Required
placeholder

placeholder
placeholder
agency info
placeholder
email a friend

print

placeholder
placeholder
Copyright ©2008 CalOpps. All rights reserved.Government Employment | Search Jobs | Member Agencies | Personal Profile | FAQ | Contact | Privacy | Login