Search Jobs

To perform a variety of semi-skilled and skilled tasks in the construction, maintenance, and repair of water lines, sewers, storm drains, and pump stations.  The purpose of this recruitment is to fill multiple vacancies in the Sanitary Sewer/Storm Drainage Systems Division, as well as establish an eligibility list for future vacancies.  Initial position and salary of the selected candidate will be based on previous work experience and valid licenses/certificates. 

IDEAL CANDIDATE

The City of Woodland is looking to fill multiple Utilities Maintenance Worker I/II positions in the Public Works Sanitary Sewer/Storm Drainage Systems Division.  The Ideal Candidate for the current vacancy is someone who has a good understanding of all aspects of underground sewer/stormwater maintenance and repairs, and is familiar with the operation of light and heavy equipment.  This position requires a “team player” with good interpersonal, time management, and communication skills.  Candidate must be able to follow direction and display good judgment, as well as be organized, flexible, approachable, resourceful, and a positive team contributor.  Current and valid collections certifications and Class A/B commercial driver’s license are a plus.

Utilities Maintenance Worker I: This is the entry level class in the Utilities Maintenance Worker series. The Utilities Maintenance Worker I may often perform many of the duties required of Utilities Maintenance Workers II but is not expected to have the depth of experience, skill level and certifications of the Utilities Maintenance Worker II. As a result, the Utilities Maintenance Worker I will have fewer opportunities to exercise independent discretion and judgment on matters related to work procedures and methods.

Utilities Maintenance Worker II: This is the Journey level in the Utilities Maintenance Worker series. This class differs from Utilities Maintenance Worker I in that incumbents perform more complex maintenance duties including working independently, exercising judgment, and operating the full range of tools and mechanical equipment related to a specific assignment. The Utilities Maintenance Worker II may also be expected to assist in the oversight and training of less experienced personnel. Positions in this class are flexibly staffed and are normally filled by advancement from the I level, or by candidates with prior work experience elsewhere.

ESSENTIAL JOB FUNCTIONS

Operate a variety of light and moderately heavy construction and maintenance equipment including such pieces as a loader, dump truck, water truck, steel rollers, High Velocity Vacuum Cleaner, mole trencher, and rubber-tired tractor with all attachments in order to perform a variety of routine construction and maintenance operations. Operate fork lift as assigned and trained. Perform general maintenance and repair on storm and wastewater collection facilities including installation, testing, and backfill of service laterals. Within the sewer and stormwater collections division, employees will be expected to use the Closed Circuit Television Truck, sewer cable machine, flush sewer laterals and mains, assist in sewer tap installations, clean storm drain lines and catch basins.  All Utilities Maintenance Worker I/II will operate equipment and vehicles with possession of all necessary licenses and certificates, utilize proper safety precautions related to all performed work and comply with the policies and procedures in the department Injury & Illness Prevention Program (IIPP). Regular, predictable, consistent and timely attendance is an essential function of the position, in that employee must be present to work on facilities and equipment impacting the public’s health and safety.

OTHER JOB FUNCTIONS

Respond to inquires from the general public. Prepare as built sketches, when required to convey information to engineering for graphic documentation. Check water meters for proper operation; troubleshoot registers and repair. Initiate and discontinue water service to customer accounts as directed. Operate telemetering and flow monitoring equipment. Work cooperatively with others. Perform related duties as assigned. Both Assignments will require employees to be “On Call” as needed.

QUALIFICATIONS

Utilities Maintenance Worker I:

Education: High School Diploma or equivalent.  Courses in, or graduation from, the American Public Works Association’s Public Works Institute is desirable.

Experience: One (1) year of experience in construction or related field.

License and Certificate:  Requires possession of a California State Drinking Water Operator Certification Program (DWOCP) Grade I Water Distribution Operator (D1) and a Grade I Wastewater Collections System Maintenance certificate issued by California Water Environment Association prior to permanent appointment. A Pipeline Assessment and Certification Program certificate issued by the National Association of Sewer System Companies (NASSCO) is desirable.  Requires possession of a valid California Driver's License. A Class B Driver’s permit and DMV Medical Certification are required within three (3) months of hire. Employee must obtain a valid Class B Driver's License, a Work Zone Safety certification issued by the International Municipal Signal Association, First Aid and CPR certifications, Competent Person certification, and Confined Space certification prior to permanent appointment.

Utilities Maintenance Worker II:

Education: High School Diploma or equivalent.  Courses in, or graduation from, the American Public Works Association’s Public Works Institute is desirable

Experience: One (1) year of experience performing duties comparable to those of a Utilities Maintenance Worker I.

License and Certificate: Requires possession of a California State (DWOCP) Grade I Water Distribution Operator (D1) and a Grade II Wastewater Collections System Maintenance certificate issued by California Water Environment Association upon hire. Requires all of the certifications necessary for a Utilities Maintenance Worker I and possession of a valid Class B California Driver's License with Tank and Air Brake Endorsement upon hire.

APPLICATION

Apply with a City of Woodland application by visiting www.cityofwoodland.org/employment or the Human Resources Office, City Hall, 300 First Street, 2nd Floor, Woodland, CA 95695 by 5:00 p.m., Monday, August 24, 2020.  Supplemental questionnaire must be submitted with application by the final filing date to be considered.  Résumés and cover letters are encouraged but will not be accepted in lieu of the application form. Postmarks will not be accepted. 

Review Process:  Based on the information provided in the application documents, the best qualified applicants will be invited for further examination.  All applicants meeting the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination.  Depending upon the number of applications received, the examination may consist of an application screening, written and/or practical exam, oral interview or any combination thereof.  If you have a disability that requires accommodation during the selection process, please notify Human Resources at least seven days prior to the event.

Panel Interviews and/or examination tentatively scheduled for September 3, 2020.

BENEFITS

Salary (Current):                 
Utilities Maintenance Worker I  $3,486.48 - $4,449.72 per month
Utilities Maintenance Worker II $3,944.63 - $5,034.45 per month

Retirement:                          
CalPERS Retirement System (2 % @ 60 formula for Classic CalPERS members and 2% @ 62 formula for new CalPERS members).  The City does not participate in social security

Deferred Compensation:                   
Choice of deferred compensation plans (Traditional and Roth options)

Medical:                                 
CalPERS Medical Insurance Plans, including HMOs and PPOs.  City gives an allowance toward the cost of insurance.  Maximum Family Medical Allowance (2020): $2,128.49 per month

Dental/Vision:                      
City paid Delta Dental and Medical Eye Services

LTD/STD:                              
City paid wage protection for long/short term disabilities

Life Insurance:                    
City provides $50,000 life insurance policy

Supplemental Benefits:     
Voluntary Supplemental Life, Cancer, Accident Only and Critical Illness insurance, and Flexible Spending Accounts available

Vacation:                              
6.7 hours per month during first three years of service

Holidays:                              
12.5 paid holidays (including two floating holidays)

Sick Leave:                          
8 hours per month

Bilingual Pay:                      
$200 per month upon certification

Professional Growth:          
$625 per fiscal year for education or professional activities

The City of Woodland hires only U.S. citizens and aliens lawfully authorized to work in the U.S.
The City of Woodland is an Equal Opportunity Employer

The City of Sunnyvale is seeking a modern, skilled communicator, and highly motivated problem solver for the position of Principal Transportation Engineer/Planner.  This management position reports directly to the Transportation and Traffic Manager in the Public Works Department and will be responsible for:  assisting with planning, organizing and coordinating the activities of the Division of Transportation and Traffic; and perform professional traffic engineering, transportation planning, designing, and project management.

This position will supervise a small team within the Division to accomplish specific tasks and high-level, community-oriented projects. Current projects include: Mary Avenue Overcrossing over highways 101 and 237; Bernardo Avenue railroad undercrossing; Sunnyvale Avenue and Mary Avenue railroad grade separations, liaison with the County for the Lawrence Grade Separation project; Stevens Creek Bike and Ped Trail within Sunnyvale; and coordinating with VTA as part of the delivering Measure B transportation projects. The position will manage multiple consultant contracts and will be expected to coordinate and work closely with other staff within the Division and with staff within other departments such as Public Works, Community Development, Environmental Services, and Public Safety, and represent the City with outside agencies such as the Valley Transportation Authority, Caltrain, High Speed Rail, Caltrans, MTC, County of Santa Clara, and adjacent cities.
 
The position will focus on completing the projects mentioned above, assist with oversight of the design and traffic signal operations, implementation of Intelligent Transportation Systems (ITS); assist with the coordination of Division of Transportation and Traffic activities with other divisions and departments; assist with planning and coordinating division workload and budgets; creating and sustaining cooperative and collaborative working relationships across the City, with the development community, and residents; attend and present at public meetings/City Commissions; and provide assistance with highly complex traffic engineering work. We therefore, are looking for a candidate with strong analytical, technical and problem solving skills, who can prioritize and deliver results in a constantly changing environment, effectively communicate, and has the proven ability to establish effective working relationships with customers, co-workers, and vendors.

The Principal Transportation Engineer requires a Bachelor's degree from an accredited college or university in engineering, planning, public administration or a related field; AND Four years of responsible transportation planning, transportation engineering or planning management experience, including two years of supervisory experience.

Possession and continued maintenance of a valid class C California driver's license or the ability to provide alternative transportation as approved by the appointing authority and a safe driving record.

Principal Transportation Engineer

• Possession of Registration as a Professional Civil or Traffic Engineer issued by the State of California.

