Financial Analyst 1

Examples of Duties
KNOWLEDGE OF:

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.

Minimum Qualifications
CAPITAL FINANCE FUNCTIONAL RESPONSIBILITIES
Assignments within the CIP Finance unit may include responsibilities such as:
Financial Systems and Reporting
• 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.
Grant Management and Reimbursement Support
• 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.

REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES
Knowledge Of
• 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)

SKILLS TO
• 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

ABILITY TO
• 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

Supplemental Information
REQUIRED EDUCATION AND EXPERIENCE
• Bachelor’s degree with specialization in Accounting or Finance, or equivalent experience
• MBA preferred
• 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

ESSENTIAL REQUIREMENTS
Physical Requirements
The physical demands described here are representative of those required to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform essential job duties.