Programmer Analyst I (Planning & Development)

Shelby County•Memphis, TN

5d•$49,375 - $66,633

About The Position

Works under 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 also handles enterprise database programming, custom scripts and reports, data analysis, integrations, platform upgrades, and related technical documentation and support.

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.
A 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.
Proof of education, training, and/or experience is required.
Proficiency writing clean, scalable, and efficient code using languages and tools 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 ensure they operate as expected, meet requirements, and are free of bugs.
Familiarity with cloud platforms and cloud-based solutions such as AWS and Azure, and 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.
Ability to understand user requirements and business processes to develop effective software solutions.
Strong problem-solving skills and 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 and communicate at a business level with users.
Ability to stay current with industry trends, programming changes, and emerging technologies and apply them as appropriate.
Shelby County residency is required for employees hired after September 1, 1986, subject to the stated public safety/civil service exemptions.

Nice To Haves

Experience using Accela Scripting APIs is highly desirable.

Responsibilities

Design, document, and code program logic for enterprise database systems.
Develop, configure, test, debug, and maintain custom scripts.
Create custom reports from databases 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 or refinements 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 to provide technical input and ensure alignment with project goals.
Perform other related duties as required or directed.