Programmer Analyst II (Sheriff)

Position Summary

Works under minimal supervision of an assigned supervisor or team leader to mine data for analysis and convert business problems to detailed reports, logical flowcharts, and code into computer language in the Shelby County Sheriff’s Office.

Pay Grade: 54

Salary Commensurate with Experience and Education

Minimum Qualifications

• Two (2) years of application development experience on Windows-based and/or UNIX/Linux-based computer systems; AND
• Associate’s degree from an accredited college or university in information technology, computer engineering technology, or other computer science related degree; OR
• An equivalent combination of related education and/or experience.
• Knowledge and/or experience with relational databases, SQL, JAVA, HTML, Java Server Pages, Servlets, JavaScript, and application servers is preferred.
• PROOF OF EDUCATION, TRAINING, AND/OR EXPERIENCE IS REQUIRED.

Duties and Responsibilities

• Prepares and documents functional, test, program, and data record specifications.
• Prepares reports, views, system flow charts and logic diagrams describing existing and proposed application programs and systems.
• Codes, debugs, documents, tests application programs, and prepares system test scripts.
• Performs data mining of various application databases to support analysis of data and GIS functions.
• Reviews developed application programs and system test results with Analysts and/or customers.
• Performs unit and system-level testing in accordance with established procedures.
• Consults with system users and development groups on test results.
• Participates in all phases of application preparation for real time, online, or batch systems.
• Works on functional specifications for slightly complex systems or scenarios with technical direction from senior staff.
• Performs other related duties as required or directed.

KSAs

• Knowledge of hardware, software, and systems application development techniques using SQL and Java or .NET.
• Knowledge of ESRI Mapping Software products for implementation, design and maintenance.
• Knowledge of web technologies to maintain and develop web sites.
• Knowledge of Crystal Reports and SQL Views.
• Ability to apply technical knowledge and computer science principles in the design of major software systems.
• Ability to interpret and convert business problems to computer language.
• Knowledge of business theory and principles, and ability to understand business problems and devise appropriate computer-based solutions.
• Knowledge of test procedures and documentation standards and the application of same to all system designs.
• Ability to communicate technical information to peers, as well as communicate at a business level with users.
• Knowledge of Windows operating system and optionally UNIX operating systems.

Special Requirements

• Must possess a valid Tennessee driver’s license or secure one by date of employment.
• Must be able to obtain and maintain a TIES (Tennessee Information Enforcement System) certification.

Disclaimer

This position is subject to a background check for any convictions that have a substantial relationship to potential job duties. Only convictions that are substantially related to potential job duties will be considered and will not automatically disqualify the candidate.

Shelby County Resident Disclaimer

All employees hired after September 1, 1986, must be residents of Shelby County and shall continue to reside in the County as a condition of their employment. The residency requirement shall not apply to certain public safety/civil service employees. This means exemption from this policy is in effect for the following departments and positions: (1) Sheriff Deputy Patrol Officers, Deputy Jailers and Dispatchers, employed by the Sheriff Department, (2) Correction Officers employed by the Division of Corrections, (3) Firefighters, Paramedics and Dispatchers employed by the Shelby County Fire Department. The residency exemption for public safety/civil service employees does not include Appointed positions with Sheriff’s Office, Division of Corrections or the Fire Department.