UMS Business Systems Analyst

City of Charlotte; Charlotte (NC); On-site; USD 77,000 - 111,000; Full time

Benefits offered by this job

Comprehensive benefits

Drug-free workplace

Job summary

The City of Charlotte, through the Charlotte Water Department, seeks a skilled Business Analyst to support mission-critical enterprise applications including CIS, field systems, and reporting tools.

The BA will analyze business processes, write requirements, perform UAT, develop reports with Power BI/SSRS, and collaborate with stakeholders to deliver solutions that improve efficiency and customer service.

Qualifications

• Bachelor's degree or higher in IT or related field.
• 3+ years progressive experience in business analysis or systems analysis.
• Experience with CIS, utility technologies, or public-sector IT preferred.
• Experience with Oracle SQL and data validation a plus.

Responsibilities

• Provide functional and technical support for enterprise applications at Charlotte Water facilities.
• Analyze and resolve system problems; coordinate with internal teams, vendors, and partners.
• Elicit, document, validate, and prioritize business and technical requirements.
• Develop and maintain UMS knowledge, process maps, and user guides.
• Develop reports and dashboards using Power BI/SSRS and validate data across systems.

Skills

Business analysis

Agile

SQL

Power BI

Education

Bachelor's degree in Information Technology or related field

Tools

Azure DevOps

Jira

Power BI

SSRS

Job description

Department: Charlotte Water Department

Salary: $77,358.00 - $111,201.54 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 has recognized the City of Charlotte as one of the nation’s leading digital cities. The Innovation & Technology (I&T) Department provides executive-level technology leadership, delivers enterprise technology services to City departments and partner agencies, and advances innovative solutions that enhance operational excellence and customer service. Charlotte Water Technology, a division of the I&T Department, provides technology leadership and support for Charlotte Water’s mission-critical business systems that enable the delivery of water, wastewater, and stormwater services to the community. The Business Analyst (BA) serves as a functional and technical expert on the Utility Management Systems (UMS) team, supporting a portfolio of enterprise applications including the Hansen Banner Customer Information System (CIS), customer self-service portal, Itron Field Collection System, Hitachi Service Suite Mobile Workforce Management, and related utility applications.

The salary for this position is $87,027 - $96,696 commensurate with experience.

Major Duties And Responsibilities

• Provide functional and technical support for mission-critical enterprise applications at multiple Charlotte Water facilities.
• Conduct system problem analysis and resolution at local and remote locations. Research, document, and coordinate problem resolution with internal technical teams, vendors, and external support partners.
• Partner with business stakeholders to elicit, analyze, document, validate, and prioritize business and technical requirements.
• Analyze existing business processes and identify opportunities to improve efficiency, automation, and customer service through technology solutions.
• Document business processes, workflow diagrams, user stories, use cases, functional requirements, and solution documentation.
• Build and maintain a comprehensive understanding of utility business processes, system functionality, and supporting technologies.
• Write and optimize Oracle SQL (joins, filters, aggregations; PL/SQL) to build datasets for SSRS and PowerBI, support ad‑hoc analysis, and validate data across business systems.
• Create custom report and dashboard specifications and develop reporting solutions.
• Conduct impact assessments for proposed system changes and work with stakeholders to arrive at an agreed solution.
• Active support system enhancements, software upgrades, configuration changes, deployments, and production releases.
• Analyze system integrations, application interfaces, and data flows to support business operations and technology initiatives.
• Develop, execute, and coordinate User Acceptance Testing (UAT), including test plans, test scripts, defect tracking, and validation of business requirements.
• Develop user guides, standard operating procedures, training materials, and other technical documentation.
• Support Agile project activities including regular stand‑ups, backlog refinement, sprint planning, requirements clarification, and solution validation.
• Perform related duties as assigned.

Knowledge Of

KNOWLEDGE, SKILLS & ABILITIES:

• Business analysis techniques and best practices.
• Agile system development processes.
• Business process analysis, process improvement, and requirements management.
• Relational database concepts, data mapping, APIs, web services, and interface technologies.
• Software testing methodologies, including User Acceptance Testing.
• Information technology standards, best practices, and terminology.
• Customer service principles.

Skilled In

• Business process analysis and business requirements elicitation.
• Writing functional requirements, user stories, use cases, and acceptance criteria.
• Authoring Oracle SQL statements for business analysis and data validation; ability to build complex joins, sub-queries, and unions.
• Developing SQL queries for data validation, analysis, troubleshooting, and reporting.
• Business process modeling using Microsoft Visio, Lucidchart, or similar tools.
• Writing and executing structured test plans, test scripts, and documenting test results.
• Interpreting business, functional, and technical requirements for real-time and batch interfaces.
• Working with enterprise application integrations and data interfaces.
• Utilizing Azure DevOps, Jira, or similar work management tools.
• Developing reports and dashboards using Power BI, SSRS or similar reporting tools.
• Communicating effectively with technical and non-technical audiences.
• Delivering exceptional customer service while supporting users with varying levels of technical expertise.
• Organization, analytical thinking, problem solving, and time management.

Ability To

• Translate business needs into clear, actionable functional and technical requirements.
• Analyze complex business problems and recommend practical technology solutions.
• Understand technical design specifications and evaluate proposed system solutions.
• Communicate technical concepts effectively to users, leadership, vendors, and technical staff.
• Support organizational goals through continuous process improvement and innovation.

Preferred Qualifications

• Bachelor’s degree in Information Technology, Information Systems, Computer Science, or a related field.
• Experience supporting utility, municipal government, or public sector technologies.
• Experience with Customer Information Systems (CIS), Mobile Workforce Management, Enterprise Asset Management (EAM), GIS, or related enterprise utility applications.
• Scripting for customizations, automations, and data tasks (PL/SQL and Python).
• Experience supporting enterprise system integrations, APIs, and data interfaces.
• Experience using Azure DevOps, Jira, or similar Agile project management tools.
• Experience developing reports and dashboards using Microsoft Power BI or similar business intelligence platforms.
• Demonstrated hands‑on experience with applied AI tools such as Microsoft Copilot, ChatGPT or comparable platforms, along with practical user of generative AI to design and implement workflow automations.

Minimum Qualifications

• High school diploma or GED and three (3) of progressive experience in business analysis, systems analysis, application support, or information technology supporting mission-critical enterprise applications; OR
• Associate degree in Information Technology, Computer Science, or a related field and one (1) year of progressive experience supporting mission-critical enterprise applications; OR
• Bachelor's Level Degree

CONDITIONS OF EMPLOYMENT

The City’s Background Check Policy requires background checks to be conducted on final internal or external candidate(s) applying for any position with the City of Charlotte. The type of information that will be collected as part of a background check includes, but is not limited to: reference checks, social security verification, education verification, criminal conviction record check, and, if applicable, a credit history check, sex offender registry and motor vehicle records check.

Background checks must be in compliance with all federal and state statutes, such as the Fair Credit Reporting Act (FCRA). The checks must be consistent with the guidelines set forth by these laws requiring organizations to obtain a candidate’s written authorization before obtaining a criminal background report, motor vehicle records check or credit report; and to properly store and dispose of information derived from such reports.

Final candidates must pass a pre‑employment drug‑screening test and physical examination. During the selection process, candidates may be asked to take a skills test, and/or participate in other assessments.

The City of Charlotte is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of race, religion, color, sex, national origin, marital status, age, disability, sexual orientation, political affiliation or on the basis of actual or perceived gender as expressed through dress, appearance, or behavior.

Our culture is to serve the community honorably.

BENEEFITS

The City of Charlotte provides a comprehensive benefits package to eligible employees.

Click here to learn more about the City of Charlotte’s benefits.

The City of Charlotte is a drug and alcohol-free workplace.