** The current vacancy is assigned to the Police Department, with the possibility of reassignment to other departments in the future. Candidates must successfully complete a P.O.S.T.-level background investigation to obtain the required clearance for working with Police Department information systems.

The Software Analyst is responsible to perform a variety of professional application support, business process analysis, and maintenance duties including specialties such as Software, GIS, Web, and Database Support; to perform application support and maintenance, business/workflow analysis, application integration, report development, testing processes, and project management; and to maintain existing third-party applications and/or develop new service delivery programs and solutions.

**This position is NOT remote. There will not be an opportunity for virtual or remote work. All interviews and testing will be held in-person. Any travel expenses incurred to attend testing or interviews will be at the candidate's expense.

Essential and other important responsibilities and duties may include, but are not limited to, the following:

Essential Functions:

All Assignments:

Assist with software development projects on one or more of the following platforms: Unix, Microsoft, client-server or web-enabled.

Communicate and work with third-party vendor sales, applications, and support.

Perform workflow/business process analysis, application development, integration, and monitoring.

Develop and deliver customer presentations, demonstrations, and feedback sessions.

Perform a wide range of system testing, including alpha, beta, and production testing.

Provide general application support including application maintenance and ongoing enhancements.

Assist with customer training; prepare procedures, handbooks, manuals, and other training related materials.

Assist with the development of project proposals and yearly work program/budget.

Stay current and maintain knowledge of emerging programming languages and procedures.

Develop functional/technical specifications identifying the features and functions of an application.

Install, configure, and perform go-live testing on complex applications and systems.

Perform quality assurance activities pertaining to interim work products and deliverables.

Perform project management responsibilities including the development of project plans and timelines.

Build and maintain positive working relationships with co-workers, other City employees, and the public using principles of good customer service.

Observe and maintain a safe working environment in compliance with established safety programs and procedures.

Analyze Statements of Work (SOW) and communicate with vendors to continuously review agreed-upon project outcomes, timelines and standards are met.

All Levels

When Assigned to Business Software Analysis/Development:

Support assigned third-party applications.

Prepare workflow and process diagrams and cost/benefit analysis.

Code routine program instructions.

Perform software maintenance.

Analyze procedures and data, and develop logical conclusions.

Serve as the subject matter expert on assigned third-party applications.

Code difficult program instructions.

Design and develop datamarts and data warehouses.

When Assigned to GIS Analysis/Development:

Coordinate with department/division “clients” to address and respond to their mapping, tabular, analytical, and reporting needs; develop, implement, and maintain applications and products that meet the client’s needs.

Prepare working and presentation maps, reports, and documents, as needed.

Assist with the maintenance of the City’s GIS Intra/Internet site and related data; assist with data development and maintenance, as needed.

Develop and maintain a wide range of GIS applications.

Design databases.

Maintain database indices and relational items.

Document the design, implementation, maintenance, and use of GIS applications.

Develop and carry out training for GIS applications.

Make recommendations for current and future technology infusions and upgrades by keeping abreast of current technology through seminars, journals, professional associations, peers, and other means.

Define, develop, and carry out analytical tasks and reports requested by customers ranging from simple query to complex overlay and what if modeling scenarios.

When Assigned to Web Analysis/Development:

Assist with security related issues pertaining to web site operation.

Provide technical assistance with Internet e-mail related issues.

When Assigned to Web Analysis/Development:

Assist in design and implementation of web-based applications.

Coordinate with the City Manager’s Office to ensure conformance with design standards.

Prepare and review statistical information pertaining to web sites.

Coordinate with staff and the public for implementation of new features.

Provide for the implementation and operation of web sites and servers.

Marginal Functions:

Perform related duties as necessary.

Software Analyst I

Depending on Assignment:

Knowledge of:

General principles and practices pertaining to the assigned specialty area including Business Software, GIS, or Web analysis/development.

How to utilize off-the-shelf vendor support.

Emerging technologies, including web-enabled (e-government) service delivery applications.

Methods and techniques of developing end-user documentation and training materials.

Desktop applications.

Principles of database design, development, and administration.

The development and use of quality assurance programs.

Principles of Internet (Web) design, development, and implementation.

Computer programming languages such as: Visual Basic, HTML, Java, C++; basic scripting languages in a UNIX and/or Microsoft environment;

