Senior Systems Analyst - Ontario, United States - City of Ontario, CA

Description

Salary : $108, $132,204.80 Annually

Location : Ontario, CA

Job Type: Full Time

Job Number: Sr Sys Analyst

Department: Information Technology

Opening Date: 04/07/2023

Closing Date: Continuous

FLSA: Non-Exempt

Bargaining Unit: CON

The Position

An additional 9.5% general salary increase will be applied effective July 2024.

Do you enjoy supporting software applications, database administration, network administration and geographic information systems? Are you interested in gaining valuable experience to expand and develop in the field of Information Technology? Are you interested in working with the fastest growing City in the Inland Empire?

If so, the City of Ontario has the perfect position for you

The Information Technology Agency INVITES YOU to apply

to join the team as a Senior Systems Analyst.

The Information Technology Agency has an exciting opportunity for an analytical individual passionate about finding innovative solutions to the City's needs using information technology systems. The Senior Systems Analyst is responsible for supporting all City departments and the Ontario International Airport Authority, with defining system needs, assuring system integration, performing expert functional/technical maintenance and support, and project management. Additionally, this position will play an active role in the ongoing assessment of system needs and assist with future system implementations. The Senior Systems Analyst may be assigned to one of the IT Agency's Departments: Systems, Operations, or Applications.

Completed applications will be reviewed and only qualified applicants whose qualifications best meet or exceed the requirements of the position and needs of the City, will be invited to participate further in the selection process.

Applications will be accepted on a continuous basis until a sufficient number of qualified applications have been received. Qualified applicants are encouraged to apply early as this recruitment may close at any time without notice.

The ideal candidate will have the innate ability to easily articulate business needs, analyze and provide sound recommendations to improve the efficiency and effectiveness of overall system functionality, takes pride and ownership when managing assigned projects, and foster and maintain effective working relationships with employees, City officials, outside agencies, and the general public. Additionally, the successful candidate will be a role model for the City's Approach to Public Service - Commitment to the Community, Achieving Excellence Through Teamwork, and Doing the Right Thing the Right Way - and emulate the qualities of a 5 Tool Player - Leader, Thinker, Operator, Communicator, and Public Servant.

The current vacancies for this recruitment are in the IT Applications Department and IT Systems Department, however, this recruitment will result in an eligibility list, which may be used to fill future vacancies within all three (3) IT Departments as they become available.

Please note the following procedures will apply:

• The Eligibility List will consist of both internal and external applicants who meet the qualifications and successfully complete any required selection processes.
• Hiring departments will have the option to consider internal applicants on the Eligibility List prior to considering all candidates on the Eligibility List.

*** Background Check Requirement ***

As part of their duties, Senior Systems Analysts may be assigned to work in the Ontario Police Department facilities or will have access to Police Department information systems. As a result, employment in this position is subject to the satisfactory completion of a background investigation conducted by the Ontario Police Department.This background investigation will include the passing of a polygraph test. Candidates may be disqualified from further consideration during the background investigation for a variety of reasons including but not limited to an excessive number of traffic citations and/or collisions; arrests and/or convictions; a history of illegal substance abuse; poor credit history (factors include bankruptcy, foreclosures, liens, repossessions, and recency); or thefts from a previous employer. For clarification of any of the above disqualifying reasons, please call the Police Department Background Unit at The following list describes some areas that are covered in the background investigation:

• Your relatives, references, and acquaintances are asked to comment on your suitability for this position.
• The information supplied regarding your educational history is examined and verified.
• You must list a history of your residences.
• Your work history and experience are examined with regard to your dependability, relationships with fellow workers, trustworthiness, and general job performance.
• Military service records are subject to verification.
• The background investigation considers your management of personal finances (however, being in debt does not automatically disqualify you).
• Your criminal, driving, and insurance records are evaluated.

Additionally, Senior Systems Analysts may be assigned to work at the Ontario International Airport Authority (OIAA) and must possess the ability to pass all background/reference checks, knowledge examinations, as well as aptitude tests necessary to obtain and maintain a security badge to access secured areas of the Ontario International Airport. Applicants must pass a Criminal History Record Check (CHRC) and Security Threat Assessment (STA) prior to receiving a security badge.

The Information Technology Agency

