Technology Application Specialist

City of Santa Rosa, CA; Santa Rosa (CA); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Hybrid remote after probation

CalPERS retirement benefits

Health plans and wellness programs

PSLF-eligible employer

Job summary

The City of Santa Rosa’s Information Technology Department is seeking a Technology Application Specialist to support enterprise software applications and SQL databases. The role focuses on configuration, scripting, reporting, and user support across multiple city systems such as Finance, HR, Payroll, and Permitting.

The ideal candidate will have strong T-SQL, SSRS, and workflow skills, along with the ability to work with business leads and vendors to deliver process improvements and reliable

Qualifications

• Experience supporting enterprise apps and MS SQL databases.
• Ability to write complex T-SQL queries and stored procedures.
• Experience with SSRS and Cognos reporting tools.

Responsibilities

• Analyze, document and optimize business processes.
• Configure applications and modify workflows.
• Provide user support and training.
• Develop reports and perform data integrity checks.
• Coordinate with vendors and IT teams.

Skills

Enterprise software support

SQL Server / T-SQL

SSRS reports

Workflow scripting

Customer collaboration

Education

High school + college coursework in CS/IT

Tools

SQL Server Management Studio

SSRS

CentralSquare Click Drag and Drill

IBM Cognos

Accela Civic Platform

Job description

Technology Application Specialist

Join the City’s Information Technology (IT) team where you can be part of a dynamic, customer-centric, and collaborative organization committed to providing innovative solutions that leverage leading edge technologies.

The City of Santa Rosa is committed to building a workforce reflective of our community and establishing a lasting culture of equity and belonging within our organization. Our collective talents and expertise contribute to high-quality public services that support a vibrant, resilient, inclusive City for our community and visitors. We celebrate a diverse workforce and welcome all qualified candidates to apply.

The Benefits of City Employment:

In addition to offering a challenging, rewarding work environment and excellent salary, the City of Santa Rosa provides a generous suite of benefits, including retirement through CalPERS, a competitive leave accrual package, a choice of health plans, a flexible spending program, employer contributions to a Retiree Health Savings plan, and top of the line employer paid vision and dental coverage. More information regarding benefits associated with this position can be found on our Miscellaneous Employee Benefits Page HERE.

Additional benefits include:

• 12 paid holidays annually, plus 1 to 3 'floating holidays' per year, depending on hire date and years of service
• $500 annually for wellness
• Flexible schedule (9/80) available with management approval
• Paid Family Leave
• The City is a Public Service Loan Forgiveness (PSLF) qualifying employer
• Potential eligibility for a hybrid remote schedule after successful completion of probation

ABOUT THE POSITION:

The City of Santa Rosa is seeking a Technology Application Specialist with software system administration expertise and problem-solving skills to implement and support enterprise solutions serving our community. The current opening is in the Information Technology department under direction of the IT Supervisor of Enterprise Applications working with ERP systems that may include Finance, HR, Payroll, Timekeeping, Permitting, Inspections, and/or Code Enforcement modules. The list of eligible candidates resulting from this recruitment will be used to fill the current opening, and may be used to fill future Technology Application Specialist positions.

The primary purpose of this job classification is to handle software and enterprise-level application tasks of moderate to complex difficulty, supporting various operations across multiple departments in the City. This role is based in the Application Services division in the Information Technology department and assists with the daily management of essential software applications. Responsibilities include software configuration, workflow modifications, permissions administration, scripting, user support, process improvements, report development, and other related duties as needed. This position works closely with departmental business leads, subject matter experts, end-users, programming staff, and vendors to provide process improvements and ongoing support for the enterprise systems. This position will be the technical "go-to" person for the supported applications.

THE IDEAL CANDIDATE

The ideal candidate has experience supporting enterprise level software applications and Microsoft SQL databases, including writing complex T-SQL queries, developing stored procedures, using Microsoft SQL Server Management Studio, developing reports using Microsoft SQL Server Reporting Services (SSRS), and troubleshooting software problems. In addition, the ideal candidate has excellent interpersonal skills to work extensively with both technical and non-technical staff at all levels City-wide. The candidate must be able to logically create detailed documents and emails, as well as track, coordinate and facilitate communication on multiple projects simultaneously. Additionally, the ideal candidate has experience providing technical support for systems such as:

• ONESolution / Finance Enterprise developed by CentralSquare Technologies or other ERP-type systems that include Finance/HR/Payroll modules with timekeeping functions, and possesses skills with scripting, workflow, and report writing using CentralSquare Click Drag and Drill (CDD), Microsoft SSRS, or IBM Cognos
• Accela Civic Platform or similar permitting, inspection and code enforcement systems, and possesses skills with scripting, workflow, fee calculators, custom form configurations, GIS integration and report writing using Microsoft SSRS.

The following duties are considered essential for this job classification:

• Analyzes, documents and recommends changes to business processes;
• advises and consults with users to develop required application services for departmental business processes;
• plans, coordinates, and schedules future needs keeping all parties informed of plans, progress, and issues;
• develops and recommends application and resource priorities;
• evaluates existing program performance and recommends modifications;
• administers changes and adjustments to systems as needed;
• assists in the day-to-day operations of the department’s applications technology needs;
• replaces, repairs, upgrades, and maintains system software and hardware;
• monitors and recommends improvement to operational performance and security;
• troubleshoots system problems;
• isolates the cause of system failures;
• implements system upgrades;
• installs new and additional hardware and software as required;
• develops and implements automated records, workflows, stored procedures and specialized mid-level reports in response to user needs;
• conducts formal and informal training programs on the use and operation of various application systems software. Maintains and compiles documentation of user procedures manuals, technical references, training manuals, handbooks and guides;
• identifies opportunities for improving service delivery methods and procedures;
• reviews with appropriate management staff and implements improvements;
• maintains tables, data structures, diagrams and testing data;
• develops and administers methods to ensure data integrity;
• determines when to escalates problems to vendors or programmers to identify and correct causes of hardware and software malfunctions and to perform enhancements;
• responds to and resolves user inquiries and complaints;
• attends and participates in professional group meetings;
• stays abreast of new trends, innovations, equipment, and languages used in computer systems and information technology in the area of assignment, as well as standard word processing, spread-sheet, database, reporting tools, graphics, and desktop publishing software;
• provides emergency response to reduce down time, correct errors, monitor vendor activity, facilitate off hours scheduled maintenance, and repair system failures on an as needed basis; and performs other duties as assigned.

Knowledge of:

Modern principles and practices of computer systems management, analysis, design, database structures & relationships, script writing, documentation, and maintenance; various software packages including word processing, spreadsheet, and database management, reporting tools, graphics and desktop publishing applications and programs; principles, techniques, and tools of computer hardware and software installation, troubleshooting and maintenance; operating principles, methods, practices, options, and limitations of a wide range of hardware related to computers; data management theory, principles, techniques, and practices and their application to a wide variety of services and programs; applicable technical terminology, applications, features, and services; operating systems such as Windows, LAN/WAN principles, PC, Web and server applications and telephone systems; modern office practices, methods, and equipment; principles and procedures of record keeping and reporting; research techniques, methods, and procedures; occupational hazards and standard safety practices necessary in the area of computer operations; correct usage of the English language, including correct grammar, spelling, vocabulary, and punctuation; techniques for dealing effectively with, and providing a high level of customer service to, the public, vendors, contractors and City staff, both in person and over the telephone.

Ability to:

Analyze problems, identify alternative solutions, project consequences of proposed actions, and implement recommendations in support of goals; accurately evaluate and prioritize hardware and software requests; operate and troubleshoot modern office equipment including computer equipment and software programs; learn the operations and functions of assigned City work groups in order to provide appropriate support; research, develop, recommend and implement cost-effective technical system improvements; prepare and maintain accurate and complete records; respond to requests and inquiries from end-users; exercise good judgment, flexibility, creativity, and sensitivity in response to changing situations and needs; understand and carry out oral and written instructions; use English effectively to communicate in person, over the telephone, in a classroom and in writing; use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines; establish and maintain effective working relationships with those contacted in the course of the work.

Education and Experience:

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

Experience - Sufficient years of increasingly responsible experience providing administrative and technical support to users of a specialized computer application to demonstrate possession of the knowledge and abilities listed above, and Education- Equivalent to completion of high school supplemented by college or university coursework in computer science, information technology, business administration, or a related field

Ability to sit for extended periods of time with some ability to move about at will; ability to operate standard office equipment, computers and a variety of office software requiring continuous or repetitive arm-hand movements; ability to learn job-related material through oral and/or written instruction in an on-job setting, structured classroom training, and by reading and comprehending written material and graphic instructions and making inferences from the contents; ability to communicate verbally face-to-face, on the telephone, and in group meetings; ability to perform a visual scan of on-screen information when monitoring operation of applications; ability to occasionally lift and move monitors, printers, and other equipment weighing up to 50 pounds for short distances.