Financial Analyst 1 (Capital Improvement Projects)

City of Detroit•DWSD -735 Randolph Detroit MI 48226, MI

7d•Hybrid

About The Position

The Financial Analyst provides financial information, analysis, and reporting to enable executives, managers, and supervisors to make informed strategic and operational decisions. The position supports financial planning and analysis activities including budgeting, forecasting, financial modeling, performance monitoring, and financial reporting. Within the Capital Improvement Program (CIP), the Financial Analyst supports the financial integrity, compliance, and reporting of the department’s capital portfolio. Responsibilities include financial systems analysis, capital project financial monitoring, funding source validation, and support for grant management and reimbursement processes across projects funded through bonds, I&E funds, grants, and State Revolving Fund (SRF) programs. The position also supports financial controls, funding accountability, and risk identification across the capital portfolio to ensure capital program expenditures are accurately recorded, properly funded, and aligned with approved budgets and funding requirements. The Financial Analyst works with minimal supervision and reports directly to the CIP Finance Manager.

Requirements

Bachelor’s degree with specialization in Accounting or Finance, or equivalent experience
Minimum 1–3 years of experience related to economics, finance, accounting, financial analysis, or related work
Experience with financial systems, capital programs, or grant-funded programs preferred
Financial theory and principles of business management operations and practices
Budget planning, financial analysis, and forecasting
Capital improvement program financial management
Operational cost metrics such as productivity, operating expenses, and activity-based costing concepts
Municipal accounting principles and financial reporting practices
Enterprise financial management systems and reporting tools
Financial data analysis and financial reporting techniques
Economic and accounting principles and practices, financial markets, banking, and analysis and reporting of financial data
Grant funding structures and compliance requirements
Departmental mission, processes, policies, and procedures
Basic Geographic Information Systems (GIS)
Identify, synthesize, and evaluate complex financial and budget issues
Consolidate financial information from multiple sources and perform analytical review
Prepare financial reports, presentations, and dashboards
Utilize Microsoft Office software including Excel, Word, and PowerPoint
Use Excel tools such as tables, VLOOKUP, charts, and related analytical functions
Communicate financial information clearly to technical and non-technical audiences
Work effectively with minimal supervision
Complete specialized financial and analytical assignments
Develop and maintain effective working relationships with internal business units, vendors, and external agencies
Conduct research and financial analysis supporting organizational decision-making
Partner with business units and City Agencies to support development of multi-year operating and capital plans
Manage financial modeling, business planning, and financial analysis processes supporting capital programs
Recommend and support development of financial policies, guidelines, procedures, and internal controls
Analyze financial and business operations across multiple departments and programs
Interpret professional and technical reports and develop recommendations
Plan and coordinate fiscal analysis and forecasting activities
Communicate clearly and effectively both orally and in writing
Work collaboratively in a team environment
Valid Michigan Driver’s License
Ability to travel to DWSD facilities and project sites as needed
Ability to work irregular hours if required to support operational or reporting deadlines

Nice To Haves

MBA preferred

Responsibilities

Prepare weekly, monthly, quarterly, and annual reports comparing financial and operational results using actual, historical, budget, and forecast data.
Support capital program financial planning including budget monitoring, forecasting, and expenditure tracking across multiple funding sources.
Maintain and analyze financial information within the department’s enterprise financial systems, including Oracle financial reporting tools.
Monitor capital project financial performance including commitments, expenditures, burn rates, and funding availability.
Identify financial risks including overspending, underutilized funds, funding source misclassification, and delayed project closeouts.
Support reconciliation activities between project financial records, funding sources, and general ledger balances.
Assist in validating funding source alignment across capital projects including bonds, I&E, grants, and SRF funding.
Prepare financial analyses and presentations to support management decision-making.
Support internal and external audits by maintaining organized financial documentation and responding to financial information requests.
Collaborate with finance, engineering, procurement, and project management teams to support financial monitoring of capital projects.
Assist in identifying financial trends and developing forecasts for capital program expenditures.
Perform cost studies and alternative analyses to assess efficiencies and priorities.
Conduct evaluations of financial and operational results across departments or programs.
Support financial analysis related to capital project planning and procurement initiatives.
Utilize benchmarking and comparison studies of similar organizations to support decision-making.
Assist in the development of financial policies, guidelines, and procedures supporting financial accountability and transparency.
Maintain and analyze Oracle financial reports including Project Status, Commitments, Expenditures, and Budget summaries.
Assist with financial reconciliations, journal entry support, and funding realignment activities.
Develop financial reports and dashboards to monitor capital program performance.
Identify and support correction of funding source misclassifications across capital projects.
Support year-end financial reconciliation and ledger accuracy related to capital projects.
Monitor grant-funded capital project expenditures for eligibility and compliance with grant award requirements.
Prepare and review grant reimbursement requests and supporting documentation.
Reconcile project costs, funding sources, and reimbursement activity across financial systems and grant records.
Track grant balances, amendments, deadlines, and closeout requirements.
Coordinate with internal teams and granting agencies to resolve reimbursement documentation issues.