Search Jobs

The City of Lincoln is hiring for the position of Account Clerk I in the Utility Billing Division of the Support Services Department.  This is a temporary, part-time position expected to work no more than 1000 hours per year. This position will work with residential and commercial customers to process new accounts, respond to inquiries and explain procedures, process payments regarding utility billing and business licenses; as well as be assigned to assist in processing water refunds.

 

DISTINGUISHING CHARACTERISTICS:

The Account Clerk I is the entry level in the Account Clerk series that allows the incumbent to develop journey level knowledge and abilities. Initially, under immediate supervision, incumbents perform the more routine accounting duties while learning City policies and procedures. As experience is gained, there is more diversity in assignments and greater independence of action within established guidelines. This classification is alternatively staffed with Account Clerk II and incumbents may advance to the higher level after gaining experience and demonstrating a level of proficiency that meets the qualifications of the higher level class.

 

SUPERVISION RECEIVED/EXERCISED:

Receives general supervision from the Customer Service Supervisor, Director of Support Services, or designee, depending upon area of assignment. Incumbents in this classification do not routinely exercise supervision.

 

ESSENTIAL FUNCTIONS: (include but are not limited to the following)

• Prepares and maintains a wide variety of complex financial records and information; utilizes automated financial systems and a variety of word processing and spreadsheet programs to enter, store and retrieve information; researches and gathers information from a variety of sources for the completion of forms or preparation of reports; provides information in person and over the phone to the public, other governmental agencies and city staff requiring the use of judgment and the interpretation of a variety of policies, rules and procedures.

• Maintains accounting records, reconciles transactions, processes, enters, and verifies numerical or financial data related to area of assignment; handles payments at the counter, provides receipts, and performs the full range of Account Clerk duties.

• Assists other accounting personnel in performing a wide variety of technical accounting duties in the preparation, maintenance and processing of accounting records and financial transactions including accounts payable, accounts receivable and utility billing.

• Processes City expenditures according to established policies and procedures; maintains vendor database and purchase order files; receives and verifies all invoices from vendors; responds to department and vendor questions and inquiries; researches and solves accounts payable issues.

• Processes and maintains customer utility billing for water, sewer and refuse for all residential and business/commercial customers; processes new customer applications for utility services; accepts payments for utility services, various licenses, permits and fees; explains utilities billing, business license procedures and other regulatory policies to customers; processes and updates billing charges to customer accounts; monitors and notifies customers of delinquent account status; research and solve billing inquiries and adjust accounts if necessary.

• Prepares periodic and special reports as required, performs special projects and studies; collects and compiles statistical and financial data for special reports.

• Establishes positive working relationships with representatives of community organizations, state/local agencies and associations, City management and staff, and the public.

   

  PHYSICAL, MENTAL AND ENVIRONMENTAL WORKING CONDITIONS:

  Position requires prolonged sitting, standing, walking, kneeling, squatting and stooping in the performance of daily activities. The position also requires repetitive hand movement, and fine coordination in data entry and preparing reports using a computer keyboard. Additionally, the position requires both near and far vision in reading written reports and work related documents. Acute hearing is required when providing phone and personal service. The need to lift, drag and push files, paper and documents weighing up to 25 pounds is also required.

FINAL FILING DATE: We are accepting the first 50 qualified applications or closing at 5 pm, November 2, 2018; whichever occurs first.

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 temporary and part-time position of Wastewater Treatment Plant Operator – Grade I in the Environmental Utilities Department. This position is limited to 1,500 hours per fiscal year.  The normal work schedule is Monday through Friday 6:00a.m. - 2:30p.m.

The City of Roseville promotes a no smoking atmosphere.

DEFINITION

To perform a variety of routine and skilled technical duties in the continuous operation of a wastewater treatment plant, on an assigned shift.

DISTINGUISHING CHARACTERISTICS

This is the trainee level class in the Wastewater Treatment Plant Operator series.  Positions in this class typically have little or no directly related work experience and work under immediate supervision while learning job tasks.  The Wastewater Treatment Plant Operator - Grade I class is distinguished from the Grade II level by performance of basic tasks and duties assigned to positions within the series that do not require possession of a Grade II Wastewater Treatment Plant Operator certificate.

SUERVISION RECEIVED AND EXERCISED

Receives immediate supervision from a Wastewater Treatment Plant Chief Operator; and may receive technical supervision from a Wastewater Treatment Plant Operator – Grade III.

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

