UMS Business Analyst

City of Charlotte•Charlotte, NC

17d

About The Position

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 C ommensurate with experience"

Requirements

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 PowerBI 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 complex information systems problems
Support organizational goals and objectives
Understand and carry out oral and written directions
Review technical documents and templates and suggest revisions
High School Diploma or equivalent
Five (5) years of experience in business analysis, requirements definition, and information technology support
Associate’s degree from an accredited college or university in Information Technology, Computer Science
Three (3) years of experience in business analysis, requirements definition, and information technology support
Bachelor’s Degree from an accredited college or university in Information Technology, Computer Science
Two (2) years of experience in business analysis, requirements definition, and information technology support

Nice To Haves

Minimum of three years of utility billing system support
Experience supporting customer information system support functions

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 PowerBI dashboards.
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.
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.

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume