Business Analyst

Full Time
United States
$90,934 - $110,531 a year
Posted Just posted
Job description
Description

Job descriptions are intended to present a broad and general range of duties which includes, purpose, responsibilities, and scope of work. Job descriptions are not intended to reflect all duties performed within the job.

DEFINITION
Performs highly complex, comprehensive analytical work in support of a variety of Electric Utility projects and programs, for both internal and external customers; conducts detailed financial and system data analysis; participates in special studies in support of Electric Utility business; exhibits excellent judgment and decision-making regarding policies and procedures; collaborates with management and co-workers in providing consultation services in areas of Electric Utility expertise; and other related duties, as required.

SUPERVISION EXERCISED AND RECEIVED
Receives general direction from higher level personnel.


Examples of Duties

Duties may include, but are not limited to the following:

Gather, compile, tabulate, analyze, and report statistical Electric Utility meter and customer billing/usage information for use by internal and external customers;

Perform quantitative analysis of customer load and generation data to validate data received from multiple sources, determine usage trends, and identify and resolve variances;

Work with metering and billing personnel, as needed, to calculate customer account corrections and backbills;

Review and confirm calculations associated with monthly large industrial bill batch processing and customer self-generation;

Perform the validation and auditing of customer rate class assignments and recommend re-assignment in accordance with approved rate tariffs;

Maintain current electric rates in the billing system in accordance with City Council approved changes, seasonal changes, and special tariff conditions;

Serve as subject matter expert for the City's metering systems, and work closely with Information Services and other personnel to identify, analyze, and resolve communication and data problems;

Serve as project manager to manage, implement, and maintain a Meter Data Management System;

Assist in budget forecasting/preparation and data collection related to fixed assets and financial reports;

Develop, update, and analyze, through electronic models, current and projected retail sales revenue, rate adjustments, operating costs, and capital improvement program activities;

Design, implement, modify, and manage databases used to input and extract data and prepare regular and/or custom reports;

Design, upgrade, and ensure successful migration to and from various computer programs; update data and ensure maintenance of accurate data;

Research and compile data related to other electric utility competitors and prepare related reports;

Assist with preparation and implementation of Electric Utility contracts;

Provide day-to-day support to other divisions regarding rates, data gathering and analysis, budgeting, and project management;

Participate in and/or manage special projects, as assigned;

Build and maintain positive professional working relationships with co-workers, other City employees, outside agencies, and the public using principles of good customer service; and

Performs other duties related to the operation of the department and the City including additional duties that enable the department and City to meet the diverse needs of its community.

Typical Qualifications

Knowledge of:
Quantitative analysis, including technical, statistical, and financial, as it relates to electric utility data;

Mathematics, statistical, financial and accounting methods for revenue, cost and rate analysis, and methods of graphic presentation;

Working knowledge of SQL and data management, including database and spreadsheet applications, with the ability to use complex models and specialized computer applications;

Research techniques and documentation methods;

Principles and practices associated with the collection of Electric Utility meter and customer data;

Principles and practices of budget and financial planning in addition to project development and management;

Technical report writing procedures and techniques;

Customer Information Systems (CIS), AS400, and other related software applications;

Applicable Federal, State, local laws, codes and regulations; and

Thorough knowledge specific to the area of assignment is required.

Ability to:
Plan, initiate, and complete work assignments with a minimum of direction; analyze administrative problems, evaluating alternatives, and make creative recommendations; assume control of a project and make sound recommendations; properly interpret and make decisions in accordance with laws, regulations and policies; prepare and write complete and accurate reports;

Perform complex professional and analytical work in support of a variety of Electric Utility projects and programs, especially as it relates to customer information services;

Identify and interpret technical and numerical information;

Observe and analyze problems; evaluate alternatives and make recommendations in accordance with regulations, operational and technical policies and procedures;

Create and use database models and computer applications to analyze large, complex sets of data;

Summarize and interpret large, complex sets of data, and prepare and present clear and concise reports;

Establish and maintain cooperative and effective relationships with those contacted during the course of work;

Operate a variety of office systems and equipment, including specialized computer applications;

Work with and control sensitive, confidential information;

Sit at a desk for long periods of time and travel to out-of-town meetings, occasionally with overnight stays; and

Communicate clearly and concisely, both orally and in writing, prepare and present oral and written reports.

EDUCATION AND EXPERIENCE:
Any combination of experience and education that would likely produce the qualifying knowledge and ability. A typical combination is:

Education:
Possession of a Bachelor's degree from an accredited college or university with major coursework in business administration, public administration, economics, engineering, computer science, mathematics, or a related field.

Experience:
Three (3) years of full-time professional work experience involving exposure to multiple facets of: electric utility rates and business practices; automated electric utility billing operation system and AMI/AMR which included technology systems coordination and working with databases, spreadsheets, and other software applications as it relates to data compilation and analysis for a public agency. Knowledge of Tyler/Munis, Electric Utility billing and metering is highly desirable.

LICENSES AND CERTIFICATES
Possession of a valid Class C Driver's License from the California Department of Motor Vehicles.

