FUNCTIONAL APPLICATIONS ANALYST-SENIOR

Recruitment #2002-5015-001

Introduction

**THIS POSITION IS OPEN TO CURRENT CITY OF MILWAUKEE EMPLOYEES ONLY**

The candidate selected in this process may, upon completion of the underfill, be promoted to the title of FMIS Project Manager (2LX).  

The minimum requirements of the FMIS Project Manager position are as follows:

  1. Bachelor’s degree in accounting, business administration, finance, management  information systems or a closely related field from an accredited college or  university.
  2. Four years of progressively responsible experience working with payroll and financial computer applications and analyzing large scale databases, including one year of governmental financial systems maintenance or high level functional applications analysis.

Purpose

The Functional Application Analyst-Senior performs analysis, design, testing, maintenance and operation of the City's Financial Management Information System (FMIS) and the Human Resource Management System (HRMS).

Essential Functions

  • Assist in financial and payroll transaction processing functions by identifying issues, testing solutions and monitoring data for accuracy.
  • FMIS: Monitor and maintain data in the budget ledger and general ledger to ensure data integrity; serve as the primary contact for commitment control functionality; identify and resolve issues with accounting and payroll transactions, posting, procedures, and interfaces; and identify and resolve problems with the software and configurations.
  • HRMS: Monitor and maintain payroll data to ensure accurate contributions and interfaces including interface to the retirement system; serve as the primary contact for issues related to ERS' MERITS interface.
  • Answer internal help desk questions, advise users on reconciliation techniques, and explain the flow of transactions; provide recommendations on system use to meet information needs.
  • Serve as liaison to other departments in the design and implementation of systems intended to interface with payroll or financials and assist in establishing procedures for use (i.e. DPW's Time Entry system); and identify the need for alternative procedures or processes and takes action toward implementation of corrective steps.
  • Assist in the maintenance of the City's financial and payroll systems by configuring software maintenance system tables and tree structures; resolving issues related to flawed processes and inconsistencies in data; identifying and analyzing program/software bugs, report bugs to the appropriate vendors, and tracking issues to resolution while simultaneously developing appropriate work-arounds.
  • Assist in the operation of the City’s financial and payroll systems by designing and implementing process improvements and testing custom modules; providing changes or upgrades to existing programs; implementing migration to production; preforming test upgrades, modifications and bug fixes; verifying data during conversions; and assisting users with functionality and record changes during upgrades.
  • Design and layout data retrievals for end-users using tools such as SQL, nVision and query.
  • Assist users with the use of ad hoc reporting tools, such as query and system delivered reports as well as production of special purpose reports, data files, forms or research.
  • Maintain documentation on functional processes, procedures, modifications and fixes.
  • Develop training materials and serve as a training resource for City-wide FMIS training classes.

Reasonable accommodations requested by qualified individuals with disabilities will be made in accordance with the Americans with Disabilities Act (ADA) of 1990, as amended by the Americans with Disabilities Act Amendments Act (ADAAA) of 2008.

Minimum Requirements

  1. Regular status as City of Milwaukee employee, having successfully completed a probationary period for a civil service position.
  2. Bachelor’s degree in accounting, business administration, finance, management information systems or a closely related field from an accredited college or university.
  3. Three years of progressively responsible experience working with payroll and financial computer applications and analyzing large scale databases, performing duties related to the essential functions listed above.

Equivalent combinations of education and experience may be considered.

IMPORTANT NOTE: College transcripts are required and must be received by the application period closing date. Transcripts should be attached to your online application. Applications without transcripts attached will be considered incomplete and will be rejected. Student/unofficial copies are acceptable; however, your transcript must be legible and include your college/university name, your name, the degree completed (if applicable) and the date completed.

Desirable Qualifications

  • Certified Public Accountant (CPA) or CPA candidate

Knowledges, Skills, Abilities & Other Characteristics

  • Knowledge of fund and encumbrance accounting practices in a municipal setting.
  • Knowledge of financial management vehicles, financial management theory, and payroll processes.
  • Knowledge of financial or payroll-related analytical, performance monitoring, and management systems including FMIS, HRMS, PeopleSoft, payroll, and general ledger.
  • Technical skills in using FMIS, HRMS, PeolpleSoft, PeopleTools, nVision, Windows, MS Office; familiarity with SQL/query, SQR and Oracle databases.
  • Knowledge of the pay, leave and deduction practices, including FLSA (Fair Labor Standards Act) in a large scale municipal organization.
  • Ability to test highly complex program designs, create training modules/guide, and provide end user support.
  • Ability to understand issues and ability to direct and coordinate the activities of users of the city's FMIS and HRMS systems.
  • Ability to work independently to solve and manage problems, prioritize tasks and ensure data integrity.
  • Knowledge of mathematical principles and the ability to make accurate calculations.
  • Ability to effectively communicate orally and in writing, especially complex financial or payroll concepts.
  • Ability to prepare executive summaries and other written communications for senior management as well as the Common Council.
  • Ability to read and interpret statistical and financial reports.
  • Skill in managing large and complex quantities of data and information.
  • Ability to think critically and analytically to solve problems, make decisions and use sound judgement.
  • Ability to be highly organized and work effectively under pressure, within tight time constraints to produce high quality products.
  • Ability to perform work efficiently with a high degree of accuracy.
  • Ability to work cooperatively and effectively with coworkers and citizens whose backgrounds may differ from one’s own.
  • Ability to exhibit exemplary professionalism.
  • Integrity and the ability to maintain complete confidentiality.

Current Salary

Functional Application Analyst-Senior:

The current salary range (PR 2JX) is $62,338-$87,270 annually, and the resident incentive salary range for City of Milwaukee residents is $64,209-$89,889 annually. Appointment will be made in accordance with the provisions of the salary ordinance. 

Selection Process

THE SELECTION PROCESS will be job related and will consist of one or more of the following: an evaluation of related education, experience and accomplishments, written tests, interview, or other assessment methods.  The Department of Employee Relations and the Comptroller’s Office reserve the right to call only the most qualified candidates to oral, performance tests or personal interviews. Information from the selection process will be used to make a hiring decision. Selected candidates will be transferred and/or promoted to the position.

Note: Transfer/Promotional Opportunities and Promotional Examinations are not open to Milwaukee Public Schools employees or to the public. Only current City of Milwaukee employees and civilian personnel in MFD and MPD hired through a City Service Commission process who have successfully passed a probationary period for a Civil Service position will be considered. Individuals with exempt, provisional, temporary, or emergency appointments are not eligible for transfer.

Additional Information

  • APPLICATIONS and further information may be accessed by visiting, http://city.milwaukee.gov/jobs.
  • If you would like assistance completing an application, please contact the Department of Employee Relations at (414) 286-3751 or staffinginfo@milwaukee.gov.
  • The Department of Employee Relations is located at City Hall, 200 E. Wells St., Room 706, Milwaukee, WI 53202

Conclusion

EEO = 203

The City of Milwaukee values and encourages diversity and is an equal opportunity employer.