City of Charlotte · 19 hours ago
UMS Business Analyst
Charlotte, NC
Full-time
Onsite
Mid Level
$72K/yr - $90K/yr
3+ years expThe City of Charlotte is a diverse and inclusive community dedicated to delivering quality public services. The UMS Business Analyst will provide operational user support, application data analysis, and business process improvement for utility management systems, ensuring effective service delivery and stakeholder collaboration.
GovernmentNon Profit
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
Qualification
Required
High School Diploma or equivalent
Five (5) years of experience in business analysis, requirements definition, and information technology support
OR 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
OR 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
Knowledge of tactics and practices of business analysis
Knowledge of principles of robust software testing approaches
Knowledge of system life cycles and systems development
Knowledge of department, section, and team goals and objectives
Knowledge of information technology best practices, standards, and terminology
Skill in analysis and troubleshooting of an integrated software application
Skill in troubleshooting application issues using SQL query tools and MS Excel, to prove a hypothesis
Skill in authoring Oracle SQL statements for business analysis and data validation; ability to build complex joins, sub-queries, and unions
Skill in SSRS report development and PowerBI dashboard development
Skill in scripting for customizations, automations, and data tasks (PL/SQL and Python)
Skill in writing and executing structured test plans
Skill in 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 skills
Organization and time management skills
Ability to understand and follow technical design specifications
Ability to communicate technical topics to all levels of technology users
Ability to devise procedures to solve moderately complex information systems problems
Ability to support organizational goals and objectives
Ability to understand and carry out oral and written directions
Ability to review technical documents and templates and suggest revisions
Preferred
Minimum of three years of utility billing system support
Experience supporting customer information system support functions
Benefits
The City of Charlotte provides a comprehensive benefits package to eligible employees.
The City of Charlotte is a drug and alcohol-free workplace.
Company
City of Charlotte
City of Charlotte is a municipal government.
5001-10000 employees
H1B Sponsorship
City of Charlotte has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2021 (1)
Funding
Current Stage
Late StageTotal Funding
$0.02MKey Investors
The Vermont Department of Forests, Parks, and RecreationMaddie's Fund
2024-05-29Grant· $0.01M
2022-09-06Grant· $0M
Leadership Team
Markell Storay
Chief Information Officer and Director of Innovation and Technology
Recent News
2025-05-20
Clean Technica
2025-04-30
Company data provided by crunchbase