Information Technology Specialist I/II - Data & Development Services

The City of West Sacramento is hiring an Information Technology Specialist I/II with an emphasis on Data and Development Services.  The position will report to the Data Services Manager in the City Manager's Office.  The IT Specialist I/II will be responsible for working with the various City departments to identify reporting requirements, create new reports, and maintain existing reports.  This position will also work with third-party application vendors to integrate data between the City's computer applications and provide development and maintenance support for in-house and third-party software applications.

Preference will be given to candidates who have a BS in Computer Science or related degree and 4 or more years of professional experience in the areas of Reporting, Data Integrations, and Application Development for a local government agency.  The ideal candidate should be skilled in the following technologies: SQL Server, Reporting Services, Crystal Reports, Cognos, Power BI, Excel/CSV Files, SQL Server Integration Services, RESTful API, ColdFusion, IIS, HTML, CSS, and JavaScript.

The Information Technology Specialist I/II performs a variety of professional level work in designing, installing, managing, updating, integrating and securing Information Technology systems; provides professional level analysis and guidance to help solve business problems; operates computer equipment as required; and provides functional and technical assistance to City personnel.

make reasonable accommodations so that qualified employees can perform the essential functions of the job.

Data & Analytics

• Design, develop, test, and implement software applications and systems.
• Analyze, debug, and maintain existing applications.
• Administer database management system, schedule upgrades and monitors systems.
• Design, update and install databases for new systems.
• Work with business stakeholders to modify and enhance existing reports.
• Design, develop, and test reports using report writing tools.
• In-depth understanding and experience with SQL.
• Perform data mining using state-of-the-art methods.
• Knowledge of and experience with implementing machine learning techniques and algorithms to solve complex data related problems to help drive business needs.
• Knowledge of and experience with using data science and visualization toolkits to help drive business related decisions.
• Conducting deep quantitative analysis to understand the strengths and weaknesses of datasets and identify the root causes of complex social and economic problems
• Interpret data and analyze results using statistical techniques including, but not limited to, distributions, statistical testing, and multiple regression.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Research, plan, install, configure and test new data related systems; maintain and upgrade existing systems.
• Design and implement interfaces between database systems.
• Optimize database systems by performing routine maintenance procedures.
• Create and maintain user permissions, system privileges, passwords and other security methods for securing access to database systems.
• Provide technical support in the planning of new database systems including hardware, operating systems, licensing and storage requirements for new systems.
• Enforce data quality standards and perform quality control checks on associated data.
• Monitor database performance against established standards; detect and troubleshoot problems.
• Provide advanced level support for the data, analysis and database related issues. 
• Coordinate assigned functions with and provide support to other departments, other jurisdictions and agencies, and the general public; conduct user training on group or individual basis as needed; advise and train information systems personnel on database issues.
• Partner with City departments and provide database solutions to meet business needs; integrate database solutions with other City enterprise solutions.
• Knowledge of extract, transform and load (ETL) tools and methodologies.
• Assist in the development and maintenance of database policies and procedures.
• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
• Acquire data from primary or secondary data sources and maintain databases/data systems.
• Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
• Work with management to prioritize business and information needs.
• Locate and define new process improvement opportunities
• Provide project management; develop project plans and detailed project objectives; develop and guide project timelines; assess and manage risks; manage issues.

An applicant who qualifies for veterans’ preference and successfully places on an eligibility list for initial entrance into employment with the city shall be advanced one rank on the final eligibility list. Where there are five (5) or less qualified applicants, no veterans’ preference shall apply and all applicants shall be placed on the certification list forwarded to the departments for hiring consideration. The exercise of veterans’ preference shall be exhausted upon appointment to a regular position from an eligibility list.

An official City of West Sacramento application form must be filled out, in its entirety. It is the applicant's responsibility to explain their qualifications fully and clearly. In addition, applicants must submit a resume and complete the required supplemental questionnaire (if applicable). Incomplete information on the application, resume and/or supplemental questionnaire may be cause for disqualification. Application packages will be reviewed and screened for qualifications. Additional screening criteria will be developed based on the supplemental questionnaire (if applicable).  

• 

• City of West Sacramento

• 9166174567