Programmer Analyst I (Planning & Development)

Shelby County TN; Memphis (TN); On-site; USD 65,000 - 90,000; Full time

Job summary

Shelby County TN is hiring a data solutions specialist to develop, maintain, and optimize SQL scripts and Crystal Reports for our division. You will support data management and reporting needs, translating business requirements into technical solutions and ensuring timely delivery.

The role requires collaboration with analysts, developers, and stakeholders, with a focus on reliability, scalability, and clear documentation. A strong background in civic tech or similar platforms is preferred.

Qualifications

• Three years of experience in application development or systems analysis, with at least 1 year supporting Accela or similar civic tech.
• Bachelor's degree in CS/SE/IT or related field, or equivalent programming experience.
• Proof of education, training, and/or experience is required.

Responsibilities

• Performs complex programming tasks, including designing, documenting and coding logic for enterprise databases.
• 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.
• Designs, tests, and deploys integrations with third-party systems (payments, GIS, document management, notifications).
• Translates product requirements into detailed technical specifications and software development plans.
• Ensures programming meets customer requirements and is completed on schedule.
• Monitors system performance and proposes improvements to reduce errors and improve usability.
• Maintains documentation of configurations, processes, and user manuals.
• Supports release management and testing during upgrades or patches.

Skills

SQL

Crystal Reports

JavaScript

Accela scripting APIs

Data analysis

Education

Bachelor's degree in CS/SE/IT or related field

Equivalent programming experience

Tools

GitHub

AWS

Azure

Databases

Job description

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

Pay Grade: 52

Salary

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.