TheInformation Technology Agency provides reliable and innovative information solutions to systems and support to improve business operations, performance and outcomes. Information technology impacts all aspects of City operations, efficiency and customer service. Ontario IT is a 24-hour, 7 day a week operation, which provides support of technology solutions used by all City departments and includes IT support services for the Ontario International Airport. Our extensive information infrastructure includes networks, telecommunications, servers, computers, software, and mobile and field equipment. The IT Agency continuously strives to exhibit integrity, professionalism and teamwork and to deliver consistent and reliable IT services.

The City of Ontario

The City of Ontario is a dynamic leading and growing community in the Inland Empire with a variety of full-time and part-time employment and volunteer opportunities. Ontario is proud to have the reputation of being a progressive City providing solid leadership to its citizens and to the business community. The City provides a full range of services to the community including: Police, Fire, Management Services, Community Life & Culture, Community Development, Public Works, Financial Services, Human Resources/ Risk Management and the Ontario Municipal Utilities Company. The City's team is staffed with approximately 1,517 full-time equivalent diverse and talented employees who work to support a common goal of providing excellent service to the community.

We invite you to learn more about the City of Ontario by reviewing the City's website including the City's 2023 State of the City Address to learn more about the exciting opportunities this position will play in the vital growth of the City in becoming the Premier Community of the Inland Empire

Please click on other useful links below to learn more about the City of Ontario:

