Systems Analyst (Systems, Applications, or Operations Division)

City of Ontario; Ontario; On-site; CAD 70,000 - 90,000; Full time

Job summary

The City of Ontario is seeking a Systems Analyst to enhance IT systems and support various citywide applications. The ideal candidate will possess strong analytical skills and a commitment to customer service. This role involves working with cutting-edge technology to improve city operations and provide exceptional service to the community.

Qualifications

• Two years of experience supporting enterprise information systems.
• May be required to work any shift in a 24/7 operation.

Responsibilities

• Identifies improvements to current systems based on business requirements.
• Tests new software releases and troubleshoots issues.
• Develops SQL statements and reports.

Skills

Analytical Skills

Problem Solving

Communication

Education

Bachelor's degree in Computer Science

Tools

SQL

GIS

PowerShell

Job description

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 Ideal Candidate

The ideal candidate will possess outstanding analytical skills with the drive to continuously assess and improve the efficiency and effectiveness of the City's systems; have the innate ability to take initiative and prioritize multiple conflicting demands in a high pressure environment; and demonstrate support for team efforts by readily accepting new roles, responsibilities, and training opportunities. The Systems Analyst is assigned to one of the three divisions (Systems, Applications, or Operations) based on background and experience. Candidates have the option to select which division they would like to be considered for. Additionally, the successful candidate will be a role model for the City’s Customer Service Philosophy– Empathy, Respect, and Problem Solving– and emulate the qualities of a "Five-Tool Player"– Leader, Thinker, Operator, Communicator, and Public Servant.

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.

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 following procedures will apply :

This recruitment will result in an eligibility list, which may be used to fill future vacancies within all three (3) IT Divisions 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.

The Information Technology Agency

Our mission at the Information Technology Agency is to revolutionize business operations, pushing the boundaries of innovation to achieve exceptional outcomes. Every corner of City operations is touched by the transformative power of Information Technology, boosting efficiency and elevating customer service to new heights. 24 / 7, 365 days a year, we provide unwavering support for the technological solutions that drive the success of all City departments, including the bustling Ontario International Airport. Our information infrastructure forms the backbone of our operations, connecting networks, telecommunications, servers, computers, software, and the latest mobile and field equipment. Behind this cutting-edge technology stands a team fueled by integrity, professionalism, and an unyielding spirit of collaboration. Our commitment to delivering consistent and reliable IT services is the bedrock of our agency. Together, we're charting an exciting course towards a future where possibilities are limitless. Join us on this transformative journey as we embrace the challenges of the digital era and unleash the true potential of technology to shape a brighter tomorrow. The City of Ontario Information Technology Agency invites you to be a part of this inspiring journey!

The City of Ontario

The City of Ontario is a dynamic leading community in the Inland Empire with a variety of full-time and part-time employment and volunteer opportunities. Ontario enjoys the reputation of being a progressive City which provides 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, Economic Development, Public Works and the Ontario Municipal Utilities Company. The City's team is staffed with approximately 1,500 full-time and 300 part-time diverse and talented employees who work to support a common goal of providing excellent service to the community.

The City‘s vision for the future is very exciting and we foresee tremendous growth within the year(s) to come. We welcome you to view the City of Ontario’s 2024 State of the City video by clicking on the link below as well as other links to learn more about the City.

State of the City | The Ontario Plan | Smart Ontario | Downtown Ontario

Functions of the Systems Analyst :

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

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.

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.

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 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 Police Department Background Unit at [phone].

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, 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 [phone].

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.