Sr Dept IT Business Analyst - Finance

Salary Range: $86,125 - $129,187

This is an exempt position. Pay rates are based on education, skill, experience level and internal equity

Follow your calling, Find your career

The Financial Services Department is responsible for capital and debt planning, investments, accounting, payroll, grant management and payables, along with providing additional fiscal support to departments across the County. The Finance Department also manages Mecklenburg County's $4-billion five-year Capital Improvement Plan (CIP). The CIP funds a range of projects, including creating new community resource centers, updating County facilities, and expanding the park and greenway system. Funding is also included for Charlotte-Mecklenburg Schools, Central Piedmont Community College, and Charlotte Mecklenburg Library capital projects.

POSITION SUMMARY

The Sr. Business Analyst identifies, elicits, documents, and translates technology requirements based on the strategic plans and project areas for Mecklenburg County departments. This lead position, under minimal supervision, must be knowledgeable of both the business (department) needs and the related information technologies that assist in addressing those needs. Incumbents are responsible for reviewing, modifying, and recommending database and system application requirements to meet business needs, evaluating, and refining that process, and serving as a liaison between the department and IT. The incumbent will also be responsible for escalated production issues, evaluating and performing root cause analysis, and determining the best resolution. This position requires system configuration, testing, analyzing, and implementation of new functionality.

ESSENTIAL FUNCTIONS

• Maintain system tables for finance supported databases and applications.

• Troubleshoot system issues and work with IT for resolutions.

• Manage and facilitate requirements gathering for medium or large-size and complex projects.

• Test system functionality to resolve system issues. Implement and thoroughly test system changes.

• Train end users on different finance supported systems and assist with creating training materials for enterprise-wide online training.

• Utilize various reporting software tools to extract and import data to/from the system and develop finance related reports that meet the needs of management.

• Write system specifications, build process maps, and capture requirements.

• Upon post implementation of projects, validate that the expected efficiencies, benefits, and outcomes were achieved.

• Act as a liaison between the Department and County IT Services.

• Write reports and extract data using SQL (Structured Query Language) and provide data from software systems.

• Develop and maintain relevant procedures and standards ensuring that hardware and systems work as expected.

• Configure, diagnose, troubleshoot and correct computer systems issues relating to software enhancements for application deployments and infrastructure upgrades.

• Conduct fit-gap analyses.

• Meet with departmental subject matter experts and associated staff to document technology requirements (hardware, software, etc.).

• Create and execute test plans/scripts.

• Support application upgrades, integrations, customer-requested enhancements, special projects, and daily production support issues.

• Support ITS technical developers with requirements definition, testing, and customer communications.

• Develop new queries, including gathering requirements, validating data, and analyzing results.

MINIMUM QUALIFICATIONS

Experience: Minimum of four years of directly related experience.

Education: Bachelor's degree in Information Technology, Business Administration, or related to specific assignment.

Combination of relevant education and relevant experience accepted: Yes

Licenses and Certifications

May require a valid North Carolina or South Carolina driver's license

PREFERRED QUALIFICATIONS

• Technical aptitude with ability to quickly learn new systems.

• Experience writing SQL, using Microsoft Access and or SQL Server, Excel v-lookups, etc. .

• Experience developing test scripts and performing validation.

• Experience creating system documentation and providing end user training.

• Strong analytical and technical skills.

• Experience with Oracle Peoplesoft Payroll and Time and Labor administration

• The incumbent must have a strong initiative, problem solving skills, & creative thinking ability.

• Ability to work individually and in a team environment.

• Demonstrated people skills and customer support skills.

• General accounting background

KNOWLEDGE, SKILLS AND ABILITIES

Knowledge of

• System Development Life Cycle (SDLC) models

• Modeling language for documenting requirements

• Current software development technologies, trends, and methodologies

• Knowledge of SQL and experience querying and analyzing data.

• Principles and processes for providing customer and personal services

• Business and management principles involved in strategic planning, project management, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources

• Structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar

Skills

• Leading small teams, organizing parallel efforts, setting goals, tracking progress

• Group and 1:1 interviewing to elicit requirements as well as creative thinking

• Working with system architects, developers, Quality Assurance, and vendor personnel in requirements gathering process

• Research, evaluate and recommend technological solutions

• Understanding the methodical process of system programs, troubleshooting, and problem analysis

Abilities

• Building Partnerships: Identifies opportunities and takes action to build strategic relationships between one's area and other areas, teams, departments, units, or organizations to help achieve business goals.

• Communication: Clearly conveys information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.

• Collaboration: Works effectively and cooperatively with others; establishes and maintains good working relationships.

• Decision Making: Identifies and understands issues, problems, and opportunities; compares data from different sources to draw conclusions; uses effective approaches for choosing a course of action or developing appropriate solutions; takes action that is consistent with available facts, constraints, and probable consequences.

• Driving for Results: Sets high goals for personal and group accomplishment; uses measurement methods to monitor progress toward goals; tenaciously works to meet or exceed goals while deriving satisfaction from that achievement and continuous improvement.

• Technical / Professional Knowledge & Skills: Having achieved a satisfactory level of technical and professional skill or knowledge in position-related areas; keeping up with current developments and trends in areas of expertise

• Managing Work: Effectively managing one's time and resources to ensure that work is completed efficiently

• Adaptability: Maintaining effectiveness when experiencing major changes in work responsibilities or environment; adjusting effectively to work within new work structures, processes, requirements, or cultures

• Information Monitoring: Setting up ongoing procedures to collect and review information needed to manage an organization or ongoing activities within it

COMPUTER SKILLS

• A high level of computer literacy is necessary for this position, including the ability to utilize complex requirements gathering tools and portfolio management systems.

• Advanced knowledge in Microsoft Excel and/or Access

REASONABLE ACCOMMODATIONS STATEMENT

To accomplish this job successfully, an individual must be able to perform, with or without reasonable accommodation, each essential function satisfactorily. Reasonable accommodations may be made to help enable qualified individuals with disabilities to perform the essential functions.

DISCLAIMER STATEMENT

This is not intended to be an all-inclusive list of job-related responsibilities, duties, skills, requirements or working conditions. Other duties may be assigned based on business need and the supervisor's request. Mecklenburg County reserves the right to revise the job description at any time. Designated positions may be required to assist in emergency and/or disaster situations.