Approach to Public Service(Core values for City of Ontario employees)Ontario City Employees(Information about City of Ontario benefit plans)The Ontario Plan(The City's Comprehensive Business Plan for Development)
Examples of Essential Functions

The essential functions typically performed by the Senior Systems Analyst include the following:

• Identifies improvements and enhancements to current systems based upon business requirements.
• Researches and develops recommendations for the implementation of new automated solutions.
• Tests new software releases, patches, and updates; troubleshoots technical and functional problems.
• Provides guidance and support for a variety of citywide information technology systems and applications.
• Maintains and updates citywide information technology systems and applications through programming or the use of the system / application's administrative functions.
• Trains functional users in efficient application operation and report writing.
• Supports digital exchange of data across various information management systems.
• Manipulates and analyzes data from a database environment.
• Develops reports designed to address user specific needs for information.
• Prepares and maintains documentation of systems, programs, and projects to describe program development, logic, coding, and correction.
• Develops manuals describing installation and operating procedures for end users.
• Develops SQL statements, reports, and SQRs.
• Serves as project team leader; oversees major projects, prepares and maintains documentation of systems, programs, and projects.
• Mentors and trains lower level staff.
• May direct the work of technical and other support staff.
• Provides research, analysis, design, and problem resolution to determine and develop recommendations for best practice information systems solutions.

Qualification Guidelines

Education

Equivalent to a Bachelor's Degree from an accredited college or university in Computer Science, Information Technology, Public Administration, Business Administration, or a closely related field. Additional related experience, or experience in a lead capacity implementing an enterprise information system, may be substituted for the required education on a year for year basis.

Proof of successful completion of a bachelor's degree must be provided by way of attachment to your online application or as an email attachment sent to the Hiring Agency Representative at, or before, time of the reference check process. Acceptable forms of proof include Unofficial Transcripts, Official Transcripts, Photos and/or Photocopies of Institutional Degree/Certifications.

NOTE: Failure to provide the required documentation at, or before, time of the reference check process will result in disqualification.

Experience

Three (3) years of experience maintaining, implementing, or supporting enterprise information systems.

License

Valid California Class C Driver's license and an acceptable driving record at time of appointment and throughout employment.

Special Requirements

May be required to work any shift in a 24-hour/day, 7-day/week operation on a rotational basis including weekends and holidays. Ability to work overtime.

Desirables

For IT Applications:

• Experience working in the public sector and supporting systems for areas such as Police/Fire Dispatch, Airport Operations, Land Management, Finance, Human Resource Management, Utilities and Public Works.
• Experience with system implementation as a project manager or in a senior technical role.
• Experience utilizing and supporting reporting tools such as BIRT and SAP Crystal Reports.
• Experience creating charts and dashboards utilizing data analysis tools such as PowerBI and Sisense.
• Experience configuring, administering, and supporting modern cloud SAAS systems such as Microsoft Office365, ServiceNow, Workday Human Capital Management and Finance (full suite).
• Experience supporting on-premise Microsoft Windows-based systems such as Accela.
• Experience utilizing and supporting Geographic Information Systems with ESRI products, including ESRI's Enterprise and Online server capabilities, ArcPy and Geoprocessing tools and functions.
• Experience utilizing and configuring integration tools such as Amazon Web Services Glue and FME workbench/server.
• Experience utilizing databases including SQL, SQL programming and GIS database maintenance.
• Experience utilizing and configuring cloud-based data warehousing solutions such as Amazon Web Services Redshift and Snowflake.
• Project management, information systems and/or programming related certificates.

For IT Systems:

• Experience with designing and configuring enterprise networks (firewalls, routers, switches, wireless access points).
• Experience with Software-Defined Networking solutions; public safety answering point technology; dynamic routing protocols; call center technology; maintaining enterprise telecom systems; PowerShell scripting and automation; database administration; VDI; PKI; and cloud computing.
• Network and/or Cybersecurity related certifications.

For IT Operations:

• Experience with service desk solutions such as ServiceNow, Remedy, Jira, Zendesk.
• Manage projects and understanding of the project life cycle.
• Experience with analyzing help desk data to help improve performance.
• Knowledge of cloud computing, device management, Microsoft solutions.
• Knowledge of desktop deployment tools.
• IT related certificates.

Background Investigation
Candidates must demonstrate the ability to successfully complete a background investigation conducted by the Ontario Police Department.
Supplemental Information

How to Apply

Apply online by clicking on the "Apply" link at the top of this announcement. If this is the first time applying for a position using , you will be prompted to create a new user account, otherwise log in with your user name and password. Your application and responses to any supplemental questions will be used to evaluate your qualifications for this position. It is suggested that your application include the following:

• List any relevant experience and education that demonstrates that you qualify for the position.
• List all periods of employment for at least the past 10 years, beginning with your most recent or present employer (including, if applicable, all employment with the City of Ontario).
• Separately list each position held, including different positions with the same employer.

A resume may be attached to your application but will not substitute for the proper completion of your application. Applications that are not properly completed may be rejected.

NOTE: Transcripts from colleges, universities or technical schools outside of the United States must be assessed for U.S. equivalency by a NACES educational credential evaluation service. Failure to provide a transcript or credential evaluation report will result in your application being rejected and you will not be able to continue in the selection process for this position.

All appointments to this position are required to provide proof of completion of the listed education requirements. Acceptable forms of proof include Unofficial Transcripts, Official Transcripts, Photos and/or Photocopies of Institutional Degrees/Certifications. This must be provided by way of attachment to your online application or as an email attachment sent to the Hiring Agency Representative conducting the reference check. Failure to provide the required documentation at, or before, time of the reference check process will result in disqualification

If you require clarification on this requirement, please call the City of Ontario Recruitment Team at

Supplemental Questions

To complete your application for this position, you will be prompted to respond to supplemental questions. This information will be used as part of the application screening and selection process and is designed to help you present your qualifications for this position. This may include a selection step in which your application and supplemental questions are reviewed.

Incomplete responses, false statements, omission, or partial information may result in disqualification from the selection process. Your responses should be consistent with the information provided on your application.

Please provide succinct, concise, descriptive, and detailed information for each question. If you have no experience, write "no experience" for the appropriate question.

Email Notices

Email is the primary way that Human Resources or the hiring agency/department will communicate with you. Please check your email account (including the SPAM folder) on a regular basis for any emails related to the application or selection process. Emails from the City of Ontario will come from "" or "" If you change your email address after submitting your application, please visit and update your profile.

Frequently Asked Questions

If you have any additional questions regarding the application process, please refer to our page.

Completed applications will be reviewed and only qualified applicants whose qualifications best meet or exceed the requirements of the position and needs of the City, will be invited to participate further in the selection process.

The City of Ontario values the health and wellness of our employees and their families. We understand benefits are an important part of your total compensation and we take pride in offering a comprehensive benefit package. Please check out our excellent benefit packages here

Employees in this classification are under the Confidential Employees Compensation and Benefits Profile. For a list of benefits for Confidential employees please click here

01

INSTRUCTIONS: The information on your application and the following supplemental questionnaire will be used in the evaluation of your qualifications. Detailed responses should be provided in order to ensure that your qualifications are properly considered. If the item does not apply, please enter N/A. By continuing you are certifying that all information provided in the supplemental questionnaire is true to the best of your knowledge.

• I understand the above statement.

02

Background Check RequirementThis position may be assigned to work at Ontario Police Department facilities. As a result, employment in this assignment is subject to the successful completion of an in-depth background investigation conducted by the Ontario Police Department and will include the passing of a physical examination including a drug screening. The background investigation is a rigorous process which often takes several months to complete. A typical background investigation includes but is not limited to: background interviews with individuals designated by the Ontario Police Department (this may include current and former co-workers, friends, relatives and neighbors, or any other relevant individual), criminal background check, credit check, and a polygraph examination. Candidates may be disqualified from further consideration during the background investigation for a variety of reasons including if they have: an excessive number of traffic citations and/or collisions; arrests and/or convictions; a history of illegal substance abuse; poor credit history (factors include bankruptcy, foreclosures, liens, repossessions, and recency); or thefts from a previous employer. For clarification of any of the above disqualifying reasons, please call Police Department Background Unit at Please indicate that you have read the statement above by selecting "Yes."

• Yes
• No

03

All appointments to this position are required to provide proof of completion of the listed education requirements. Acceptable forms of proof include Unofficial Transcripts, Official Transcripts, Photos and/or Photocopies of Institutional Degrees/Certifications. This must be provided by way of attachment to your online application or as an email attachment sent to the Hiring Agency Representative conducting the reference check. Failure to provide the required documentation at, or before, time of the reference check process will result in disqualification If you require clarification on this requirement, please call the City of Ontario Recruitment Team at Please indicate that you have read the statement above by selecting "Yes."

• Yes
• No

04

Which of the following best describes your highest related level of education?

• High School Diploma or Equivalent
• Some College Coursework, No Degree
• Associate's Degree
• Bachelor's Degree
• Master's Degree
• None of the Above

05

If you selected "Some College Coursework, No Degree Received" or "degree and additional coursework" in question 1, how many credit hours have you completed? Selet the Quarter/Semester hours that best describe your completed coursework. If you did not, select, N/A.

• N/A
• 4 Quarter hours/3 Semester hours
• 8 Quarter hours/5 Semester hours
• 12 Quarter hours/8 Semester hours
• 16 Quarter hours/11 Semester hours
• 20 Quarter hours/13 Semester hours
• 24 Quarter hours/16 Semester hours
• 28 Quarter hours/19 Semester hours
• 32 Quarter hours/21 Semester hours
• 36 Quarter hours/24 Semester hours
• 40 Quarter hours/27 Semester hours
• 44 Quarter hours/29 Semester hours
• 45-68 Quarter hours/30-45 Semester hours
• 69-95 Quarter hours/46-63 Semester hours
• 96-143 Quarter hours/64-95 Semester hours
• Quarter hours/96-127 Semester hours
• Quarter hours/ Semester hours

06

Please select the years of experience you have maintaining, implementing, or supporting enterprise information systems.

• No experience.
• Less than 1 year.
• 1 year or more but less than 3 years.
• 3 years or more but less than 5 years.
• 5 years or more.

07

Describe your years of experience maintaining, implementing, or supporting enterprise information systems. Please include in your response the employer's name, the specified duties performed, and the employment dates in which you performed these duties (mm/yyyy-mm/yyyy).

08

Based on your experience and certification(s), which department would you like to be considered for?

• Applications
• Systems/Operations

09

Describe a system implementation, major upgrade, or support service program in which you were the team leader or played a major role. Discuss the project/program, your specific role, and the outcome of the project/program.

10

Describe and elaborate on your IT experience related to Applications and specify how your experience relates to the Desirables for Applications. If not applicable, type "N/A".

11

Describe and elaborate on your IT experience related to Systems and specify how your experience relates to the Desirables for Systems. If not applicable, type "N/A".

12

Describe and elaborate on your IT experience related to Operations and specify how your experience relates to the Desirables for Operations. If not applicable, type "N/A".

13

List certification(s) you possess that are related to information technology, systems, programming, network, cybersecurity, and project management.

Required Question