Financial Analyst II (OCFO - Assessors Division)

City of Detroit; Michigan; On-site; USD 65,000 - 90,000; Full time

Job summary

City of Detroit is seeking a Financial Analyst II to perform professional financial analysis and support budgeting, forecasting, and multi-year planning for City Agencies. The role includes contributing to month-end close, preparing reports, and advising on financial performance.

The candidate will work with ERP cloud applications and MS Office, supporting strategic financial decisions within the Office of the Chief Financial Officer - Assessors Division.

Qualifications

• Bachelor’s degree with 24 credits in accounting/finance/economics.
• Master’s degree meets minimum experience for II level.
• 1 year of professional budgeting/financial analysis preferred.
• Proficiency with MS Office and ERP systems.

Responsibilities

• Provide routine and simple financial analyses for City Government and Agencies.
• Assist in budget-to-actual across multiple years and forecast trends.
• Prepare detailed reports explaining basis for conclusions.
• Support month-end close, variance analysis, and forecasting.
• Develop multi-year operating and capital plans with City Agencies.
• Create charts/graphs to illustrate financial results for management

Skills

GAAP knowledge

Financial analysis

Budgeting

Microsoft Excel

Communication

Education

Bachelor’s degree in accounting/business/public administration

Master’s degree qualifies as minimum experience

Tools

ERP Cloud

Microsoft Excel

PowerPoint

Job description

OFFICE OF CHIEF FINANCIAL OFFICER - ASSESSORS DIVISION

FINANCIAL ANALYST II

Be a Part of the City You Love!

The Office of the Chief Financial Officer - Assessors division is accepting applications for a Financial Analyst II position.

The Financial Analyst II performs an expanding range of professional analyst assignments in a developmental capacity. The Financial Analyst provides input and assists with routine and simple financial analyses concerning the City Government and other City Agency financial and operational results. The key services provided include, but are not limited to: participating in the examination, review, study or other financial analysis; assisting in the preparation of detailed reports to show sources of information and explain the basis for conclusions; participating in the making of recommendations on the basis of detailed analysis and evaluation; assisting in creating and tracking budget to actual across multiple years; and assisting to execute a month-end close process that includes variance analysis and forecasting.

• 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, monitor, and ensure 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 analyze accounting records and other data to determine the financial resources required to implement a program
• Performs special projects and other duties as assigned

Education

• For all Financial Analysts it is a requirement to have completed a bachelor’s degree from an accredited college or university, with 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.
• In addition, Financial Analysts with a Master’s Degree, such as Master in Business Administration, Master in Finance, Masters in Economics, and other appropriate and related courses of study meet the minimum experience required for Financial Analyst II.

Experience

• In addition to the minimum education requirements, the following experience requirements also apply:
• For entry into the Financial Analyst position, one (1) year of professional experience providing a systematic review, analysis, interpretation, and evaluation of budgets, loans or other financial data is preferred but not required.
• Financial Analyst must demonstrate proficiency with integrated word processing and spreadsheet functions.

• For selection, appointment to a Financial Analyst level II or higher, in addition to the minimum education requirements, more progressive levels of experience are required based on the following:

• Financial Analyst II – at least two (2) years of experience

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:01/22/2025

KNOWLEDGE, SKILLS,AND ABILITIES

Professional knowledge of accounting and, as required, auditing concepts, principles, and methods sufficient to work independently using conventional procedures and practices to do intermediate level work such as:

• Standardized bookkeeping processes, accounting terminology, generally-accepted accounting procedures (GAAP), accounting techniques, and other financial rules and regulations
• Business and management principles involved in strategic planning, resource allocation, leadership technique, and coordination of people and resources
• Economic and accounting principles and practices, the financial markets, banking, and the analysis and reporting of financial data
• Structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar
• Arithmetic, algebra, geometry, calculus, statistics, and their applications
• Standard procurement policies and practices
• Personal computer capabilities and the application of computer systems to issues of format and content in City and departmentalfinancial management
• Enterprise resource planning systems for finance, budget, general ledger, and other management systems and software programs

SKILLED IN:

• Identifying, synthesizing,and evaluatingsimple to semi-complex budget related issues and assignments,consolidatinginformation from a variety of sources, and selectingappropriate analyticalapproaches
• Presenting concise financial and operational information (orally, written, and/or using PowerPoint or Word) to a variety of audiences
• Use of Microsoft Office (i.e. Word, Excel, Access, PowerPoint, and / or other office suite software packages)
• Use of Excel (e.g.Pivot Tables,Vlookup,Hlookup, charts, tables, and / or other related software packages) functionality
• Communicating in writing clearly and effectively,demonstratethis skill byrenderingtechnical details and reports in a form readily understandable to management and the public
• Understanding written sentences and paragraphs in work related documents
• Giving full attention to what other people are saying, taking time to understand the points being made, asking questions asappropriate, and not interrupting at inappropriate times
• Using logic and reasoning toidentifythe strengths and weaknesses of alternative solutions, conclusions, or approaches to problems
• Talking to others to convey information effectively
• Establishing andmaintaininggood working relationship with other City employees and thepublic

ABILITY TO:

• Collect, quickly interpret, and analyze information from a variety of sources, apply criteria, draw conclusions,and develop recommendations, guidelines, and policies
• Read, interpret,and effectively analyze professional and technicalreports
• Choose the right mathematical methodsor formulas to solve a problem
• Plan, coordinate, set priorities, and supervise staff and others engaged in diversified fiscal analysis and forecasting activities
• Communicateinformation and ideasclearly and effectively both orally and in writingso they can be understood
• Read and understand information and ideas presented in writing
• Add, subtract, multiply, or divide quickly and correctlyApply general rules to specific problems to produce answers that make sense
• Work tactfully and effectively with employees, supervisors and managers, taxpayers, and with elected and appointed officials and senior staff in assigned Departments and Agencies
• Take initiative toacquire additionalknowledge and education toremaincurrent in field
• Work as part of a team

PHYSICAL DEMANDS

• The work is characterized as sedentary.
• Typically,Financial Analysts sit comfortably to do their work, interspersed by brief periods of walking, standing, bending, carrying of papers and books, and extended periods requiring the use of computer terminals toaccomplishworkobjectives.
• During extended periods each year, Financial Analysts may be required to work considerable overtime.

WORK ENVIRONMENT

• Work is performed in a comfortable office environment which is appropriately lighted, heatedand cooled.
• The work environment contains no significant hazards.
• Some work may require walking and standing in conjunction with travel to and attendance at meetings and conferences away from the work site.
• The Financial Analyst may encounter individuals that are upset.

Candidates considered for placement in this classification may be subject to a Criminal Background Investigation based on the requirements of the position.

The above statements describe the general nature and level of work performed by employees assigned to the class. Incumbents may be required to perform job-related responsibilities and tasks other than those stated in this specification. Specific job duties may vary from position to position. The City of Detroit is an Equal Opportunity Employer. No applicant for employment shall be discriminated against on the basis of race, color, national origin, sex, religion, age, disability, or other criteria prohibited by City, State, or Federal law.