Principal Transportation Planner

• AICP Certification issued by the American Planning Association OR
• Professional Transportation Planner certification issued by the Institute of Transportation Engineers.

The City of Sunnyvale provides an excellent benefits package. A complete application consists of a City application and responses to the required supplemental questions. The final filing date is September 10, 2020 at 5:00 pm. For complete information regarding this current opportunity, please visit: Sunnyvale.ca.gov and search Jobs.

“This is a continuous recruitment which can be closed at any time without notice.”

The City of Chowchilla is seeking a Transit Driver I / Dispatcher, 

Candidate must have basic arithmetic skills, speak both English and basic Spanish and have general office procedures knowledge .

The preferred candidate will have a proficient knowledge of the geographical layout of the City of Chowchilla including major streets, public places and landmarks, and general locations within the City’s Sphere of Influence and be capable of  maintaining a mental image of the location of all in-service transit vehicles. The candidate must have knowledge of telephone and two-way radio operations and procedures; must know provisions of the California Motor Vehicle Code that are applicable to the operations of passenger-carrying vehicles; possess safe driving practice; and possess a basic first aid certification. 

Candidate must be able to drive a passenger-carrying bus safely and efficiently; understand and carry out verbal and written instructions; maintain accurate records; think clearly and quickly; be able to use dispatching software and establish and maintain cooperative working relations with City staff, senior citizens, adults, children and persons with disabilities; be able to read and write competently ; speak and communicate effectively in both English and basic Spanish.

The candidate may be exposed to heat, cold, fog and rain, sneezing and coughing passengers, passengers experiencing motion sickness, caustic and corrosive chemicals, and instances to assist persons with a disability. Candidate will be required to maintain the interior and exterior of transit vehicles. 

FINAL FILING DATE:                        Open Until Filled.  First cut-off is 5:00 pm on August 10, 2020.

Following the first cut-off date, resumes/applications will be screened according to the qualifications outlined below. The most qualified candidates will be invited to interviews on a date to be determined.

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 Technology Systems Technician in the Electric Department.  The normal work schedule is Monday through Friday, 8:00 am –5:00 pm; a flex schedule may be available.

The City of Roseville promotes a no smoking atmosphere.

THE CITY

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 responsible technical duties in support of electric utility computer operational and control systems, including Supervisory Control and Data Acquisition (SCADA) and Distributed Control System (DCS); and to analyze, design, program, test, install, and maintain a variety of electric utility computer systems.

SUPERVISION RECEIVED AND EXERCISED

Receives general supervision from the Electric Technology System Supervisor.

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

• Perform technical duties in support of electric utility Supervisory Control and Data Acquisition (SCADA) and Distributed Control System (DCS) system software and hardware, including system maintenance and programming.
• Test, implement, and maintain computer applications and systems related to the electric utility infrastructure systems, including asset/work order, outage tracking, training modules and related work management applications.
• Maintain the integrity of electric computer security systems; create and maintain user identification, authorizations, system privileges, passwords and perform related tasks.
• Train users in various system applications and respond to requests for service related to problems/questions; monitor logs and files for possible problems and system failures and take corrective action.
• Conduct scheduled backup and recovery activities, expediting when appropriate; trouble shoot problems on a system-wide basis; work with vendors and management staff in making changes of a system-wide nature.
• Develop and implement operational procedures for electric computer hardware and software including network infrastructure to be in compliance with North American Electric Reliability Corporation (NERC) standards.
• Maintain communication links with outside agencies and contractors.
• 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:

• Principles and practices of utility computer systems operations and technical support activities.
• Supervisory Control and Data Acquisition (SCADA) system architecture, security standards and recovery procedures.
• Distributed Control System (DCS) system architecture, security standards and recovery procedures.
• Electric utility network operating systems and protocols.
• Local Area Networks, and Windows operating systems.
• NERC security procedures for electric computer systems.
• Pertinent local, State and Federal laws, ordinances and rules.

Ability to:

• Perform technical support such as network maintenance and system backup and recovery of electric utility computer operational and control systems, including Supervisory Control and Data Acquisition (SCADA) and Distributed Control System (DCS).
• 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 bend or stoop to install/repair equipment; 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 25 pounds or less. 
• Troubleshoot computer system application programming problems at a broad level.
• Develop and maintain documentation of SCADA/DCS servers, network and applications.
• Train or instruct on-line users in use of computer equipment and operating procedures.
• 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:

Two years of responsible technical experience providing utility computer systems support work, preferably in SCADA (Supervisory Control and Data Acquisition) or DCS (Distributed Control System).

AND

Training:

An Associate’s degree or 60 semester units of college level course work including 18 units in a major field of study and 21 units in general education from an accredited college or university, preferably in computer science, engineering, electronics, or a related field. Two years of additional related work experience can substitute for an Associate’s Degree.

