UMS Business Analyst

Date Opened:
Tuesday, January 27, 2026 12:00 AMClose Date:
Wednesday, February 11, 2026 12:00 AM Department:
Charlotte Water Department Salary: $71,878.00 - $89,847.00 Commensurate with Experience
** Welcome to the City of Charlotte
** Charlotte is America’s Queen City, opening her arms to a diverse and inclusive community of residents, businesses and visitors alike. Here you will find a safe, family-oriented city where people work together to help everyone thrive. The mission of the City of Charlotte is to deliver quality public services and promote the safety, health, and quality of life for all residents.

Our guiding principles include:
* Attracting and retaining a skilled and diverse workforce
* Valuing teamwork, openness, accountability, productivity, and employee development
* Providing all customers with courteous, responsive, accessible, and seamless quality services
* Taking initiative to identify, analyze, and solve problems
* Collaborating with stakeholders to make informed decisions
** SUMMARY
* * The Center for Digital Government named Charlotte one of the top five digital cities in the nation. The City of Charlotte Innovation & Technology department (I&T) provides executive-level leadership, delivers technology services to city departments and partner agencies, and coordinates information technology initiatives across the organization to support, enhance and advance citizen service delivery. Charlotte Water Technology is a division of the I&T Department and directly supports Charlotte Water.
As an application expert on the Utility Management Systems (UMS) support team, the Business Analyst (BA) provides operational user support, application data analysis, business process improvement, and analytical support for enterprise applications at various locations. The core applications currently supported are the Hansen Banner customer information system, the self-service web portal, Itron Field Collection System and ABB Service Suite mobile workforce management system for water, sewer, and storm water utility services.

The BA will conduct other tasks as specified by UMS program leaders and supervisors.
** The salary for this position is $80,862.30 - $89,846.99 Commensurate with experience"**#
** ESSENTIAL DUTIES & RESPONSIBILITIES
*** Provide technical application support of enterprise applications at various locations.
* Interface with department stakeholders and end users to define needs, communicate technology changes, and fulfill technology support requests.
* Conduct application testing in a highly collaborative environment. Document test results and communicate results to vendor and technical resources for corrections.
* Based on stakeholder requirements, develop SSRS reports and Power

BI dashboards.
* Write and optimize Oracle SQL (joins, filters, aggregations; PL/SQL) to build datasets for SSRS and Power

BI, support ad‑hoc analysis, and validate data across business systems.
* Conduct usage and system problem analysis and resolution at local and remote locations. Develop and document the problem resolution with internal and external technical resources.
* Interface with end users on existing business processes and design for new business processes to be translated and written into detailed functional requirements and solution designs.
* Build and maintain a detailed understanding of back-office business processes, system functionality, and related requirements.
* Write user guides and work aids.
* Update and troubleshoot PL/SQL and Python scripts to support data analysis and reporting requirements.
* Maintain a report catalog and data dictionary; administer SSRS subscriptions and BI access; apply appropriate data access controls and documentation standards.
* Perform related work as required.
** Required Skills, Knowledge and Abilities:**## Knowledge of:
* Tactics and practices of business analysis
* Principles of robust software testing approaches
* System life cycles and systems development
* Department, section, and team goals and objectives
* Information technology best practices, standards, and terminology
** Skill in:
*** Analysis and troubleshooting of an integrated software application
* Troubleshooting application issues using SQL query tools and MS Excel, to prove a hypothesis
* Authoring Oracle SQL statements for business analysis and data validation; ability to build complex joins, sub-queries, and unions
* SSRS report development and Power

BI dashboard development
* Scripting for customizations, automations, and data tasks (PL/SQL and Python)
* Writing and executing structured test plans
* Interpreting functional and technical requirements for both real-time and batch application interfaces
* Interpersonal skills necessary to develop and maintain effective and appropriate working relationships
* Customer service
* Organization and time management
** Ability to:
*** Understand and follow technical design specifications
* Communicate technical topics to all levels of technology users
* Devise procedures to solve moderately…