Unix Systems, Client-Server, Web-enabled and related software; commonly used databases and operating systems on multiple hardware platforms.

Fundamental knowledge of software design, relational and distributed database technology.

Database reporting tools; basic concepts of data warehouse design and data mining.

Principles and practices pertaining to Geographic Information Systems (GIS), Global Positioning Systems (GPS), automated mapping systems, and database management systems and how they are utilized in the working environment.

Basic principles and practices pertaining to Web analysis and development such as security considerations pertaining to web-based applications, DNS and basic connectivity issues related to web sites and their presentation, and basic e-mail as related to web site operation.

Office procedures, methods, and equipment including computers and applicable software applications such as word processing, spreadsheets, and databases.

Ability to:

Depending on Assignment:

Perform routine analysis, development and maintenance of general, GIS, and/or

Web applications, depending upon assignment.

Assist with business process analysis, application design, development, system installation/deployment, support, and maintenance.

Carry out multiple tasks simultaneously.

Analyze procedures and instructions, and develop logical conclusions.

Organize and prioritize work, establish procedures, and meet deadlines.

Stay current and maintain a strong knowledge of emerging programming languages and procedures.

Analyze work papers, reports, and special projects.

Identify and interpret technical and numerical information.

Observe and problem solve operational and technical policy and procedure issues.

Establish and maintain effective working relationships with those contacted in the course of work.

Communicate clearly and concisely, both verbally and in writing.

Operate office equipment including computers and supporting word processing, spreadsheet, and database applications.

Experience and Training Guidelines:

Any combination of experience and training that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:

Experience:

Training:

Equivalent to a Bachelor’s degree from an accredited college or university with major course work in business information systems, computer science, geographic information systems, or a related field.

License or Certificate:

ADDITIONAL REQUIREMENTS:

Incumbents must be able to pass a P.O.S.T. level background investigation prior to appointment for clearance to work on Police Department Information Systems.

Software Analyst II

In addition to the qualifications for Software Analyst I:

Depending on Assignment:

Knowledge of:

Remote sensing including its capabilities, applications, and use in conjunction with GIS; global and local coordinate systems and datum.

Principles and practices of cartography including methods, techniques, and symbolism.

Common GIS data formats, national standards as related to data formats, and metadata.

Advanced Web computers, information systems, and Internet technologies.

HTML and Active Server Page programming.

Depending on Assignment:

Information Technology best practices.

Formal application development and project management methodologies.

Ability to:

Depending on Assignment:

Execute and/or manage moderately complex third-party application systems, application design, development, deployment, support, and maintenance projects.

Manage projects within project costs, resources, and schedules.

Develop project plans and reasonable timelines.

Recommend measures to optimize system performance and response.

Work with GIS database tools used by the City of Modesto; integrate data from multiple sources with City of Modesto GIS data; solve complex analytical problems utilizing GIS software.

Deploy, configure, and maintain web servers and related software.

Experience and Training Guidelines:

Any combination of experience and training that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:

Experience:

Two years of responsible experience equivalent to Software Analyst I with the City of Modesto. Depending on assignment, focused experience in general software analysis, GIS analysis, or Web analysis may be required.

Training:

Equivalent to a Bachelor’s degree from an accredited college or university with major course work in business information systems, computer science, geographic information systems, or a related field.

License or Certificate:

Possession of, or the ability to obtain, a valid California driver’s license.

ADDITIONAL REQUIREMENT

Incumbents must be able to pass a P.O.S.T. level background investigation prior to appointment for clearance to work on Police Department Information Systems.

Mobility: frequent use of keyboard; frequent sitting for long periods of time; occasional bending or squatting. Lifting: frequently up to 25 pounds; occasionally up to 50 pounds. Vision: constant use of overall vision; frequent reading and close-up work; frequent color and depth vision. Dexterity: frequent repetitive motion; frequent writing; frequent grasping, holding, and reaching. Hearing/Talking: frequent hearing and talking, in person and on the phone. Emotional/Psychological: frequent decision-making and concentration; frequent public and/or coworker contact; occasional working alone. Environmental: frequent exposure to computer noise.

WORKING CONDITIONS

Work is performed in a typical temperature-controlled office environment subject to frequent noise from computers and related equipment. Some work may occur at remote locations. Positions may require occasional overtime and weekend work and travel is rare.