License or Certificate:

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

SUPPLEMENTAL QUESTIONNAIRE

1. Your responses to questions 2-4, 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

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

3. How many years of responsible technical experience do you have providing utility computer systems support work?

• Less than 2 years
• 2-5 Years
• 5-10 Years
• 10+ Years

4. Describe your work experience with supporting utility specific technologies such as Supervisory Control and Data Acquisition (SCADA), Control System Networks, or Real-time applications.

5. List new technology deployment projects you involved recently including systems, applications, and your roles.

6. Provide a work example of implementing technical controls in order to meet regulatory or cyber security requirements. What are some unique challenges?

7. What would be your ideal working environment?

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.

FINAL FILING DATE: We are accepting applications until closing at 5 pm, August 25, 2020.

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 Plant and Equipment Maintenance Worker II in the Environmental Utilities Department.  The normal work schedule is a 9/80 schedule from 6:30 am to 4:00 pm (6:30 am to 3:00 pm on the one 8 hour day worked bi-weekly).

The City of Roseville promotes a no smoking atmosphere.

THE CITY

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 a variety of manual labor and semi-skilled tasks in the construction, maintenance, and repair of water and wastewater treatment plants and related system facilities and equipment.

DISTINGUISHING CHARACTERISTICS

This is the journey level class in the Plant and Equipment Maintenance Worker series and is distinguished from the I level by the ability to perform the full range of duties assigned with only occasional instruction or assistance as unusual or unique situations arise. Positions in this class are flexibly staffed and are normally filled by advancement from the I level.

SUPERVISION RECEIVED AND EXERCISED

Receives general supervision from an assigned supervisor; and technical and functional supervision from a Senior Plant and Equipment Mechanic.

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

• Inspect and perform routine maintenance on machinery and equipment such as pumps, valves, motors, engines, compressors, and generators.
• Lubricate equipment and take oil samples for review and analysis.
• Perform routine building maintenance duties such as cleaning and painting of utility facilities and upkeep of work areas.
• Assist in construction and repair of tanks and pump houses and other special projects, working from blue prints and sketches.
• Dig trenches, install shoring, set up concrete forms as necessary, and backfill open trenches, completing surfaces “to-finish” as appropriate.
• Follow lock out/tag out procedures before engaging in work, especially in confined space areas; make notes regarding readings and findings of work.
• Operate and perform routine maintenance on a variety of heavy tools and equipment, and small hand and power tools used in the work.
• May use a computer to enter and retrieve information related to work assignments, record-keeping and timekeeping.
• 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:

• Uses and purposes of tools and equipment used in general construction and mechanical equipment maintenance and repair; safe work practices.
• Basic principles of mechanical systems maintenance and repair, especially as related to an industrial continuous process environment such as water or wastewater treatment plants and associated facilities.

Ability to:

• Learn to perform unskilled and semi-skilled tasks in a variety of utility construction and maintenance activities.
• Work in small confined spaces and at heights exceeding thirty feet.
• On a continuous basis, know and understand operations, and observe safety rules.  Intermittently analyze problem equipment; identify and locate equipment; interpret work orders; remember equipment location; and explain jobs to others.
• Intermittently, sit while studying or preparing reports; bend, squat, climb, kneel and twist when performing installation of equipment; perform simple and power grasping, pushing, pulling, and fine manipulation; and lift or carry weight of 50 pounds or less.
• Communicate clearly and concisely, both orally and in writing.
• Be on-call evenings or week-ends; work unusual/prolonged work schedules during emergencies or seasonally-caused circumstances.
• Establish and maintain effective working relationships with those contacted in the course of work.
• Independently perform routine semi-skilled work in the construction, maintenance, and repair of water and wastewater systems facilities.
• Operate and perform routine maintenance on a variety of heavy tools and equipment, small hand and power tools.

Experience and Training

Experience:

• Two years of increasingly responsible experience performing maintenance work similar to that of a Plant and Equipment Maintenance Worker I with the City of Roseville.

Training:

• Equivalent to completion of the twelfth (12th) grade, GED, or higher level degree.

License or Certificate

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

SUPPLEMENTAL QUESTIONNAIRE

1. Your responses to questions 3-5, 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

2. Was any of the work experience listed on your application an unpaid internship, or volunteer work?  If so, please list below which ones.
3. How many years of experience do you have performing a variety of manual labor and semi-skilled tasks in the construction, maintenance, and repair of water and wastewater treatment plants and related system facilities and equipment?

• Less than 2 Years
• 2-3 Years
• 3-4 Years
• 4-5 Years
• 5-6 Years
• 6+ years

4. Please tell us your experience with mechanical systems maintenance and repair, especially as related to an industrial continuous process environment such as water or wastewater treatment plants and associated facilities?
5. Tell us your experience working in an environment that uses work orders to dictate your daily schedule.

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.

