Systems Analyst I / II / III

Job Description

***NOTE*** To be considered for this position, please apply at the Skagit County Job Opportunity site:

http://agency.governmentjobs.com/skagitwa/default.cfm

 

SUMMARY

The position is responsible for the development, implementation, management and maintenance of County databases. Skagit County utilizes a development environment consisting of object oriented development languages with Microsoft SQL Server database engines within a Microsoft Windows environment. This is a team oriented position, working with departmental and Information Technology staff in a role that requires the ability to analyze business processes, design, code, test, document, deploy, and maintain reliable software systems adhering to County software development standards.

 

– Salary upon hire for Systems Analyst I is $39.88 to $42.72 per hour (step 1 through 3) depending upon qualifications.

– Salary upon hire for Systems Analyst II is $45.79 to $49.05 per hour (step 1 through 3) depending upon qualifications.

– Salary upon hire for Systems Analyst III is $49.05 to $52.52 per hour (step 1 through 3) depending upon qualifications.

– Progressive increases are based upon years of service with Skagit County, up to step 10 (top step is $53.02/hr. for Systems Analyst I; $60.86/hr. for Systems Analyst II; $65.22/hr. for Systems Analyst III). The Systems Analyst I/II/III are Range 18/20/21 of the Non-rep salary schedule.

 

Essential Functions

System architecture and design

• Work with end users and department management to build complete solutions: Analyze the needs of the user. Design, test and develop the software to meet those needs.
• All phases of the development cycle from initial planning to maintenance and enhancement
• Integration between systems, vended and internal
• Recommend upgrades for existing systems and programs.
• Develop separate elements of a software that work well in the program as a whole.
• Create various diagrams, flowcharts and models that illustrate the type of code needed for programmers.
• Ensure continued functionality of a program during maintenance and testing of software.
• Document each aspect of a system or application as a reference for future upgrades and maintenance.
• Revisit the development process to fix bugs or address client or consumer concerns.
• Monthly Microsoft OS patching of database servers

 

Database management

• Design, develop, test, deploy and support internal software
• Applications from moderate to high complexity integrating between vendor and internal software.
• Specific deliverables include database design and implementation; development of server software – C# and ASP.net, development of client software – JavaScript, JQuery, JQuery Mobile, HTML, XML and CSS.
• Integrate with other applications, internal and external using web services, file transfers and direct connection to databases.

 

Software Architecture

• Responsible for developing strategy and implementation of new architecture for existing software including: Streamlining nightly process; moving to service oriented architecture; consolidating data storage and associated processes.
• Develop standards for vendor software, including platform and integration capabilities.
• Develop prototype software using: Power BI; Mapping Software.
• Design and develop databases, front end applications for data entry, and web based solutions that provide access to county data for both internal departments and the public using Microsoft technology such as SQL Server, Windows Forms, ASP.NET and Dynamic Link Libraries. Provide application security best practices as needed to protect county resources and data. Develop applications and interfaces that utilize a centralized data approach to automate department processes. Provide documentation, testing and training on the delivered applications.
• Assist with network administration of the Web based or client/server applications in order to maintain optimal performance and security.
• Must be able to provide extended or off shift support during critical processing periods. Ability to travel for training and/or County purposes is required. Must have a positive customer service orientation.

 

SUPERVISORY:

This position has no supervisory responsibilities.

 

Performs related duties as assigned. Related duties as required are duties that may not be specifically listed in the Position Description but are within the general occupational series and responsibility level typically associated with the employee’s classification of work.

 

***NOTE*** To be considered for this position, please apply at the Skagit County Job Opportunity site:

http://agency.governmentjobs.com/skagitwa/default.cfm

 

Minimum Qualifications

A Bachelor’s degree with an emphasis in Computer Science or a related field required.

System Analyst I

At least 1 (one) year experience in systems analysis, applications and systems design, development, documentation, and testing of applications including at least 1 year experience in Web-based applications.

System Analyst II

At least 3 (three) years’ experience in systems analysis, applications and systems design, development, documentation, and application testing. Demonstrable proficiency in client server and Web-based applications development.

System Analyst III

At least 5 (five) years’ experience in systems analysis, applications and systems design, development, documentation, and application testing. Demonstrable proficiency in development of client server and Web-based applications that have been in use over multiple years.

An equivalent combination of education and experience may be substituted which provides the skills, knowledge, and abilities to perform the essential functions of the position

 

Requires knowledge of:

·         Microsoft SQL Server, database models, structured query language

·         Administration of MS SQL Server

·         Microsoft Visual Studio and C#

·         Object Oriented Analysis and Design, software testing

·         Microsoft .net Technologies, ASP.net

·         Creating Shared Dynamic Link Libraries and web services

·         Javascript, jQuery, XML, XSL, CSS and HTML

·         Web and n-tier development

·         Application security best practices and testing

·         Configuration of Microsoft Internet Information Server (IIS)

·         Development and design of relational databases tables, views, procedures, triggers and scripts.

·         Development of applications on a wide range of devices including mobile devices.

·         Imaging technologies including scanners, digital cameras, software libraries to access scanners, Optical Character Recognition (OCR) technologies, image file formats including tiff, pdf, and jpeg, and standard practices for capturing and providing access to scanned images.

Requires the ability to:

·         Use of source control configuration and code management software

·         Troubleshoot hardware and software problems.

·         Install and configure vended applications as required.

·         Keep up to date with new technologies by reading of trade periodicals, being involved in Internet news, support groups and attend additional training as needs arise

·         Communicate effectively with users and work independently within departmental objectives.

 

Licenses and/or Certifications:

Valid Washington State driver’s license required.

 

Special Clearances:

Employee will be required to pass a state of residency fingerprint background check to be completed within thirty (30) days of employment with Skagit County.

 

WORKING CONDITIONS/PHYSICAL REQUIREMENTS:

Work is performed primarily in an office environment. Long periods of sitting are required. Eye hand coordination and finger dexterity to manipulate a keyboard is required. Ability to lift weights in excess of 50 pounds to install server equipment required. Must be able to travel to County work locations and work emergency hours as required.

 

Hazards:

Those present in a normal office environment. Potential exposure to chemicals routinely encountered in computer repair and soldering, dust and dirt, possible technological equipment failure resulting in electric shock and/or noxious fumes.