CityWorks Analyst - Crystal Reports, SQL

Mavensoft Technologies, LLC; Nashville (TN); On-site; USD 70,000 - 100,000; Full time

Job summary

Mavensoft Technologies, LLC is seeking an Information Systems Applications Analyst 2 to provide CityWorks and enterprise application support, testing, troubleshooting, and reporting using Crystal Reports and SQL.

The role involves coordinating with users and technical teams, performing data extraction, and preparing training materials for end-user rollout.

Qualifications

• Experience with CityWorks configuration and application support.
• Experience with Crystal Reports and report development/modification.
• Experience with SQL Server Management Studio (SSMS).
• Experience writing SQL queries to update or extract data.
• Experience as Systems Analyst/Application Analyst for enterprise applications.
• Experience with 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 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

SQL queries

Business analysis

End-user training

Documentation

Communication

Tools

Crystal Reports

SQL Server Management Studio (SSMS)

CityWorks

Job description

CityWorks Analyst - Crystal Reports, SQL

Job Description

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.

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.

Required Qualifications

Experience with CityWorks configuration and application support.

Experience with Crystal Reports and report development/modification.

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.

Preferred Qualifications

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.