FINAL FILING DATE:                        Open Until Filled.  First cut-off is 5:00 pm on August 24, 2020.

Following the first cut-off date, resumes/applications will be screened according to the qualifications outlined below. The most qualified candidates will be invited to interviews on a date to still be determined.

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 Senior Electric Technology Systems Analyst in the Electric Department.  The normal work schedule is Monday through Friday, 8:00 am –5:00 pm; a flex schedule may be available.

The City of Roseville promotes a no smoking atmosphere.

THE CITY

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 organize, assign, and review the work of assigned personnel engaged in electric operational technology systems, including analysis, design, implementation, and maintenance of electric utility real-time control systems within the Electric Department; and to perform a variety of technical tasks relative to assigned area of responsibility.

SUPERVISION RECEIVED AND EXERCISED

• Receives general direction from the Electric Technology Systems Administrator.
• Exercises direct supervision over assigned professional and technical personnel.

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

• Recommend and assist in the implementation of goals and objectives; establish schedules and methods for electric utility operational technology systems; implement policies and procedures.
• Plan, prioritize, assign, supervise and review the work of staff involved in the installation, configuration, and maintenance of operational technology systems and applications, including but not limited to the Supervisory Control and Data Acquisition (SCADA) System, Outage Management Systems (OMS), Generation Turbine Control Systems, and Generation Distributed Control System (DCS),.
• Oversee the design and implementation of operational technology systems architecture to ensure system reliability and availability, including system redundancies, backup and recovery plans, and access controls.
• Design and implement system communication networks and related telemetry settings, such as communications between SCADA master stations and substation field devices.
• Analyze and support real-time data acquisition technologies, such as distribution and generation control system software, OSISoft PI and other control system historian applications.
• Manage technology infrastructure for real-time data exchange with other entities such as Balancing Authority of Northern California (BANC) and Western Area Power Administration (WAPA).
• Design and manage real-time control system interfaces connecting with other electric operational systems and related enterprise systems.
• Evaluate operations and activities of assigned responsibilities; recommend improvements and modifications; prepare various reports on operations and activities.
• Participate in the selection of staff; provide or coordinate staff training; work with employees to correct deficiencies; implement discipline procedures.
• Establish and implement policies and system designs to be in compliance with cyber security standards of   the North American Electric Reliability Council (NERC) and industry best practices.
• Supervise hardware and software systems support for sophisticated training, asset and work order, outage tracking, and related work management applications; support and maintain operational technology systems at generation and distribution facilities including substations, dispatch center, power plants, warehouse and operation buildings.
• Build and maintain positive working relationships with co-workers, other City employee and the public using principles of good customer service.
• Perform related duties as assigned.

MINIMUM QUALIFICATIONS

Knowledge of:

• Principles and technical methodologies related to the development, design, implementation, analysis and maintenance of computer systems and applications related to operating and control systems in a utility environment.
• Principles of industry real-time control system architecture and security best practices.
• Principles of system redundancy and recovery technologies.
• Principle of operational technology system network design, development, and maintenance.
• Principles of computing technologies, such as Window Operating Systems,
• Familiar with industrial communication protocols such as DNP, Modbus, TCP/IP and ICCP.
• Regulatory requirements of the North American Electric Reliability Council (NERC).
• Principles of supervision, training and performance evaluations.
• Principles of budget monitoring.
• Principles and practices of safety management.
• Pertinent local, State and Federal laws, ordinances and rules.
• Principles and practices of project management.

Ability to:

• Organize, implement and direct electric utility computer systems operations.
• 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.
• Interpret and explain pertinent electric utility support practices and City and department policies and procedures.
• Assist in the development and monitoring of an assigned program budget.
• Develop and recommend policies and procedures related to assigned operations.
• Supervise, train and evaluate assigned staff.
• Provide technical assistance in resolving difficult electric utility computer systems and applications issues.
• Effectively manage complex projects.
• 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:

Three years of performing professional duties related to electric systems operations, including analysis, design, implementation, and maintenance of electric utility computer based systems.

OR

Three years of increasingly responsible experience providing support to electric utility operating and control computer systems similar to the responsibilities of an Electric Technology Systems Technician with the City of Roseville (performing responsible technical duties in support of electric utility computer operational and control systems, including Supervisory Control and Data Acquisition (SCADA) and Distributed Control System (DCS); and analyzing, designing, programing, testing, installing, and maintaining a variety of electric utility computer systems).

AND

Training:

A Bachelor’s degree from an accredited college or university, preferably with course work in computer science, information systems, engineering, or a related field.

License or Certificate:

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

SUPPLEMENTAL QUESTIONNAIRE

1. Your responses to questions 2-4, 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

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

