Information Technology Specialist I/II - Data & Development Services

Position Overview

The City of West Sacramento is hiring an Information Technology Specialist I/II with an emphasis on Data and Development Services. Reporting to the Data Services Manager in the City Manager’s Office, this role works with various City departments to identify reporting requirements, create new reports, and maintain existing ones. The position also collaborates with third-party vendors to integrate data between City computer applications and provides development and maintenance support for both in-house and third-party software applications.

Key Responsibilities

• Design, develop, test, and implement software applications and systems.
• Analyze, debug, and maintain existing applications.
• Administer database management systems, schedule upgrades, and monitor performance.
• Design, update, and install databases for new systems.
• Work with business stakeholders to modify and enhance existing reports.
• Develop and test reports using various report writing tools.
• Apply in-depth SQL knowledge to support data operations.
• Perform data mining and implement advanced machine learning techniques to solve complex data issues.
• Utilize data science and visualization toolkits to support business decisions.
• Conduct quantitative analysis and interpret statistical data to identify trends and patterns.
• Research, configure, test, and maintain new and existing data systems.
• Design and implement interfaces between database systems and optimize performance through routine maintenance.
• Manage user permissions and enforce data quality standards.
• Provide technical support and project management including planning, timeline guidance, and risk management.

Required Qualifications

• Proven knowledge of complex information system design, analysis, and documentation.
• Experience supporting IT infrastructures that include technical services, data & analytics, GIS, or enterprise applications.
• Expertise in technologies such as SQL Server, Reporting Services, Crystal Reports, Cognos, Power BI, SQL Server Integration Services, RESTful API, ColdFusion, IIS, HTML, CSS, and JavaScript.
• Ability to analyze, design, program, document, and maintain complex computing systems.
• Bachelor’s degree in Computer Science, Management Information Systems, or a closely related field is required.
• For Specialist I: a minimum of two years of professional experience; for Specialist II: four years of professional experience in computer technology.
• Must possess a valid California driver’s license if driving is an essential function.
• Cisco and/or Microsoft® certifications are preferred.

Preferred Qualifications

• Preference will be given to candidates with a BS in Computer Science or related degree and four or more years of professional experience in reporting, data integrations, and application development within a local government agency.