• Operate SCADA (Supervisory Control and Data Acquisition) computer equipment to control and monitor flow of wastewater treatment and processing chemicals through the treatment plant and reclaimed water distribution system; monitor gauges and meters and record meter readings; maintain shift log.
• Observe variations in operating conditions; interpret computer, meter and gauge readings; check, standardize, and calibrate instruments, analyzers and chemical feed pumps; start and stop electric driven pumps and motors to control and adjust flow and treatment processes.
• Collect samples and perform routine laboratory tests and analysis; determine chemical and physical characteristics of raw, settled, filtered, and finished reclaimed water.
• Inspect mechanical equipment for proper working order and prepare/submit work orders for mechanic and/or electrical maintenance attention; perform routine maintenance work.
• Participate in preparation of reports to various external regulatory agencies, as well internal divisions and department; and participate in preparing costs estimates related to budget recommendations.
• Maintain records and documentation; respond to customer questions and complaints; and assist in oversight and training of less experienced wastewater treatment operators.
• 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:

• Basic mechanical, electrical, and hydraulic principles, including tools needed in making general repairs and adjustments to motors and pumps.
• Arithmetic calculations.

Ability to:

• Learn practices and procedures of operating a wastewater treatment plant, including related local, state, and federal regulations.
• 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 40 pounds or less.
• Communicate clearly and concisely, both orally and in writing.
• Keep and maintain written records and reports.
• Establish and maintain effective working relationships with those contacted in the course of work.

Experience and Training

Experience:

• No experience is required; some experience in repairing/maintaining mechanical equipment and/or knowledge of mechanical processes is preferred.

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.
• Possession of, or ability to obtain, a Wastewater Treatment Plant Operator Grade I certificate issued by the State Water Resources Control Board.

SUPPLEMENTAL QUESTIONNAIRE

1. Please describe any experience or school coursework associated with wastewater treatment.

SELECTION PROCESS

Applications will be screened by the Human Resources Department for minimum qualifications.  Qualifying applicants may be contacted by the Department to interview. 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 October 5, 2018.

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.

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 Utility Government Relations Supervisor (current formal title: Department Government Relations Administrator) in the Electric and Environmental Utilities Departments.  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.

DEFINITION

To plan, organize, direct and supervise the activities and operations of an assigned department’s governmental relations and legislative programs with federal, State, regional and local government entities through advocacy, coalition-building and public education; to research, analyze and coordinate advocacy efforts advancing a variety of department specific activities including legislative services, regulatory engagement grassroots lobbying, grants, and development of policy and strategy,   and to provide highly responsible technical support to the department Director.

SUPERVISION RECEIVED AND EXERCISED

• Receives general direction from the citywide Government Relations Administrator and reports directly to a higher level department manager.
• Exercises direct supervision over assigned professional and administrative personnel.

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

• Direct and supervise department specific legislative and regulatory activities and strategy; recommend and implement goals and objectives; establish performance standards and methods for department government relations and legislative program activities and operations; develop and implement policies and procedures.
• Track pertinent state and federal legislation and regulatory matters, specific to department operations and activities, and monitor legislative and regulatory developments; recommend positions on key bills or regulatory matters; provide analyses and reports to department management and Citywide Governmental Relations Administrator about federal, state and regional legislative and regulatory proposals, hearings, and activities and their impact on department operations.
• Plan, prioritize, assign, supervise and review the work of staff involved in tracking and responding to legislative and regulatory activities impacting departments operations and activities.
• Establish and maintain  effective working relationships with the City's state and federal delegations and staff and interest groups; direct contact with federal, state, and local elected officials and administrative agencies on legislation, state and regional issues, and regulatory matters; develop, plan and facilitate meetings between City officials, regional, state and national elected officials and organizations.
• Assist with the oversight of contract lobbyists.
• Develop and coordinate grassroots lobbying strategies as they relate to department operations; analyze problems and identify alternative solutions, project consequences of proposed actions and implement recommendations in support of goals
• Assist department staff to influence federal and State executive, legislative and administrative agencies through written arguments and oral testimony; brief and prepare department staff to testify at meetings and hearings; make presentations at legislative and regulatory hearings.     
• Research and prepare state and federal grants applications for assigned department; prepare and present periodic presentations for City staff regarding grant applications
• Train department staff in State and federal legislative and budget processes.
• Identify, establish, and maintain close working relationships with community-based and civic organizations and individuals engaged in government affairs to further the department’s objectives. 
• Participate in budget preparation and administration; prepare cost estimates for budget recommendations; submit justifications for staffing, equipment, material and supplies; monitor and control expenditures.
• Answer questions and provide information to the public regarding the City’s legislative platform and positions on key legislation, policy and regulatory matters. 
• 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 legislative and administrative processes, laws and regulation.
• Principles and methods of effective advocacy and group process techniques.
• Modern office procedures, methods and computer equipment.
• Principles and practices of research analysis and management.
• Principles and practices of public administration including planning, organizing, staffing, leading and controlling.
• Principles of supervision, training, and performance evaluations.
• Principles of budget monitoring.
• Principles and practices of work safety.

