Charlotte Area Transit System · 9 hours ago
UMS Business Analyst
CLT IT
Full-time
Onsite
Mid, Senior Level
$81K/yr - $90K/yr
5+ years expThe City of Charlotte is seeking a UMS Business Analyst to join the Innovation & Technology department. The role involves providing operational user support, application data analysis, and business process improvement for various enterprise applications.
Transportation/Trucking/Railroad
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
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
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.
Company
Charlotte Area Transit System
Charlotte Area Transit System
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Elizabeth Presutti
Deputy Director, Chief Administrative Officer
Jason (JL) Lawrence
Chief Planning Officer
Company data provided by crunchbase