Financial Analyst 1 (Capital Improvement Projects)

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

About The Position

The Financial Analyst provides financial information, analysis, and reporting to help executives, managers, and supervisors make strategic and operational decisions. The role supports financial planning and analysis, including budgeting, forecasting, financial modeling, performance monitoring, and financial reporting. Within the Capital Improvement Program (CIP), the analyst supports the financial integrity, compliance, and reporting of the department’s capital portfolio, including financial systems analysis, project monitoring, funding-source validation, and grant management and reimbursement processes. The position supports capital projects funded through bonds, I&E funds, grants, and State Revolving Fund (SRF) programs, and helps ensure expenditures are accurately recorded, properly funded, and aligned with approved budgets and funding requirements. The analyst works with minimal supervision and reports directly to the CIP Finance Manager. The role prepares regular financial reports, monitors project commitments and expenditures, evaluates funding availability and risks, supports reconciliations and audits, and collaborates with finance, engineering, procurement, and project management teams. CIP Finance assignments may also include maintaining Oracle financial reports, supporting journal entries and funding realignments, preparing grant reimbursement requests, and tracking grant compliance, balances, deadlines, and closeouts.

Requirements

Bachelor’s degree with a specialization in Accounting or Finance, or equivalent experience.
Minimum 1–3 years of experience related to economics, finance, accounting, financial analysis, or related work.
Knowledge of financial theory, business management operations, and practices.
Knowledge of budget planning, financial analysis, and forecasting.
Knowledge of capital improvement program financial management.
Knowledge of municipal accounting principles and financial reporting practices.
Knowledge of enterprise financial management systems and reporting tools.
Knowledge of financial data analysis and reporting techniques, economic and accounting principles, financial markets, and banking.
Knowledge of grant funding structures and compliance requirements.
Ability to identify, synthesize, and evaluate complex financial and budget issues and consolidate information from multiple sources.
Ability to prepare financial reports, presentations, and dashboards.
Ability to use Microsoft Office software, including Excel, Word, and PowerPoint, and Excel tools such as tables, VLOOKUP, charts, and related analytical functions.
Ability to communicate financial information clearly to technical and non-technical audiences.
Ability to work effectively with minimal supervision and complete specialized financial and analytical assignments.
Ability to develop and maintain effective working relationships with internal business units, vendors, and external agencies.
Ability to conduct research and financial analysis, manage financial modeling and planning processes, and support multi-year operating and capital plans.
Ability to recommend and support financial policies, procedures, and internal controls; analyze operations across programs; interpret technical reports; coordinate fiscal analysis and forecasting; and communicate effectively orally and in writing.
Ability to work collaboratively in a team environment.
Regular computer use and the ability to perform the position’s duties, with reasonable accommodations where applicable.
Applicants must be authorized to work for any employer in the United States; the department is unable to sponsor or take over sponsorship of an employment visa.

Nice To Haves

MBA.
Experience with financial systems, capital programs, or grant-funded programs.

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, budget monitoring, forecasting, and expenditure tracking across multiple funding sources.
Maintain and analyze financial information in enterprise financial systems, including Oracle financial reporting tools.
Monitor capital project commitments, expenditures, burn rates, and funding availability.
Identify financial risks, including overspending, underutilized funds, funding-source misclassification, and delayed project closeouts.
Support reconciliations between project financial records, funding sources, and general ledger balances.
Assist in validating funding-source alignment across 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 information requests.
Collaborate with finance, engineering, procurement, and project management teams on capital project financial monitoring.
Identify financial trends and develop forecasts for capital program expenditures.
Perform cost studies and alternative analyses to assess efficiencies and priorities.
Evaluate financial and operational results across departments or programs.
Support financial analysis for capital project planning and procurement initiatives.
Use benchmarking and comparison studies of similar organizations to support decision-making.
Assist in developing financial policies, guidelines, and procedures that support 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 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.