Ability to:

• Organize, implement and direct government relations and legislative program operations and activities for an assigned department.
• On a continuous basis, analyze budget and technical reports, interpret and evaluate staff reports; read and interpret complex laws, regulations and codes; problem solve department related issues; remember various rules and procedures; and explain and interpret policy.
• On a continuous basis, sit at desk and in meetings for long periods of time.  Intermittently twist to reach equipment surrounding desk; perform simple grasping and fine manipulation; use telephone, and communicate through written means.
• Monitor federal and state legislative issues; inform staff of potential impact on existing and future city operations.
• Interpret and explain pertinent program services, departmental, and City policies and procedures.
• Develop and monitor an assigned program budget.
• Develop and recommend policies and procedures related to assigned operations.
• Establish and maintain effective working relationships with those contacted in the course of work including subordinates, peers, senior management, elected officials, community groups and the general public.
• Communicate clearly and concisely, both orally and in writing.
• Supervise, train and evaluate assigned staff.

Experience and Training

Experience:

• Four (4) years of professional legislative, regulatory or local government advocacy experience as it relates to the operations and activities of the assigned department, including issue management, public relations, public affairs, and public presentations.

AND

Training:

• A Bachelor's degree from an accredited college or university, preferably with major coursework in public administration, political science, planning, economics, communications, or history.

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 publicly owned utility related legislative and/or regulatory advocacy experience do you have?

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

4. Briefly describe your experience working in any of the following policy areas. Include any experience in advocacy, legislative, and regulatory venues.  Highlight any experience with municipal or other publicly owned utilities.

• Wastewater
• Recycled Water
• Drinking Water
• Energy

5. What are the top three policy challenges or opportunities that you anticipate for municipal utilities in California within the next 5 years for the area(s) you discussed in Question 4?

6. Other than those listed in Question 4, discuss any additional policy areas and venues (advocacy, legislative, regulatory, local, state, federal) where you have experience and / or interest?

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 the first 50 qualified applications or closing at 5:00 pm, October 15, 2018; whichever occurs first.

 

 

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

 

 

THE POSITION

The Human Resources Department is accepting applications for the position of Data Management Specialist II. The current vacancy is a limited term, benefitted and full-time position in the Electric Department, however the employment list that will be established from this recruitment may be utilized to fill future regular and full-time vacancies in the City for the duration of the list.  The term length for limited term vacancies is not guaranteed but cannot exceed 36 months. The normal work schedule is Monday through Friday, 8 –5 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.

 

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-5 Years
• 5+ Years

 

4.  How many years of work experience do you have in Web Development?

• 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 analytical models? What is your level of proficiency with MS Office products, SQL, JAVA, cloud based application development, etc.?

 

8.  Briefly describe your experience with functional, integration, and end-to-end 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.

FINAL FILING DATE:                       We are accepting the first 50 qualified applications or closing at 5:00 pm, October 15, 2018; whichever occurs first.

 

 

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

 

 

THE POSITION

The Human Resources Department is accepting applications for the position of Data Management Specialist I. The current vacancy is a limited term, benefitted and full-time position in the in the Electric Department, however the employment list that will be established from this recruitment may be utilized to fill future regular and full-time vacancies in the City for the duration of the list.  The term length for limited term vacancies is not guaranteed but cannot exceed 36 months. The normal work schedule is Monday through Friday, 8 –5 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.

 

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-5 Years
• 5+ Years

 

4.  How many years of work experience do you have in Web Development?

• 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 analytical models? What is your level of proficiency with MS Office products, SQL, JAVA, cloud based application development, etc.?

 

8.  Briefly describe your experience with functional, integration, and end-to-end 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.

FINAL FILING DATE:                       Open Until Filled.  First cut-off is August 24, 2018.

 

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 tentatively scheduled for Tuesday, September 11, 2018.

 

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 –5 pm; a flex schedule may be available.

 

