CityWorks Applications Analyst II — SQL & Crystal Reports

Mavensoft Technologies, LLC.; Nashville (TN); On-site; USD 60,000 - 90,000; Full time

Job summary

Mavensoft Technologies, LLC. seeks an Information Systems Applications Analyst 2 to provide CityWorks and related enterprise application support in Nashville. You will perform testing, troubleshoot issues, and participate in business and systems analysis activities.

Responsibilities include creating reports with Crystal Reports, writing SQL queries, coordinating with ITS teams, and assisting with training and deployment of applications. Strong communication and documentation skills are essential.

Qualifications

• 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.

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.

Skills

CityWorks

Crystal Reports

SQL

Enterprise application support

Tools

SSMS

Job description

Mavensoft Technologies, LLC. seeks an Information Systems Applications Analyst 2 to provide CityWorks and related enterprise application support in Nashville. You will perform testing, troubleshoot issues, and participate in business and systems analysis activities.

Responsibilities include creating reports with Crystal Reports, writing SQL queries, coordinating with ITS teams, and assisting with training and deployment of applications. Strong communication and documentation skills are essential.