Programmer Analyst I (Planning & Development)

Position Summary

Works under general supervision of the Manager of Business and Technology Services to develop, maintain, and optimize SQL scripts and Crystal Reports to support our division’s data management and reporting needs.

Pay Grade: 52

Salary Commensurate with Experience and Education

Minimum Qualifications

• Three (3) years of experience application development or systems analysis, with at least 1 year supporting Accela or a similar civic tech platform; AND
• Bachelor's degree from an accredited college or university in Computer Science, Software Engineering, Information Technology, or a closely related field or comparable programming experience or a closely related field; OR
• An equivalent combination of related education and/or experience.
• PROOF OF EDUCATION; TRAINING; AND/OR EXPERIENCE IS REQUIRED.

Duties and Responsibilities

• Performs a variety of complex programming tasks, such as designing, documenting and coding program logic for enterprise database systems.
• Develops, configures, tests, debugs and maintains custom scripts.
• Provides custom reports from databases using report-writing tools.
• Performs data analysis, queries, and extraction using SQL and Crystal reports to support reporting, dashboards, and business intelligence needs.
• Designs, tests, and deploys integrations with third-party systems (e.g., payment gateways, GIS, document management systems, email/SMS notifications).
• Translates product requirements & user stories to detailed technical specifications and software development
• Ensures that programming meets customer requirements and is completed on schedule.
• Monitors system performance and recommends improvements or refinements to reduce error rates and improve usability.
• Maintains clear documentation of configurations, technical processes, and user manuals.
• Supports release management and testing activities during platform upgrades or patch deployments.
• Collaborates with business analysts to gather and clarify requirements, ensuring that technical solutions meet the needs of the business.
• Participates in software reviews, planning sessions, and meetings to provide technical input, insight, and ensure alignment with project goals.
• Performs other related duties as required or directed.

KSAs

• Strong proficiency writing clean, scalable, and efficient code in programming languages such as of JavaScript, JSON, SQL, and Crystal Reports and following best programming practices; experience using Accela Scripting APIs is highly desirable.
• Ability to create and manage systems and applications by writing code.
• Ability to troubleshoot and resolve software issues by identifying root causes and implementing fixes.
• Ability to perform debugging, troubleshooting, and testing to ensure software systems operate as expected, meet requirements, and are free of bugs.
• Familiarity with cloud platforms and cloud-based solutions (AWS, Azure) as well as experience with version control systems such as GitHub.
• Understanding of database management systems.
• Experience analyzing and evaluating existing software applications to identify areas for improvement or enhancement.
• Understands user requirements and business processes to develop effective software solutions.
• Solid problem-solving skills and the ability to troubleshoot complex business issues.
• Ability to work independently or in a team environment with strong collaboration skills.
• Ability to communicate technical information to peers, as well as communicate at a business level with users.
• Remains updated with the latest industry trends, changes in programming, and emerging technologies, applying them as appropriate.

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.