Welcome to the City of Charlotte

Charlotte is Americas 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 salary for this position is $80862.30 - $89846.99 Commensurate with experience

ESSENTIAL DUTIES & 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 adhoc 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.

Required Skills Knowledge and Abilities:

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

• 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

DESIRED QUALIFICATIONS

• Minimum of three years of utility billing system support

• Experience supporting customer information system support functions

MINIMUM QUALIFICATIONS

Required Education and Experience

• High School Diploma or equivalent

• Five (5) years of experience in business analysis requirements definition and information technology support

OR

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

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

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• This position is relative free from unpleasant environmental conditions or hazards and is generally sedentary. Incumbents may be required to exert up to 10 pounds of force occasionally a negligible amount of force frequently and/or constantly having to lift carry push pull or otherwise move objects including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

CONDITIONS OF EMPLOYMENT

The Citys 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 candidates 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 .

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.

BENEEFITS

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

Clickhereto learn more about the City of Charlottes benefits.

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