Database Analyst I/II

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

Database Analyst II - This is the journey level class within the Database 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., * Educational background from a foreign country may be evaluated by an accredited United States college or university listed on the U.S. Department of Education Database of Accredited Post-Secondary Institutions and Programs website.

• Verification of degree equivalency may be obtained from organizations that provide foreign education credential evaluation services. The City of Roseville will accept verification from any of the listed member agencies found at http://www.naces.org or www.aice-eval.org.
• A copy of the foreign credential evaluation verification can be attached to the employment application.
• If you are offered a position with the City of Roseville, as a part of the pre-employment steps, applicants must provide a foreign degree credential equivalency certificate from an approved member agency above. Applicants who do not provide verification, will be eliminated from further consideration.

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 the position applied for, a pre-employment medical exam, drug and alcohol screening test, credit check, license and/or education verification, psychological examination, and/or an extensive Police Department background check process.

Some positions require the clearance of a comprehensive Police Department (PD) background check within 12 months of appointment. The City may appoint candidates to positions prior to clearing the extensive Police Department background check, and in those circumstances the candidate will be advised in advance that security access in the information technology systems will be limited to non-PD related systems until PD clearance is received, and if the candidate ultimately does not clear the PD background it will result in release from City service without appeal rights, in accordance with Personnel Rules 3.04.050., Select the best answer to describe your years of experience in performing Database Analyst I/II related duties.

The City of Roseville is seeking a skilled and collaborative Database Analyst to join our team and support the critical data systems that help deliver essential public services to our community. In this role, you will manage, optimize, and protect agency data while partnering with departments across the organization to improve reporting, enhance system performance, and support informed decision-making. This is an excellent opportunity for a detail-oriented, solutions-focused professional who thrives in a public service environment and is motivated to strengthen operational efficiency, data integrity, and transparency for a growing organization., No professional experience is required., A Bachelor’s degree from an accredited college or university, preferably with major course work in computer science, information systems, GIS or a related field.

License or Certificate:

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

Database Analyst II:

In addition to the qualifications for the Database Analyst I:

Experience and Training

Experience:

Two years of responsible experience performing duties similar to that of a Database Analyst I, within the respective assignment, with the City of Roseville.

AND

Training:

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

License or Certificate

Possession of a valid California driver’s license by date of appointment., * High school graduate, diploma or the equivalent (GED)

• Associate degree
• Bachelors degree or higher degree

03

This position requires all candidates to possess a California Drivers License by date of appointment.

• Yes, I have, or will have, a California Drivers License by date of appointment.
• No, I will not have a California Drivers License by date of appointment., * Up to one year of professional paid experience
• 1-3 years of professional paid experience
• 3-5 years of professional paid experience
• 5-7 years of experience
• 7+ years of experience

05

Describe your knowledge, skill, or ability in one or more of the following areas: Business Intelligence, Database Administration, Enterprise GIS Administration, and/or System Integration. In so doing, please provide any relevant work experience and specific examples that demonstrate your competency. (Note: it is not required to respond to all areas listed.)

06

Which of the following areas would you pick to develop your knowledge and skills during the next five years and why? Reporting & Dashboards, Database Management, Data Availability, Data Transfer & Integration, GIS Platform Support, or GIS Data Editing., Background Investigation, Business Intelligence, California Public Employees Retirement System (CalPERS), Community and Social Services, Compensation and Benefits, Computer Science, Data Quality, Database Administration, Database Analysis, Decision Support, Detail Oriented, Driver’s License, Editing, Educational Evaluation, Employee Assistance Plan, Employee Benefits, Flexible Spending Accounts, Geographic Information Systems (GIS), Health Insurance, High School Diploma, Information Technology & Information Systems, Information/Data Security (InfoSec), Multilingual, Needs Assessment, Operations Processes, Reporting Dashboards, Retirement Plan, Service Delivery, Spatial Data, System Integration (SI), Team Player, Training/Teaching, Web Programming

The list established from this recruitment will be used to fill any Regular, Limited Term or Temporary, Part-time vacancies for the duration of the list.

What the City of Roseville Offers:

• $37.4460 - $57.9594 per hour (dependent on experience)
• Opportunities to learn and promote
• CalPERS
• A top-notch team
• And much more!

The City of Roseville is committed to a diverse workforce. We are engaged in understanding the needs and backgrounds of our colleagues and those we serve. Our organization is unified in this commitment, as we believe this produces the best results for our community., The City of Roseville offers competitive benefits packages to full-time employees. Regular part-time employees receive benefits on a pro-rated basis. For more information regarding the Citys benefits, visit our website here. Benefits currently include:

• Health, dental, and vision insurance benefits
• Cafeteria plan, plus City paid Flex credit
• Life insurance (City paid and optional supplemental employee paid)
• Flexible spending accounts for dependent and health/medical costs
• BeWell City of Roseville (CORE) wellness program
• Employee assistance plan
• Retirement savings plan
• Deferred compensation plan(s)
• Short-term and long-term disability employee paid plans
• Educational reimbursement
• Vacation leave, sick leave, personal/management leaves
• Holiday pay (plus two floating holidays annually)
• Bilingual pay
• Longevity pay