Systems Application Analyst

Position Type: Contract

Duration: 6 months

Location: Candidate must be local to TN - Hybrid

Position Overview: This role provides primary application support for City Works and related systems used by select general government departments. The analyst will support users, test and troubleshoot applications, develop reports and SQL queries, and contribute to enterprise application projects.

Key Responsibilities: Provide primary application support for City Works and related systems. Develop test plans and test cases, execute application testing, and troubleshoot City Works and related systems. Perform business and project analysis activities, including work plan input, deliverable definition and tracking, status reporting, user meetings, and preparation of application requirements and specifications. Create and modify reports and forms in Crystal Reports, and write SQL queries using City Works and Land Management data. Coordinate and communicate with process owners, users, departments, the ITS technical team, consultants, and other team members. Produce SQL data extracts in response to user and public requests. Support issue resolution, system enhancements, upgrades, and conversions. Coordinate and conduct end-user training, including preparing and updating training materials.

Qualifications: Experience configuring and supporting City Works. Experience with Crystal Reports and SQL queries. Experience with SQL Server Management Studio (SSMS).Experience writing SQL queries to update or extract data from a SQL database. Experience as a systems analyst supporting users, issue resolution, system enhancements, upgrades, and conversions. Experience coordinating and conducting end-user training and preparing or updating training materials; implementation training rollout experience is a plus. Experience with Microsoft Office Suite. We are an Equal Opportunity Employer and provide equal employment opportunities to all employees and applicants without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, or any other status protected by applicable federal, state, or local law. Applicants who require a reasonable accommodation to participate in the application or interview process should contact Human Resources.