ERP/Grants Financial Analyst (Financial Analyst)

Job Description:

ERP/Grants Financial Analyst (Financial Analyst)

Description

Full-time position available with the Finance Department, Accounts Division, located at 414 E 12th St.
Salary Range: $6,489-$9,734/month
Normal Work Days/Hours: Monday-Friday 8:00 a.m.-5:00 p.m.*Telework available 1 day a week after 6-month probationary period.
Application Deadline Date: September 30, 2025


Responsibilities

• Plans, directs, and coordinates activities related to federal and non-federal grant funding administration and review, accounts receivable reconciliation, general ledger maintenance, and implementing internal controls.
• Possess strong analytical skills and have experience with or an understanding of accounting general ledger management and federal grant reporting requirements.
• Assist in implementing a new Enterprise Resource Planning (ERP) system for the City, so experience working on similar integration initiatives is preferred.
• Work with limited supervision and be responsible for the use of initiative and judgment in establishing procedures, processes, controls and carrying out various assignments to improve and enhance City operations.
• Supervises a team of analysts responsible for accounts receivable reconciliation, grant management, and grant reporting; provides training on grant management best practices and compliance requirements, as well as use of ERP Grants Management, Accounts Receivable, Billing, General Ledger, and Commitment Control modules.
• Provides functional end user consultation for the Grants Management, Accounts Receivable, Billing, General Ledger, and Commitment Control ERP modules.
• Resolves escalated support issues related to various ERP interfaces, and assists City's technical analysts with identifying and implementing fixes for system issues.
• Documents existing operational processes for use in requirement-setting for new ERP system implementation.
• Collaborates with City departments with grant management in the areas of administration, financial oversight, and compliance; assists departments with billing for grant reimbursements and initiates grant drawdown requests when needed; monitors and tracks grant reimbursement requests for compliance, timeliness, and progress towards grant completion.
• Oversees reconciliation of grant project accounts to ensure data accuracy and coordinates the submission of financial and performance reports to granting agencies as well as City executive leadership.
• Manages the fiscal year-end close process, including re-estimation of grant revenues and re-appropriation of grant expenditures and encumbrances.
• Oversees development of the City's annual Schedule of Expenditures of Federal Awards (SEFA); produces reporting and documentation requested by external audit firm to complete the annual Federal Uniform Guidance Single Audit.
• Ensures accuracy of the City's accounting general ledger and financial reporting through journal entry request review and approval, and managing internal service cost allocation processes.
• Provide support to the Tax Increment Financing (TIF) Commission component unit on use of the City ERP system to report TIF activities as part of the City's financial reporting.
• Reviews City ordinances authorizing the submittal of grant applications and the acceptance of grant award funds.
• Performs related duties and special projects as required.

Qualifications

REQUIRES an accredited Master's degree in public or business administration, urban or regional planning, economics, organizational/development psychology, project management, or geography and 2 (OR an accredited Bachelor's degree and 4) years of progressively responsible professional experience in corporate or municipal finance including but not limited to accounting, banking, billing and collections, debt and investment portfolio management, financial reporting, development review, and projecting and monitoring tax and fee activities, including 1 year of experience managing financial projects and/or programs.


Other Information

Why You'll Love Working with Us - Core Employee Benefits

Comprehensive Health Coverage
Affordable medical, dental, and vision plans with multiple options and low employee contributions.

Generous Paid Time Off
Enjoy vacation, sick leave, and 13 paid holidays-with accruals that grow the longer you're with us.

Secure Retirement Planning
City-funded pension plan plus an optional 457 savings plan to help you build long-term financial security.

Support for Life's Big Moments
Paid parental and bereavement leave to help you navigate major life events with peace of mind.

Tuition Assistance
Get reimbursed for eligible education expenses-invest in your future while you work.

Income Protection
Short- and long-term disability coverage options to safeguard your earnings.

Life Insurance Provided
City-paid life insurance with the option to add more coverage for extra peace of mind.

Community Volunteer Leave
Take up to 8 hours annually to give back to causes you care about.

Want the Full Picture?
Click here for a complete benefits summary.

URGENT!!! CRITICAL RECRUITMENT INFORMATION

Applications and/or resumes are evaluated on the information received by the application deadline. Please ensure that your application or resume clearly demonstrates how you meet the minimum qualifications for the position for which you are applying, this includes providing all relevant educational dates and a detailed description of relevant work experience, including months/years of employment. Applications and/or resumes may not be considered if information is incomplete.

In order for a resume to be used in lieu of an application the resume must have been submitted online via the City's Applicant Tracking System.

Positions requiring a high school diploma/GED certificate must be obtained from a school/program accredited by the Department of Education and recognized by the U.S. Secretary of Education.

The minimum education requirement for positions that allow for experience equivalency for an accredited degree is a high school diploma. Unless otherwise specified, an accredited degree must be obtained from a college or university listed with the U.S. Department of Education and recognized by the U.S. Secretary of Education.
For positions with a salary grade of EX6 or higher that require an accredited degree, qualifying professional experience must be obtained AFTER the accredited degree is obtained.
Successful completion of a pre-employment criminal history/background check is required for all positions. Some positions require a post offer drug screen and/or physical.

If appointed, non-residents must obtain residency inside Kansas City, Missouri's city limits within nine months.

The City of KCMO is an equal opportunity employer that values diversity and inclusion in the workplace. The City is committed to providing a workplace environment for its employees and citizens free from discrimination based on race, color, sex (including pregnancy), national origin, religion, age, disability, marital status, genetic information, sexual orientation, or gender identity. For more information, please see our EEO Policy

The City of KCMO is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process, please call 816-513-1908 or send an e-mail to accommodations@kcmo.org .

If claiming military veterans' preference points, you must attach a copy of your DD-214 or a DD-256 (for reservists). To claim veterans' points you must have served 180 days of regular active duty service and be discharged or released under honorable conditions during peacetimes or 90 days of active duty service, one (1) day during "wartime" and a last discharge or release under honorable conditions. (DOD) 38 U.S. Code • 4211).

Salary:

$6,489-$9,734/month