Financial Analyst - Fixed Assets & CIP Specialist

Airport-Minority-Advisory-Council; Chicago (IL); On-site; USD 61,000 - 83,000; Full time

Job summary

The City of Chicago, through the Chicago Department of Aviation's Finance Division, seeks a Financial Analyst to perform complex financial analysis of fiscal/cost data for City programs and services.

The role focuses on maintaining fixed asset records, capitalization, depreciation calculations, CWIP tracking, and ACFR footnotes preparation, with additional duties as needed. Strong Excel and audit-support skills are essential.

Qualifications

• Bachelor's degree or higher in Finance, Accounting, or related field and 1 year of financial analysis experience.
• Proficient Excel with pivot tables and lookups; familiarity with CIP and asset tracking.
• Attention to detail with strong reconciliation, analytical, and audit-support skills.
• CPA, CGFM or progress toward certification is a plus.

Responsibilities

• Maintain fixed Asset register for CDA using CityWorks and transmit to DOF.
• Record additions, transfers, retirements and disposals with proper capitalization.
• Calculate depreciation in accordance with GASB No 34.
• Track CWIP for capital projects and capitalize upon completion.
• Support ACFR fixed asset footnotes and schedules.
• Coordinate with Engineering/Capital Projects to classify costs.
• Conduct periodic physical asset inventories and reconciliations for insurance.
• Support external audits and state oversight bodies.
• Assist with GASB 87 lease accounting and GASB 96 subscriptions.

Skills

Excel skills

Data analysis

Reconciliation

Audit support

GASB knowledge

Education

Bachelor's degree or higher in Finance/Accounting or related field

1 year work experience in financial analysis

Job description

The City of Chicago, through the Chicago Department of Aviation's Finance Division, seeks a Financial Analyst to perform complex financial analysis of fiscal/cost data for City programs and services.

The role focuses on maintaining fixed asset records, capitalization, depreciation calculations, CWIP tracking, and ACFR footnotes preparation, with additional duties as needed. Strong Excel and audit-support skills are essential.