Electric Business Analyst I

Electric business analyst i

SALARY: $8,086.50 to $10,836.70 monthly (26 pay periods annually)

FINAL FILING DATE: We are accepting applications until closing at 5 pm, June 7, 2022

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 Regular and Full-time position of Electric Business Analyst I in the Electric Department. The normal work schedule is Monday through Friday, 8 –5 pm; a flex schedule may be available.

The City of Roseville promotes a no smoking atmosphere.

THE CITY

The City of Roseville is committed to a diverse workforce. We are engaged in understanding the needs and backgrounds of our colleagues and those we serve. Our organization is unified in this commitment, as we believe this produces the best results for our community

The City of Roseville (COR) incorporates the following Core Competencies as part of the City’s culture:

• Focus on people: Develop and deliver service-oriented solutions that meet or exceed expectations.
• Build trust: Ensure honesty and integrity to gain confidence and support of others.
• Ensure accountability: Take responsibility for the outcomes of one’s own work and foster a sense of ownership in others.
• Communicate effectively: Deliver clear, concise messages and actively listen to ideas and questions.
• Collaborate inclusively: Build effective working partnerships, alliances, and teams.
• Make quality decisions: Make sound, timely decisions and recommendations.
• Be adaptable/agile: Change approach or methods to best fit the situation and effectively balance competing priorities.

DEFINITION

To perform complex professional analytical work in support of a variety of Electric Department projects and programs, in support of internal and external programs; to conduct a variety of financial and statistical analysis including rate modeling and development, power supply forecasting, customer program research, power supply settlements and budgeting; and to participate in the conduct of special studies in support of department business.

DISTINGUISHING CHARACTERISTICS

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.

SUPERVISION RECEIVED AND EXERCISED

Receives general supervision from assigned supervisor.

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

• Perform cost of service analyses and rate design; develop and analyze retail rate options and provide support for rate case adjustments.
• Assist in the preparation, development, and administration of department or division operating, multi-year and/or capital improvement budgets; prepare revenue projections, conduct fee analyses and recommend strategies to meet budgetary needs.
• 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, transaction feasibility, power supply forecasting, market trends, operating costs, indirect costs, and capital improvement projects.
• 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.
• 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.
• Review, intervene and/or support intervention during the developing of legislation or regulations consistent with the interests of the City.
• Support energy transaction process; participate in the settlement process, verifying accuracy of data and ensuring payment to counterparties.
• Assist project management from inception to completion; plan, lead, organize, and control project deliverables, schedules, and budgets.
• Track, compile and analyze a wide variety of operational data; submit required regulatory compliance reports.
• Assist with the preparation of Requests for Proposals; participate in the selection and oversight of outside consultants; and administer contracts.
• Assist with training staff and consultants on Department policies and procedures.
• 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

Knowledge of:

• Quantitative analysis, including technical, statistical and financial analysis.
• Principles and practices of data management, including database and spreadsheet applications.
• Principles and practices of budget preparation, analysis and administration.
• 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 customer information 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.
• Learn applicable Federal, State and local laws, codes and regulations.
• 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 responsible experience performing duties similar an Associate Electric Analyst with the City of Roseville or one year of independent, journey-level experience performing professional duties that included energy analysis, business case analysis, financial analysis, econometric analysis, database management, or engineering analysis.

Training:

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

License or Certificate:

• Possession of a valid California driver’s license by date of appointment.

SUPPLEMENTAL QUESTIONNAIRE

• Your responses to questions 2-3, the applicant’s education, training and experience, will be scored using a pre-determined formula. Your responses to these questions must be consistent with your employment application information. This experience must also be described in the “Work Experience" section of this application. Responses to the supplemental questionnaire that are inconsistent from your “Work Experience” section in the application will not be scored. I understand and agree with the above instructions.

• Yes
• No

• Was any of the work experience listed on your application an unpaid internship, or volunteer work? If so, please list below which ones.

• How many years of experience do you have conducting professional analytical work in support of a variety of projects and programs, including financial, operational, and system data analysis?

• Less than 1 year
• 1-2 Years
• 2-3 Years
• 3+ Years

• Please describe your experience analyzing large data sets. Specify programing languages you are comfortable with and what type of data you have worked with in the past.

• Discuss the data challenges facing the electric utility industry. What do you see as the risks and benefits of interval billing data?

• What are the drivers of electric load shape for electric utilities over the next 25 years? What should utilities be doing to address these changes?

SELECTION PROCESS

All candidates meeting the minimum qualifications will have their application scored in a Formula Rate Examination. The applicant’s experience and education will be evaluated using a pre-determined formula. Scores from this evaluation will determine applicant ranking and placement on the Employment List. Supplemental questions will be utilized by the department hiring authority to make interview and selection determinations. Final appointment is contingent upon a check of past employment references, passing a City-paid fingerprint check and depending on position applied for a pre-employment medical exam and a drug and alcohol screening test.

THE CITY OF ROSEVILLE IS AN EQUAL OPPORTUNITY EMPLOYER. IF YOU REQUIRE AN ACCOMMODATION DUE TO A DISABILITY, PLEASE CONTACT THE HUMAN RESOURCES DEPARTMENT AT LEAST 5 WORKING DAYS BEFORE A SCHEDULED INTERVIEW/EXAMINATION PROCESS. MEDICAL DISABILITY VERIFICATION MAY BE REQUIRED PRIOR TO ACCOMMODATION.

For more information regarding the City's benefits, visit our website at here. This position is in Management.

The following options apply to the evaluation of college degrees from countries outside the United States:

• Educational background from a foreign country may be evaluated by an accredited United States college or university listed on the U.S. Department of Education Database of Accredited Post-Secondary Institutions and Programs website.
• Verification of degree equivalency may be obtained from organizations that provide foreign education credential evaluation services. The City of Roseville will accept verification from any of listed member agencies found at www.naces.org
• A copy of the foreign credential evaluation verification must be attached to the employment application.
• Applicants who do not provide this verification will be eliminated from further consideration.