UMS Business Systems Analyst

charlottenc; Charlotte (NC); On-site; USD 87,000 - 97,000; Full time

Job summary

The City of Charlotte, through the Innovation & Technology department, is seeking a Business Analyst to support the Charlotte Water enterprise applications and utility management systems. You will partner with stakeholders to analyze needs, translate requirements into technical specs, and help deliver data-driven solutions for customer service and operations.

Responsibilities include SQL reporting, data validation, and creating dashboards with Power BI/SSRS; you will participate in SDLC

Qualifications

• Experience supporting enterprise applications and SDLC
• Knowledge of CIS, MWM, EAM, GIS or related utilities preferred
• Experience with testing and data validation
• Ability to translate business requirements into technical specs

Responsibilities

• Provide functional and technical support for mission-critical enterprise applications
• Collaborate with stakeholders to elicit, analyze, and prioritize requirements
• Write and optimize SQL for data sets and reporting validation
• Develop reports and dashboards using Power BI and SSRS
• Coordinate UAT, test plans, and defect tracking
• Support system enhancements, upgrades, and deployments

Skills

Business analysis

Agile methodology

SQL queries

Data analysis

Reporting design

User acceptance testing

Documentation

Communication

Education

Bachelor’s degree in Information Technology, Information Systems, Computer Science, or related field

High school diploma or GED

Associate degree in IT, CS, or related field

Tools

Oracle SQL

Power BI

SSRS

Azure DevOps

Jira

PL/SQL

Job description

Department: Charlotte Water Department

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.

This BA partners closely with business stakeholders, technical teams, vendors, and project leaders to analyze business needs, improve business processes, support enterprise applications, and deliver technology solutions that enhance operational efficiency and customer service. The Business Analyst is responsible for requirements gathering, business process analysis, application support, data analysis, testing, documentation, and continuous improvement efforts throughout the software development lifecycle (SDLC). The role also serves as a liaison between business and technical teams, ensuring that business requirements are translated into effective technology solutions while maintaining the reliability and performance of mission-critical utility systems.

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, SKILLS & ABILITIES:

Knowledge of:

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

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

HOW TO APPLY

Apply online.

Federal law requires employers to provide reasonable accommodations to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job.

You are welcome to visit the City of Charlotte Human Resources Department lobby, where self-service application kiosks are available. They are located in our office at 700 East 4th Street, Suite 200, Charlotte, NC 28202. We are open Monday through Friday, from 9:30 a.m. to 3:30 p.m. (EST), excluding official City holidays.

For questions about your application or the hiring process, please email [e-mail]

The City of Charlotte is committed to making our services and programs accessible to all. Upon request, auxiliary aids, written materials in alternate formats, language access, and other reasonable accommodations or modifications will be provided. To make a request, please fill out the Innovation & Technology ADA request form or call 704.336.4120.

BENEFITS

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.