3. How many years of electric utility operating and control system support experience do you have?

• Less than 3 years
• 3-5 Years
• 5+ Years

4. Do you possess a GICSP (Global Industrial Control Security Professional) or CSSA (Certified SCADA Security Architect) certification? If yes, please attach a copy in the space provided.

• Yes
• No

5. Please describe, in detail, your electric utility control system support and management experience. If you do not have any work experience in this area, please put N/A. 

6. Please describe the projects you have been involved in for developing and implementing regulatory compliance and cyber security for electric utility control systems.

7. Please provide examples of technical leadership you exercised with the staff you worked with.

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.

FINAL FILING DATE:                        We are accepting applications until closing at 5:00 pm, August 21, 2020

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 Data Management Specialist II in the Electric Department. The current vacancy is in the Finance Division of the Electric Department and will primarily support electric utility financial and operational reporting. The normal work schedule is Monday through Friday, 8:00 am –5:00 pm; a flex schedule may be available. The current vacancy is in the Electric department which does not specifically desire experience in a 24 hour industrial process environment.

The City of Roseville promotes a no smoking atmosphere.

THE CITY

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 technical and professional duties involving the analysis, design, development, programming, and maintenance of information systems related to the operations of an assigned department, including but not limited to, water and wastewater treatment or electric energy management, distribution, and generation processes and facilities; and to provide information technology support related to department specific operations and systems.

DISTINGUISHING CHARACTERISTICS

This is the journey level class within the Data Management Specialist 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

• Receives direction from an assigned supervisor.
• May exercise technical supervision over clerical, maintenance and/or technical staff as assigned.

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

• Implement and maintain electronic data management, collection/storage, and related systems in support of assigned department operations and processes.
• Design, develop, program, deploy, maintain and troubleshoot a variety of electronic databases related to department operations including large Relational Database Management Systems (RDBMS) such as Oracle, SQL Server, integrated development environments, Internet application server, and/or web host software.
• Develop, install and maintain Web-based applications.
• Perform daily data analysis; maintain data integrity and accuracy by running and analyzing various programs and reports; perform database backup and recovery operations; implement and test backup and recovery policy.
• Monitor and maintain security of database systems by writing procedures, functions and triggers to control the flow of data, monitoring logs and reviewing system access privileges, allocating disk space for users, creating and maintaining users, user permissions, system privileges, and passwords, and performing other administrative tasks at the operating system level.
• Perform database back-up and recovery operations; implement and test back-up and recovery policies and procedures.
• Design, develop, maintain and troubleshoot server management tools, Internet application servers, and forms, reports and report development suite in support of department operations, requirements, and staff needs.
• Set up and maintain logical storage, channels, virtual disks and partitions; create data files, tablespaces, tables and indexes as needed.
• Work with various internal users to develop programs that meet business needs; develop, test, review, and de-bug related prototypes; create documentation of final programs; develop and conduct end user training and program roll out.
• Provide system administration services; set up and install new servers and operations systems; install system upgrades and/or apply patches; hard code and/or implement programs in anticipation of upgrades.
• Design and develop forms and reports in support of department operations, requirements, and staff needs.
• Prepare periodically-required internal and external regulatory reports related to department operations.
• 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:

• Principles and practices of Oracle and SQL Server databases, Local Area Networks (LAN), Storage Area Networks (SAN), computer systems and related analysis.
• Principles and techniques of SQL, PL/SQL, and JAVA scripting, report writing, programming, electronic data processing and application documentation.
• Principles and practices related to the programming, maintenance, and use of computer systems and applications such as Oracle, Microsoft Word, Excel, Access, WHIMS and web development software.
• Basic principles and practices associated with the operations of assigned department systems and facilities.
• Pertinent local, State and Federal laws, ordinances/rules, and department procedures.

Ability to:

• Learn to perform technical duties in the analysis, design, and maintenance of information systems related to the processes and operations of the assigned department.
• On a continuous basis, know and understand operations, and observe safety rules; analyze problem equipment and/or procedures; know and apply techniques and terminology; communicate and explain test results to others.
• Intermittently, sit while studying or preparing reports; bend, squat, climb, kneel and twist when performing various field site sampling duties; perform simple and power grasping, pushing, pulling, and fine manipulation; use telephone, computer or communicate through written means; and lift or carry weight of 25 pounds or less.
• Learn to apply basic principles of business processes related to the assigned department’s operations and information management.
• Communicate clearly and concisely, both orally and in writing.
• Establish and maintain effective working relationships with those contacted in the course of work.
• Independently perform technical duties in the analysis, design, and maintenance of information systems related to the processes and operations of the assigned department.
• Apply basic principles of business processes related to the assigned department’s operations and information management.

Experience and Training

Experience:

Two years of professional experience performing duties similar to that of a Data Management Specialist I with the City of Roseville (performing technical and professional duties involving the analysis, design, development, programming, and maintenance of information systems related to the operations of an assigned department, including but not limited to, water and wastewater treatment or electric energy management, distribution, and generation processes and facilities; and to provide information technology support related to department specific operations and systems).

AND

Training:

A Bachelor’s degree from an accredited college or university, preferably with major course work in computer science, information systems or a related field.

License or Certificate

• Possession of a valid California driver’s license by date of appointment.
• Possession of a Database Administrator (DBA) certificate is desirable. 

SUPPLEMENTAL QUESTIONNAIRE

1. 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

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

3. How many years do you have of professional experience performing duties similar to that of a Data Management Specialist I with the City of Roseville (performing technical and professional duties involving the analysis, design, development, programming, and maintenance of information systems related to the operations of an assigned department, including but not limited to, water and wastewater treatment or electric energy management, distribution, and generation processes and facilities; and to provide information technology support related to department specific operations and systems.)?

• Less than 2 years
• 2-3 Years
• 3-5 Years
• 5+ Years

4. How many years of work experience do you have with Data Visualization software?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

5. How many years of work experience do you have in Programming Languages?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

6. How many years of work experience do you have in Structured Query Language?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

7. What knowledge and/or experience do you have designing and managing large databases and reporting using MS Excel, SQL, JAVA, or any cloud based application development, etc.?

8. Please describe your experience with functional, integration, and end-to-end user testing.

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.

SALARY:                                              $5,180 to $7,289 monthly (26 pay periods annually)

FINAL FILING DATE:                        We are accepting applications until closing at 5:00 pm, August 21, 2020

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 Data Management Specialist I in the Electric Department. The current vacancy is in the Finance Division of the Electric Department and will primarily support electric utility financial and operational reporting. The normal work schedule is Monday through Friday, 8:00 am –5:00 pm; a flex schedule may be available. The current vacancy is in the Electric department which does not specifically desire experience in a 24 hour industrial process environment.

The City of Roseville promotes a no smoking atmosphere.

THE CITY

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 technical and professional duties involving the analysis, design, development, programming, and maintenance of information systems related to the operations of an assigned department, including but not limited to, water and wastewater treatment or electric energy management, distribution, and generation processes and facilities; and to provide information technology support related to department specific operations and systems.

DISTINGUISHING CHARACTERISTICS

This is the entry level in the Data Management Specialist series. This class is distinguished from the journey level by the performance of the more routine tasks and duties assigned to positions within the 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 an assigned supervisor.
• May exercise technical supervision over clerical, maintenance and/or technical staff as assigned.

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

• Implement and maintain electronic data management, collection/storage, and related systems in support of assigned department operations and processes.
• Design, develop, program, deploy, maintain and troubleshoot a variety of electronic databases related to department operations including large Relational Database Management Systems (RDBMS) such as Oracle, SQL Server, integrated development environments, Internet application server, and/or web host software.
• Develop, install and maintain Web-based applications.
• Perform daily data analysis; maintain data integrity and accuracy by running and analyzing various programs and reports; perform database backup and recovery operations; implement and test backup and recovery policy.
• Monitor and maintain security of database systems by writing procedures, functions and triggers to control the flow of data, monitoring logs and reviewing system access privileges, allocating disk space for users, creating and maintaining users, user permissions, system privileges, and passwords, and performing other administrative tasks at the operating system level.
• Perform database back-up and recovery operations; implement and test back-up and recovery policies and procedures.
• Design, develop, maintain and troubleshoot server management tools, Internet application servers, and forms, reports and report development suite in support of department operations, requirements, and staff needs.
• Set up and maintain logical storage, channels, virtual disks and partitions; create data files, tablespaces, tables and indexes as needed.
• Work with various internal users to develop programs that meet business needs; develop, test, review, and de-bug related prototypes; create documentation of final programs; develop and conduct end user training and program roll out.
• Provide system administration services; set up and install new servers and operations systems; install system upgrades and/or apply patches; hard code and/or implement programs in anticipation of upgrades.
• Design and develop forms and reports in support of department operations, requirements, and staff needs.
• Prepare periodically-required internal and external regulatory reports related to department operations.
• 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:

• Principles and practices of Oracle and SQL Server databases, Local Area Networks (LAN), Storage Area Networks (SAN), computer systems and related analysis.
• Principles and techniques of SQL, PL/SQL, and JAVA scripting, report writing, programming, electronic data processing and application documentation.
• Principles and practices related to the programming, maintenance, and use of computer systems and applications such as Oracle, Microsoft Word, Excel, Access, WHIMS and web development software.

Ability to:

