FinanceJobs.io
← Back to all jobs

Job Description

The City of Dubuque in Iowa is seeking a Budget/Financial Analyst to deliver professional financial analysis, planning, and decision support across budgeting, grant-related work, and financial reporting. In this onsite role, you will develop and monitor budgets, evaluate financial trends and risks, and provide dependable information to support City leadership and departments, using documented controls and assigned analytical tools.

Role summary

You will perform designated budget, grant, and reporting assignments by analyzing financial and operational information for completeness, accuracy, and compliance. Work will center on producing reproducible forecasts, variance analyses, and financial schedules, while maintaining audit-ready records and ensuring workflows align with segregation of duties and delegated approval limits.

Key responsibilities

  • Analyze financial and operational information for completeness, accuracy, and compliance.
  • Reconcile assigned financial data to source records and ledgers; investigate exceptions, document corrections, and obtain independent review when required.
  • Prepare reproducible forecasts, variance analyses, financial schedules, and recommendations.
  • Identify and explain documented cost and revenue drivers, including recurring versus one-time effects, assumptions, uncertainty, and implications for future budgets or cash needs.
  • Assist departments in connecting service objectives, strategic priorities, resource requests, and performance measures.
  • Validate measure definitions, data sources, reporting periods, and limitations with responsible departments.
  • Prepare clear reports and presentations for management, departments, and public review as assigned, distinguishing verified facts, estimates, scenarios, and recommendations.
  • Use Tyler Munis workflows, project and general ledgers, assigned modules, and approved reporting tools.
  • Verify imports, interfaces, report parameters, record counts, and control totals; coordinate system issues and configuration requests with authorized Finance and IT staff.
  • Maintain electronic supporting records, audit trails, procedures, and retention controls.
  • Observe segregation of duties, confidentiality, access restrictions, and delegated approval limits, including not approving entries or transactions prepared by oneself where independent review is required.
  • Document and improve assigned workflows, reducing duplicate entry and manual reporting through authorized automation.
  • Test changes, reconcile results, and maintain procedures and user training materials.
  • Use City-approved AI tools (when available) to support anomaly screening, reconciliation suggestions, draft narratives, and analytical questions.
  • Verify calculations and conclusions against source evidence, protect restricted information, and preserve human accountability for financial judgments and approvals.
  • Provide department training, technical assistance, and responsive service; maintain backup proficiency for designated compatible tasks and communicate deadlines and exceptions.
  • Provide central financial oversight to ensure grant compliance and provide technical support for decentralized departmental grants.
  • Review proposed grant budgets, match sources, cash needs, reimbursement terms, and continuing obligations, routing legal, application, acceptance, and funding approvals through designated authorities.
  • Coordinate award setup and project accounting standards, maintaining award, project, funding-source, and reporting information in assigned systems.
  • Verify approved project strings, eligible periods, restrictions, and required documentation; resolve purchase order and contract coding issues with responsible staff.
  • Maintain grant reporting and draw calendars, receivable and reimbursement status, and exception records; review eligible expenditures and prepare assigned grant, SRF, and bond draws for authorized review.
  • Maintain and reconcile capital asset records within Tyler ERP, including additions, deletions, transfers, and depreciation.
  • Prepare and reconcile the Schedule of Expenditures of Federal Awards (SEFA) and support assigned grant audit workpapers and ACFR components.
  • Apply applicable award terms and federal requirements, supporting monitoring, corrective action, and closeout with departments and designated accounting reviewers.
  • Assist with ACFR preparation by updating and balancing Workiva Wdesk report content, disclosures, statistical tables, and capital asset schedules.
  • Prepare and reconcile assigned cash basis and modified accrual information and supported conversion adjustments to full accrual, with independent review.
  • Conduct grant coordination meetings and training, tracking overdue draws, missing approvals, and compliance concerns and escalating through management as appropriate.
  • Perform directly related duties consistent with the classification and other duties as assigned.

Classification structure

  • The classification includes four positions: two budget-focused roles, one grant-focused role, and one reporting-focused role.
  • Budget-focused positions report to the Budget Manager; grant and reporting positions report to the Finance Manager.
  • Technical coordination and training are provided without personnel supervision.
  • The role works with Accountants, Budget, Purchasing, Payroll, Utility Billing, departments, and IT, without operational ownership of every Finance function.

Qualifications

  • Bachelor’s degree in Accounting, Finance, Business, Management, Financial Mathematics, Public Administration, or a related field, plus two (2) years of relevant experience in budgeting, accounting, financial analysis, or analytics; or an equivalent combination of education, training, and experience.
  • Ability to effectively utilize spreadsheets and financial systems and to learn assigned Enterprise Resource Planning (ERP) system functions, processes, and internal controls.

Technologies

  • Tyler Munis, Munis, Tyler ERP
  • Workiva Wdesk
  • Excel, Word, Power Query, Power BI
  • SSRS (SQL Server Reporting Services)
  • SSRS reports
  • Workiva Wdesk report content

Supervisory status and status details

  • No direct reports or formal personnel supervisory responsibilities.
  • Exempt under FLSA.

Compensation and location

  • Location: Dubuque, IA (onsite)
  • Salary range: USD 79,331 - 103,688 per year

Work schedule

  • Nontraditional hours may be required during budget preparation, audit season, and established grant or financial reporting deadlines.
  • Hybrid work arrangements are subject to current City policy and approved position schedules.

Benefits

  • Comprehensive benefits package

Residential requirement

Employees are required to establish their principal place of residence within 50 miles of the corporate limits of the City of Dubuque as soon as practicable following appointment, but no later than two (2) years from the date of appointment, consistent with applicable City policy.

Performance expectations

  • Meet established deadlines and approved schedules for budget development, grant administration, financial close, and financial reporting activities.
  • Prepare accurate, complete, and reproducible financial analyses, reports, reconciliations, and supporting documentation.
  • Maintain supporting records and documentation to support accuracy, transparency, accountability, and audit readiness.
  • Identify and promptly communicate discrepancies, unresolved exceptions, compliance concerns, and potential operational or financial risks to the appropriate supervisor.
  • Develop, maintain, and update procedures and work instructions to support consistent processes, continuity of operations, and knowledge transfer.
  • Maintain tested backup procedures and cross-training to ensure continuity of assigned financial responsibilities.
  • Demonstrate proficiency in assigned financial systems, reporting tools, and processes.
  • Meet supervisor-established performance measures related to timeliness, accuracy, exception resolution, report usefulness, grant reimbursement and draw status, and training proficiency.

Preferred qualifications

  • Experience in municipal or other governmental finance.
  • Proficiency with Tyler Munis or a comparable ERP system.
  • Experience with financial forecasting, account reconciliation, financial reporting, and data analysis.
  • Experience supporting operating and capital budget development, performance measurement, and funding analysis.
  • Experience with grant financial administration, including reimbursement requests, SEFA, and grant compliance.
  • Experience with governmental financial reporting, ACFR workpapers, validated BI or SSRS reports, and financial data integration.
  • Experience with Workiva Wdesk, capital asset schedules, financial statement disclosures, statistical tables, and conversion from cash or modified accrual basis to full accrual accounting, especially for grant administration or financial reporting responsibilities.
  • CPA, CPFO, or other relevant professional certification, training, or continuing education.

Similar Jobs