The Office of the Chief Financial Officer – ODFS - Legislative Operations Division is seeking to fill a Financial Analyst II position. Financial Analyst II is an intermediate level financial analyst within the City of Detroit Office of the Chief Financial Officer that receives close direction from higher level Financial Analysts and supervision from a Supervisor or Manager I. The Financial Analyst conducts simple to semi-complex analyses and provides recommendations based on the results of the analysis conducted. The analyses may include general and routine financial and operational issues and problems. The services provided include, but are not limited to: examination and review of studies performed by lower level Financial Analysts. The Financial Analyst participates in preparing detailed reports to show sources of information and explain the basis for conclusions; making recommendations on the basis of the analysis and evaluation; creating and tracking budget to actual across multiple years; and execute with supervision or as a part of a team a month-end close process that includes variance analysis and forecasting. Many of these services will be performed within the appropriate modules of the ERP Cloud that impact the operations of this position.

• Using ERP Cloud applications performs the following activities:

• Strategic planning, financial and operational analysis, budget preparation and analysis, and other critical analysis
• Financial evaluation of agencies and departments
• Strategic financial modeling, annual target setting, and annual business planning process for City Agencies to assess financial implications and support complex business decisions
• Using Process Management to manage the financial review cycle
• Development, implementation, and monitoring of financial and operational policies, guidelines, processes, procedures, internal controls, and performance measures
• Partnering with City Agencies to develop and monitor multi-year operating and capital plans, reserve forecasts, and long range financial strategies

• Develops, implements, monitors, and ensures compliance of financial and operational performance measures based on guidance and instructions provided by the supervisor
• Analyzes and reviews as a part of a team or with guidance from higher level Financial Analysts prior year expenditures, grant balances, and fund sources and prepares detailed financial forecasts, cost projections, and recommendations based on actual results
• Prepares, provides, and responds to routine and non-controversial requests and inquiries regarding financial, expenditure, revenue/fund status, appropriation transfers, supplemental appropriations, and variance reports to management to enable financial and budgetary monitoring and control
• Evaluates monthly financial and operational performance against plan, prior year, and forecast
• Identifies and advises higher level Financial Analysts or on occasion, agency or departmental staff on budget overruns, revenue shortfalls, and other financial problems; recommends options and solutions; and works with the supervisor to resolve problems
• Draws charts and graphs, using computer spreadsheets, to illustrate technical report
• Compiles and analyzes accounting records and other data to determine the financial resources required to implement a program
• Performs special projects and other duties as assigned

Education
Bachelor's degree from an accredited college or university, with a major course of work in accounting, business, public administration, or a closely related field. Such education must include at least twenty-four (24) semester (36 terms) credits of coursework in accounting, finance, or economics.

Experience
Minimum of two years of professional experience providing a systematic review, analysis, interpretation, and evaluation of budgets, loans or other financial data is required.

Equivalency
Equivalent combinations of education and experience that provide the required knowledge, skills, and abilities will be evaluated on an individual basis.

Evaluation Plan

• Interview: 70%
• Evaluation of Training, Experience & Personal Qualifications: 30%
• Total of Interview and Evaluation T.E.P: 100%

Additional points may be awarded for:

• Veteran Points: 0 – 15 points
• Detroit Residency Credit: 15 points

LRD:02/21/2023