• Learn to perform technical duties in the analysis, design, and maintenance of information systems related to the processes and operations of the assigned department.
• On a continuous basis, know and understand operations, and observe safety rules; analyze problem equipment and/or procedures; know and apply techniques and terminology; communicate and explain test results to others.
• Intermittently, sit while studying or preparing reports; bend, squat, climb, kneel and twist when performing various field site sampling duties; perform simple and power grasping, pushing, pulling, and fine manipulation; use telephone, computer or communicate through written means; and lift or carry weight of 25 pounds or less.
• Learn to apply basic principles of business processes related to the assigned department’s operations and information management.
• 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 in computer systems operations and programming related to the implementation or maintenance of large Relational Database Management Systems (RDBMS) such as Oracle servers and automated data systems and information management; experience in a 24 hour industrial process environment, such as water or wastewater treatment is desirable.

AND

Training:

A Bachelor’s degree from an accredited college or university, preferably with major course work in computer science, information systems or a related field.

License or Certificate

• Possession of a valid California driver’s license by date of appointment.
• Possession of a Database Administrator (DBA) certificate is desirable. 

SUPPLEMENTAL QUESTIONNAIRE

1. 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

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

3. How many years do you have of responsible experience in computer systems operations and programming related to the implementation or maintenance of large Relational Database Management Systems (RDBMS) such as Oracle servers and automated data systems and information management?

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

4. How many years of work experience do you have with Data Visualization software?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

5. How many years of work experience do you have in Programming Languages?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

6. How many years of work experience do you have in Structured Query Language?

• Less than 1 Year
• 1-3 Years
• 3-5 Years
• 5+ Years

7. What knowledge and/or experience do you have designing and managing large databases and reporting using MS Excel, SQL, JAVA, or any cloud based application development, etc.?

8. Please describe your experience with functional, integration, and end-to-end user testing.

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.

Administrative Services Manager

Utility Billing - Department of Finance

The City of Sunnyvale is seeking an energetic and motivated leader to join the City’s Utility Billing Division.  The Utility Billing Division is responsible for customer service, meter reading, billing, accounting, and auditing for the City’s three utilities (water, wastewater, garbage and recycling).  Utility Billing is also responsible for administering the City’s Business License, backflow compliance, and central cashiering functions.  The Administrative Services Manager will supervise customer service for the City’s cashiering, business license, and utility billing functions of the Finance Department.  This fast-paced position requires a professional with an outgoing personality to ensure a superior customer experience.  Experience managing a high-volume call center would be great but is not required.  Our office is open to the public Monday-Friday from 8:00am to 5:00pm.  Please be aware that remote work is not available for this position.

A complete application consists of a City application and supplemental questionnaire.  The final filing date is August 17, 2020 at 5:00 pm. For complete information regarding this current opportunity, please visit: www.sunnyvale.ca.gov            

Salary: $109,737.00 - $132,330.00 Annually

FINAL FILING DATE:                        We are accepting applications until closing at 5:00 pm, August 19, 2020

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 II in the Electric Department.  The current vacancy is in the Finance Division of the Electric Department and will primarily focus on electric utility finance, including but not limited to financial modeling, reporting, and debt management. The normal work schedule is Monday through Friday, 8:00 am –5:00 pm; a flex schedule may be available.

The City of Roseville promotes a no smoking atmosphere.

THE CITY

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 customers; to conduct financial and system data analysis; and to participate in the conduct of special studies in support of department business. 

DISTINGUISHING CHARACTERISTICS

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

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

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.
• 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.
• 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.
• 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

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.
• Sophisticated computer applications related to financial analysis, database management, and operational and forecast modeling 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:

• 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.
• Use complex mathematical, statistical and database models and standard computer applications; analyze large and complex sets of data.
• 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.
• 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:

Two years of responsible experience performing duties similar to an Electric Business Analyst I with the City of Roseville (performing complex professional analytical work in support of a variety of Electric Department projects and programs, in support of internal and external customers; conducting financial and system data analysis; and participating in the conduct of special studies in support of department business).

AND

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

1. Your responses to questions 2-4, 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

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

3. Do you possess a Certified Public Accountant (CPA), Certified Management Accountant (CMA), or Chartered Financial Analyst (CFA) certification? If yes, please attach a copy in the space provided.

• Yes
• No

4. How many years of experience do you have conducting complex analysis as it relates to the 5 year financial forecast or the accounting close?

• 2-5 Years
• 5+ Years

5. Please describe the key components of a financial forecast model and your experience in developing or supporting the forecast.

6. Please detail your experience in conducting complex data analysis as it relates utility rate making or load forecasting.

7. In the context of debt covenants, please discuss the importance of key financial metrics such DSCR and DCOH.

8. Please describe the key governmental financial statements and your experience with the month-end accounting close.

9. Please provide an example of a time you used a large data set and developed meaningful conclusions. Please include any programming language or analytics software you used such as SQL or SaaS.

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.