WORKING CONDITIONS
Environmental Conditions :
Work is generally performed in an office setting with frequent interruptions, multiple deadlines, and peak workload periods. Position may require working with the public and attendance at night and/or weekend meetings, and driving a motor vehicle. May be exposed to safety hazards including, fumes or odors, dust or gases, chemicals, toxic materials, oil, and a variety of mechanical machinery.

Physical Conditions :
Essential functions may require maintaining physical condition necessary to see well enough to read, write and make observations; hear well enough to converse on the radio, telephone and in person; bodily mobility to occasionally walk, bend, kneel, reach, stand, crouch or climb; operate assigned equipment and vehicles; operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; to verbally communicate to exchange information; and intermittently sit while preparing reports and operating vehicles and equipment.

  • FLSA Status: EXEMPT

Supplemental Information

Interested applicants must submit an online application at www.lodi.gov. No paper applications will be accepted. For technical difficulties with your online application, please call the Neogov helpline at 855-524-5627.


Telephone: 209-333-6704. Persons with hearing impairment, please call the California Relay Service 7-1-1.


Selection Process: Only the best qualified applicants will be invited to continue in the recruitment process.


EQUAL OPPORTUNITY EMPLOYER - The City of Lodi is an equal opportunity employer and is committed to a policy of fair employment practices regardless of race, color, ancestry, national origin, religion, sex or sexual orientation, marital status, age, mental or physical disability or perceived disability, medical condition, pregnancy, political affiliation or belief, or other unlawful discrimination.


AMERICANS WITH DISABILITY ACT - In compliance with the Americans with Disabilities Act and Section 504 of the Rehabilitation Act, the City of Lodi provides reasonable accommodation for qualified

individuals with disabilities. Individuals with disabilities requiring accommodations must contact the Human Resources Division upon application submittal to confirm the request.


CRIMINAL BACKGROUND INFORMATION - City of Lodi is authorized and required by the state of California to access Local, State, and/or Federal criminal history has part of the testing process. This process can be completed by initial fingerprinting and/or a full Background investigation pursuant to Penal Code §11105(b)(10), §11105.3, §13300(b)(10); Education Code §10911.5; Public Resources Code §5164) and in compliance with the City of Lodi's Fingerprinting Policy and Procedure. As a future employee or volunteer, you are required to be fingerprinted and processed through the Department of Justice and cleared before you can start. All information obtained will be kept in strict confidentiality.


HIRING PROCEDURE - Applicants must possess the minimum qualifications by the final filing date. Eligible lists are established upon successful completion of the selection process. The candidates must be successful in each part of the testing. To fill each vacancy the hiring department will request names to be certified from the eligible list and will make a selection from this certification list.


CONDITIONAL JOB OFFERS - Conditional job offers are subject to successful completion of a medical drug screen and/or physical. Candidates should not quit or give notice to their current employer until final notification has been awarded by the Human Resources Division.


MEDICAL-DRUG SCREENING – All positions may be subject to a physical or drug screen issued by a qualified medical physician assigned by the Human Resources Division. Under the requirements of the Drug Free Workplace Act of 1988, the City of Lodi has been designated as a drug-free workplace.


APPOINTMENT - At the time of appointment all candidates will be required to execute an oath of allegiance and complete Form I-9 - Employment Eligibility Verification in compliance with the Immigration and Naturalization Act. United States citizenship is not required. All new appointees are required to successfully complete a probationary period of twelve months.


EMPLOYMENT BENEFITS


SALARY - The starting salary is the first rate shown on the job announcement. Advancement to the higher steps of the salary range is based upon merit in accordance with the Salary Ordinance and Rules for Personnel Administration. Eligibility for the first merit increase is effective after 12 months and for additional merit increases after one year intervals until the employee has reached the maximum step.


HOLIDAY, VACATION, SICK, AND ADMINISTRATIVE LEAVE - Holiday - An average of 13 paid holidays per year. Vacation - 2 weeks paid vacation annually, increasing with length of service depending upon the appropriate labor agreement. Sick Leave - 10 days per year depending upon the appropriate labor agreement. Administrative Leave - Management/Mid-Management positions receive 80 hours per fiscal year, and specified professional/technical positions receive 40 hours per fiscal year (Pro-Rated).


HEALTH INSURANCE - Medical, Dental and Vision plans are available for employee and dependents. A portion of the premiums may be the employee's responsibility.


LIFE INSURANCE AND LONG TERM DISABILITY - The City pays the full premium for employee and dependent life insurance, and offers a long-term disability plan that provides up to approximately 2/3 of an employee's salary.


RETIREMENT AND DEFERRED COMPENSATION - The City of Lodi is a member of the Public Employees' Retirement System (P.E.R.S.). Lodi is not a member of the Social Security System except for the required medical contribution. Employees may participate in a 457 Deferred Compensation program.


FLEXIBLE SPENDING ACCOUNT - Employees may participate in a Section 125 Flexible Spending Account.


IMPORTANT NOTE: This bulletin does not constitute an expressed or implied contract. Any provisions or job duties contained in this bulletin may include modifications pending labor agreements and/or council approval.

gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.

Intrested in this job?

Related Jobs

All Related Listed jobs