Job Description
Posting number: 132574001-FT-112026
Department: Finance
Job classification: Budget/Financial Analyst
Posting type: Open
Categories: Accounting and Finance
Summary
General summary: Provide professional financial analysis, planning, and decision support that promotes sound use of public resources. Develop and monitor budgets, evaluate financial trends and risks, and produce reliable information for City leadership and departments. Perform a designated budget, grant, or reporting assignment using Tyler Munis, approved analytical tools, and documented controls.
Distinguishing features of the class: The classification encompasses four positions: two budget-focused, one grant-focused, and one reporting-focused. All positions perform shared analytical and control duties; specialized responsibilities apply to the assigned portfolio. Each position has a designated supervisor, primary duties, trained backup responsibilities, and documented approval limits. Budget-focused positions work under the Budget Manager; grant and reporting positions work under the Finance Manager. Work requires independent professional judgment within City policies, accounting standards, and delegated authority. Analysts identify issues, develop alternatives, and recommend action; management retains policy, staffing, funding, and approval decisions. Technical coordination and training do not confer personnel supervision. The role works with Accountants, Budget, Purchasing, Payroll, Utility Billing, departments, and IT; it does not assume operational ownership of every Finance function.
Examples of duties
JOB DUTIES:
- 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 where required.
- Prepare reproducible forecasts, variance analyses, financial schedules, and recommendations. Identify documented cost and revenue drivers, recurring versus one-time effects, assumptions, uncertainty, and implications for future budgets or cash needs.
- Assist departments in linking 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. Distinguish verified facts, estimates, scenarios, and recommendations; obtain authorized review before release.
- Use 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; do not approve entries or transactions prepared by oneself where independent review is required.
- Document and improve assigned workflows; reduce duplicate entry and manual reporting through authorized automation. Test changes, reconcile results, and maintain procedures and user training materials.
- Use City-approved Al tools, when available, to assist with 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 demonstrated backup proficiency in designated compatible tasks; communicate deadlines, exceptions, and workload constraints. Perform directly related duties consistent with the classification.
- Provide central financial oversight, ensuring grant compliance, and technical support for decentralized departmental grants. Review proposed grant budgets, match sources, cash needs, reimbursement terms, and continuing obligations; route legal, application, acceptance, and funding approvals through designated authorities.
- Coordinate award setup and project accounting standards; maintain 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 documentation; prepare assigned grant, SRF, and bond draws for authorized review, reconcile proceeds and expenditures, and forecast expected cash inflows.
- Maintain, Review, Enter, capital asset records (additions, deletions, transfers, depreciation) and process within Tyler ERP.
- Prepare and reconcile the Schedule of Expenditures of Federal Awards and assigned grant audit workpapers and ACFR components. Apply applicable award terms and federal requirements; support monitoring, corrective action, and closeout with departments and designated accounting reviewers. Assist with ACFR preparation by updating and balancing assigned Workiva Wdesk report content, related 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; track overdue draws, missing approvals, and compliance concerns and escalate through management. Departments remain responsible for program delivery, timely source documentation, and their required submissions.
- Perform other duties as assigned.
Knowledge Skills and Abilities
- Municipal finance: Knowledge of budgeting, fund accounting, GAAP and relevant GASB standards, financial planning, and internal controls; ability to apply applicable Iowa and award-specific requirements within the assigned specialty. Apply cash basis, modified accrual, and full accrual accounting and supported statement conversion methods within the grant or reporting assignment.
- Analysis: Skill in financial modeling, variance and trend analysis, scenario testing, reconciliations, and cost or funding evaluation. Ability to document assumptions, distinguish correlation from verified causes, and develop supported alternatives.
- Technology: Proficiency in Excel formulas, lookups, pivot tables, charts, and data validation, and in Word document production. Ability to learn Munis financial modules, project ledger relationships, workflow controls, and approved reporting and publishing tools. Grant and reporting assignments require proficiency in updating and balancing Workiva Wdesk ACFR content, linked data, disclosures, and statistical tables.
- Data governance: Ability to define measures, verify source lineage and completeness, manage report versions and refresh status, and reconcile automated outputs. Learn Power Query, Power Bl, SSRS, or comparable tools according to the assignment.
- Al judgment: Ability to recognize inaccurate outputs, unsupported conclusions, privacy risks, and automation limitations; use approved tools with source verification and authorized review. Al model development is not a core requirement.• Process and communication: Ability to document and test improvements, train staff, explain complex information in plain language, provide respectful service to workforce and public, and coordinate across departments.
- Work management: Ability to prioritize competing deadlines, exercise independent judgment within authority, identify control failures, protect confidential information, and communicate capacity and coverage needs.
Qualifications
MINIMUM QUALIFICATIONS
Bachelor’s degree in Accounting, Finance, Business, Management, Financial Mathematics, Public Administration, or a related field, and two (2) years of relevant experience in budgeting, accounting, financial analysis, or analytics; or an equivalent combination of education, training, and experience that demonstrates the required knowledge, skills, and abilities.
Must possess the ability to effectively utilize spreadsheets and financial systems and learn assigned Enterprise Resource Planning (ERP) system functions, processes, and internal controls.
PREFERRED QUALIFICATIONS
- Experience in municipal or other governmental finance.
- Proficiency with Tyler Munis or a comparable Enterprise Resource Planning (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 in grant financial administration, including reimbursement requests, Schedule of Expenditures of Federal Awards (SEFA), and grant compliance.
- Experience with governmental financial reporting, Annual Comprehensive Financial Report (ACFR) workpapers, validated Business Intelligence (BI) or SQL Server Reporting Services (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, particularly for positions assigned grant administration or financial reporting responsibilities.
- Certified Public Accountant (CPA), Certified Public Finance Officer (CPFO), or other relevant professional certification, training, or continuing education.
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 appropriate supporting records and documentation to promote 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 and support 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. Performance measures will be established following the development of workload and operational baselines.
Supervisory Status
- No direct reports or formal personnel supervisory responsibilities.
- May coordinate assigned projects and provide technical guidance, direction, and training to others as needed.
FLSA Status: Exempt
Residential Requirement
- Employee shall establish their principal place of residence within fifty (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.
Work Schedule
- Work may require nontraditional hours 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.