Senior Software Analyst

City of Modesto•Modesto, CA

4d•Onsite

About The Position

Join us as a Senior Software Analyst and bring big ideas to life through creative problem-solving, smart systems design, and leadership that inspires. You’ll drive exciting projects, mentor talented teammates, and craft innovative solutions that actually make a difference. If you love variety, technology, and turning challenges into wins, this is your next adventure. The Senior Software Analyst role involves providing expert-level project management, 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! This is an in-person position. The recruitment process will be held in person without the option of interviewing or testing virtually.

Requirements

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.
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.
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.
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.
Possession of, or the ability to obtain, a valid California driver’s license.
Candidates must pass a P.O.S.T. level background investigation prior to appointment for clearance to work on Police Department Information Systems.

Nice To Haves

Salary Incentives: 2.5% Education Incentive (bachelor's degree) 5% Education Incentive (master's degree)

Responsibilities

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.
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.
Manage domain names and associated records.
Provide representation on web related issues.
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.
Perform related duties as assigned.