The City of Roseville promotes a no smoking atmosphere.

 

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 were recently involved in 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:                       Open Until Filled.  First cut-off is August 17, 2018.

 

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 tentatively scheduled for Friday, August 24, 2018.

 

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 AMI / Smart Grid Project Manager (Advanced Metering Infrastructure Project Manager) 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.

 

DEFINITION

To plan, organize, direct and manage the Advanced Metering Infrastructure (AMI) project for the water and electric utilities including governance, functional and operational tasks; to provide business and technical advice and expertise; and to serve as a resource to City staff and departments.

 

SUPERVISION RECEIVED AND EXERCISED

• Receives general direction from an assigned manager.
• May exercise direct supervision over professional, technical, and administrative support 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 related to the implementation of the City’s AMI; establish schedules and methods for the implementation of AMI.
• Define scope of AMI project and identify detailed work plan and tasks in coordination with project team and management.
• Plan, organize, and direct staffing and outside resources as necessary for implementation of City objectives associated with AMI implementation.
• Manage the design and implementation of strategies through discussions and negotiations with key stakeholders.
• Develop and monitor project budget and milestones, ensuring AMI project is completed consistent with deadline, budget, scope and overall goal.
• Lead, establish, and implement selection processes for outside resources and direct internal resources consistent with project goals and objectives.
• Review and approve various work products by consultants and staff related to assigned projects.
• Produce or guide the development of presentations and written documents for various target audiences.
• Provide regular and timely updates to the City Manager, City Council, and other appropriate parties.
• Research, compile and prepare reports and documentation on project activities; analyze project and develop corrective action; prepare periodic status reports.
• Represent AMI on committees, outside organizations, and at staff subcommittees as necessary; coordinate activities with other divisions and outside agencies.
• May participate in the selection of staff; provide or coordinate staff training; work with employees to correct deficiencies; implement discipline procedures; conduct performance evaluations.
• Answer questions and provide information to the stakeholders; investigate complaints and recommend corrective action as necessary to resolve complaints.
• 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:

• Advanced principles and practices of AMI project management.
• Principles and practices of change management.
• Principles and practices of vendor management.
• Principles and practices of leadership, motivation, team building, negotiations, and conflict resolution.
• Practices of AMI systems administration and/or AMI workflow and configuration.
• Pertinent local, State and Federal laws, regulations and laws.
• Budgeting procedures and techniques as related to project management.
   

Ability to:

• Organize and direct AMI project development and implementation.
• 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.
• Gather data from appropriate sources; analyze problems; identify alternative solutions; project consequences of proposed actions; and implement recommendations in support of AMI project goals.
• Consider varying opinions and views and work collaboratively in the best interest of the City.
• Interpret and apply City policies, procedures, rules and regulations.
• Analyze and interpret complex technical reports and documentation.
• Work cooperatively and effectively with others to set goals, resolve problems, and make decisions that enhance organizational effectiveness.
• Assess situations to determine the importance, urgency and risks, and make clear decisions which are timely and in the best interests of the organization.
• Determine strategies to move the organization forward, set goals, create and implement actions plans, and evaluate the process and results.
• Understand the client’s needs and provide realistic expectations to achieve desired results.
• Prepare and make effective training presentations, both formally and informally.
• Ensure goals and objectives of project are clearly identified and communicated.
• Motivate project team.
• Assist in the development and monitoring of an assigned program budget.
• Supervise, train, and evaluate assigned personnel.
• 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:

Five years of increasingly responsible experience in AMI or similar systems implementation and/or workflow and configuration development that included project management.

 

Training:

A Bachelor’s degree from an accredited college or university, preferably with major coursework in computer science, information systems, business administration or a related field is preferred.

 

License or Certificate

• Possession of a valid California driver’s license by date of appointment.
• Possession of a Project Management Professional Certificate (PMP) from the Project Management Institute, Inc. (PMI) or Certified Project Professional (CPP) credential from the International Association of Project and Program Management (IAPPM) is desirable.
   

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 do you have experience in AMI or similar systems implementation and/or workflow and configuration development that included project management?

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

 

4.  Do you possess a Project Management Professional Certificate (PMP) from the Project Management Institute, Inc. (PMI) or Certified Project Professional (CPP) credential from the International Association of Project and Program Management (IAPPM)? If yes, please attach a copy to your application.

• Yes
• No

 

5.  Roseville’s multi-year advanced meter infrastructure (AMI) project kicked off in early 2018. How would you come up to speed and assume the leadership role on the project?
 

6.  Roseville’s AMI project will impact virtually every household and business in the City.  What can Roseville do to ensure public perception and customer satisfaction are positively impacted by this project?
 

 

 

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.