Systems Analyst (Systems, Applications, Or Operations Division)

The Position

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 opportunity for you!

The Information Technology Agency INVITES YOU to apply

to join the team as a Systems Analyst.

The Systems Analyst is assigned to one of the three divisions based on background and experience. Candidates have the option to select which division they would like to be considered for.

Please click on the link below to take a look at the Job Brochure for Systems Analyst and learn more about the position for each division, the benefits, & the City of Ontario!

CLICK HERE - Systems Analyst Job Brochure Link

Please note the following procedures will apply to this recruitment:

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.

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.

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

Examples of Essential Functions

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

• 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 Structured Query Language (SQL) statements, reports, and Structured Query Reports (SQR)s.

• Serves as a project team leader for small sized and/or less complex projects.

• Other duties may be assigned based on assignment.

Qualification Guidelines

Educational Requirements

A Bachelor's degree or its equivalent from an accredited college or university in Computer Science, Information Technology, or a closely related field. Additional related experience may be substituted for the required education on a year for year basis.

Experience Requirements

Two years of experience supporting enterprise information systems.

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.

Desirable

If assigned to IT Systems:

• Network and/or Cybersecurity related certifications.

• Experience with designing and configuring enterprise networks (firewalls, routers, switchers, wireless access points).

• Experience with SDN solutions; public safety answering point technology. Maintaining Enterprise telecom systems; PowerShell scripting and automation; database administration; VDI;PKI; and cloud computing.

If assigned to IT Applications:

• Formal training and certifications related to project management, supporting systems and/or programming

• Experience as a project lead or in a lead role in a system implementation

• Experience in databases including SQL, SQL programming and GIS database maintenance

• Experience using and supporting BIRT, Crystal Reports reporting

• Experience configuring and administering modern Cloud SAAS systems such as Microsoft Office365, Workday HCM and Finance (full suite)

• Experience implementing and supporting the ServiceNow platform

• Experience supporting on-premise Microsoft Windows-based systems such as Accela

• Experience utilizing and supporting Geographic Information Systems with ESRI products, with knowledge of ESRI's Enterprise and Online server capabilities, ArcPy and Geoprocessing tools and functions

• Ability to create meaningful charts and dashboards using data analysis tools like PowerBI and Sisense

• Experience using and configuring integration tools like AWS Glue and FME Workbench/Server

• Experience using and configuring Cloud based Data warehousing solutions like AWS Redshift and Snowflake

• Background in or working knowledge of government operations and supporting systems, including, but not limited to, Police/Fire Dispatch, Airport Operations, Land Management, Finance, Human Resource Management, Utilities and Public Works

If assigned to IT Operations:

• Certifications such as CompTIA A+, CompTIA IT Fundamentals+, Microsoft 365 Fundamentals, Microsoft Technology Associate (MTA), or other related.

• Knowledge of Helpdesk solutions such as ServiceNow, Zendesk, Jira.

• Experience with mobile device management solutions & desktop imaging solutions.

Supplemental Information

IMPORTANT INFORMATION- Please read thoroughly

BACKGROUND CHECK REQUIREMENTS

As part of their duties, Systems Analyst's 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 limitedto: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 (909) 395-2820. 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 examinedwith regard toyour 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, Systems Analyst's 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.

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 governmentjobs.com, 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 (909) 395-2035.

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 "@ontarioca.gov" or "governmentjobs.com." If you change your email address after submitting your application, please visit governmentjobs.com and update your profile.

Frequently Asked Questions

If you have any additional questions regarding the application process, please refer to our Frequently asked questions 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.