CityWorks Analyst - Crystal Reports, SQL

Mavensoft Technologies.•Nashville, TN

7d•Hybrid

About The Position

Our Client is seeking an Information Systems Applications Analyst 2 to provide application support for CityWorks and related enterprise applications. The role will involve application support, testing, troubleshooting, business and systems analysis, SQL data extraction, Crystal Reports development, and coordination with users and technical teams. The ideal candidate Should have hands-on experience with CityWorks, Crystal Reports, SQL, SQL Server Management Studio (SSMS), and enterprise application support.

Requirements

Experience with CityWorks configuration and application support.
Experience with Crystal Reports and report development/modification.
Strong experience writing SQL queries.
Experience with SQL Server Management Studio (SSMS).
Experience writing SQL queries to update or extract data from SQL databases.
Experience as a Systems Analyst/Application Analyst supporting enterprise applications.
Experience troubleshooting and resolving end-user application issues.
Experience supporting system enhancements, upgrades, and conversions.
Experience with application testing, including test plans, test cases, and test execution.
Experience gathering and documenting application requirements and specifications.
Experience coordinating with business users, technical teams, and other stakeholders.
Experience conducting end-user training and preparing/updating training materials.
Experience with Microsoft Office Suite.
Strong communication, coordination, documentation, and analytical skills.

Nice To Haves

Experience supporting CityWorks and Land Management data.
Experience with enterprise-wide application implementations.
Experience creating SQL-based data extracts for business or public requests.
Experience supporting an implementation training rollout.

Responsibilities

Provide primary application support for CityWorks used by general government departments.
Perform application testing, including developing test plans/test cases and executing tests.
Troubleshoot issues related to CityWorks and associated systems and applications.
Perform business analysis activities for enterprise-wide applications.
Assist with work plan input, deliverable definition and tracking, and status reporting.
Conduct user-level meetings to gather requirements and address application needs.
Create and modify reports and forms using Crystal Reports.
Write SQL queries using CityWorks and Land Management data.
Perform project analysis activities for enterprise application projects.
Prepare application requirements and specifications.
Coordinate with process owners, end users, departments, ITS technical teams, consultants, and other stakeholders.
Perform SQL data extracts based on user and public requests.
Support system enhancements, upgrades, conversions, and issue resolution.
Coordinate and conduct end-user training.
Prepare and update user training materials.
Support application implementation and training rollout activities.