Programmer Analyst I (Planning & Development)

Shelby County Government•Memphis, TN

About The Position

The Programmer Analyst I works under the general supervision of the Manager of Business and Technology Services to develop, maintain, and optimize SQL scripts and Crystal Reports supporting the division’s data management and reporting needs. The role performs complex programming work for enterprise database systems, develops and maintains custom scripts, creates database reports, and supports data analysis, dashboards, and business intelligence needs. The position also designs and deploys integrations with third-party systems, translates product requirements and user stories into technical specifications and software development, and helps ensure solutions meet customer requirements and schedules. It monitors system performance, maintains technical documentation, and supports release management and testing for platform upgrades and patches. The Programmer Analyst I collaborates with business analysts and participates in reviews, planning sessions, and project meetings. The role is subject to a background check for convictions substantially related to its duties. Employees hired after September 1, 1986, must reside in Shelby County as a condition of employment, subject to the stated exceptions.

Requirements

Three years of experience in application development or systems analysis, including at least one year supporting Accela or a similar civic technology platform; or an equivalent combination of related education and/or experience.
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.
Strong proficiency writing clean, scalable, and efficient code in languages and formats such as JavaScript, JSON, SQL, and Crystal Reports, and following best programming practices.
Ability to create and manage systems and applications by writing code.
Ability to troubleshoot software issues, identify root causes, and implement fixes.
Ability to debug, troubleshoot, and test software systems to confirm they meet requirements and operate as expected without bugs.
Understanding of database management systems.
Ability to analyze and evaluate existing software applications and identify areas for improvement or enhancement.
Ability to understand user requirements and business processes and develop effective software solutions.
Solid problem-solving skills and ability to troubleshoot complex business issues.
Ability to work independently or collaboratively in a team environment.
Ability to communicate technical information to peers and at a business level with users.
Keeps up to date with industry trends, programming changes, and emerging technologies and applies them as appropriate.

Nice To Haves

Experience using Accela Scripting APIs is highly desirable.
Familiarity with cloud platforms and cloud-based solutions such as AWS or Azure.
Experience with version control systems such as GitHub.

Responsibilities

Design, document, and code program logic for enterprise database systems.
Develop, configure, test, debug, and maintain custom scripts.
Create custom database reports using report-writing tools.
Perform data analysis, queries, and extraction using SQL and Crystal Reports to support reporting, dashboards, and business intelligence needs.
Design, test, and deploy integrations with third-party systems such as payment gateways, GIS, document management systems, and email/SMS notifications.
Translate product requirements and user stories into detailed technical specifications and software development.
Ensure programming meets customer requirements and is completed on schedule.
Monitor system performance and recommend improvements to reduce error rates and improve usability.
Maintain documentation of configurations, technical processes, and user manuals.
Support release management and testing during platform upgrades or patch deployments.
Collaborate with business analysts to gather and clarify requirements and ensure technical solutions meet business needs.
Participate in software reviews, planning sessions, and meetings, providing technical input and supporting alignment with project goals.
Perform other related duties as required or directed.