SENIOR SOFTWARE ANALYST

The City of Modesto has an exciting opportunity for a dynamic, highly experienced, professional individual with excellent interpersonal skills to fill our Senior Software Analyst position.

The Senior Software Analyst role involves providing expert-level application support and maintenance, conducting business process analysis, managing projects from inception to completion, and executing duties requiring specialized knowledge. Additionally, the Senior Software Analyst will offer administrative support to the assigned manager.  This role is also responsible for overseeing and coordinating the work of assigned personnel, and ensuring tasks are appropriately distributed and completed.

We invite you to explore this opportunity with the City of Modesto.

**Please note, testing for this position is in-person with no option to test virtually. This position is an in-person position, with no option to work remotely. 

Applicants will be assessed on the application submitted.  Due to the volume of applications received, resumes will not be screened for the purposes of determining who is most qualified to compete in the testing process.  It is the applicant's responsibility to fill out the "Education" and "Work Experience" sections of the application with complete information and adequate detail.  Applications may be screened to the most qualified.  Do not substitute any part of the application form with the words "see resume."

The following information is provided for you to use as a reference and as a planning tool.  Human Resources is unable to schedule make-up examinations.


The City of Modesto is an equal opportunity employer. We are committed to fostering, cultivating and preserving a culture of diversity, equity and inclusion. A City application is required, including Supplemental Questionnaire.  

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

Essential Functions:

All Assignments:

Plan, prioritize, and review the work of staff assigned to a variety of professional application support, maintenance, and business process analysis duties.

Develop schedules and methods to accomplish assignments, ensuring that work is completed in a timely and efficient manner.

Participate in evaluating the activities of staff, recommending improvements and modifications.

Plan and coordinate staff training; work with employees to correct deficiencies.

Assume a key role in the execution of professional IT consulting/development projects.

Recommend highly complex technology solutions to clients.

Monitor and manage departmental customer satisfaction for assigned areas of responsibility.

Resolve highly complex problems and issues pertaining to areas of assignment.

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.

When Assigned to Business Software Analysis/Development:

Coordinate and perform complex business process analysis/re-engineering, using a formal and proven methodology.

Coordinate and participate in the execution of the full life cycle of development projects client-server or web-enabled platforms.

Facilitate customer sessions to define their application requirements.

Coordinate and participate in database design and specification development and application prototyping, development, and production testing.

Solve complex software programming and system design problems.

Code highly technical programs for data processing applications.

Provide technical guidance and assistance to other staff associated with software development.

Work on the conceptual and physical design of GIS databases, including establishing and maintaining table relationships, indices, and the rules governing data input into database applications. 

Design, develop, and maintain interfaces between GIS and existing City applications and databases such as: Permits Tracking, Fire Records Management, Police Records 

Management, Utilities work order processing, Business licenses, Financials, and other systems.

Develop and maintain SQL query statements and database connectivity.

Design, modify, and/or develop programming for the customization of end user applications or automation of processes.

When Assigned to Web Analysis/Development:

Manage domain names and associated records.

Provide representation on web related issues.

When Assigned to Application Database Administration:

Recommend measures to optimize system performance and response.

Perform database analysis and data modeling for logical and physical database design.

Coordinate and/or performs various database administration on various systems, including development, integration, sizing, tuning, rollout, and support.

Design and develop systems documentation and training.

Design and implement unattended backup and disaster recovery procedures.

Marginal Functions:

Perform related duties as assigned.

Knowledge of:

Depending on Assignment:

Industry best practices in the software development arena.

Advanced software design and relational and distributed database technology.

Data warehouse design and data mining practices.

Applied use of Geographic Information Systems as it relates to all sectors of local government.

Customization capabilities of GIS software.

Database backup and recovery.

Methods for installing and upgrading database servers.

Methods of database maintenance and system security.

Principles and practices of supervision, training and performance evaluations.

Database performance and optimization methods. 

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

Ability to:

Depending on Assignment:

Organize, implement, and direct assigned functions.

Provide technical guidance and assistance to other staff associated with application development.

Coordinate highly complex third-party application systems, application design, development, deployment, support, and maintenance projects.

Solve highly complex application programming and systems design problems.

Design and develop presentations, documentation, and training oriented toward customers.

Prepare difficult workflow and process diagrams and cost/benefit analysis.

Analyze complex procedures and data, and develop logical conclusions.

Communicating the use of GIS tools to end-users; customize the GIS graphical user interface (GUI) according to customer needs.

Understand and integrate GPS technology within the GIS environment.

Manage DNS and domain related issues.

Design the physical layout of databases and the physical relationships of databases and/or database tables; construct SQL calls to external or relational tables.

Recommend measures to optimize systems performance and response and troubleshoot database problems.

Code highly technical programs for data processing applications.

Supervise, train, and evaluate assigned staff.

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

Communicate clearly and concisely, both orally and in writing.

Operate office equipment including computers and supporting word processing, spreadsheets, 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:

Two years of responsible experience equivalent to Software Analyst II 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 REQUIREMENTS:

Candidates must 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 CONDITIONSWork 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.

Salary : $94,682 - $115,086