Financial Analyst IIBe 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. Examples of DutiesUsing 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
Minimum Qualifications:
EducationFor 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
- Supplemental Information
- 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 pointsKNOWLEDGE, SKILLS, AND ABILITIESProfessional 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 departmental financial management Enterprise resource planning systems for finance, budget, general ledger, and other management systems and software programsSKILLED IN :Identifying, synthesizing, and evaluating simple to semi-complex budget related issues and assignments, consolidating information from a variety of sources, and selecting appropriate analytical approaches 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, demonstrate this skill by rendering technical 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 as appropriate, and not interrupting at inappropriate times Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems Talking to others to convey information effectively Establishing and maintaining good working relationship with other City employees and the publicABILITY 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 technical reports Choose the right mathematical methods or formulas to solve a problem Plan, coordinate, set priorities, and supervise staff and others engaged in diversified fiscal analysis and forecasting activities Communicate information and ideas clearly and effectively both orally and in writing so they can be understood Read and understand information and ideas presented in writing Add, subtract, multiply, or divide quickly and correctly Apply 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 to acquire additional knowledge and education to remain current in field Work as part of a teamPHYSICAL DEMANDSThe 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 to accomplish work objectives. During extended periods each year, Financial Analysts may be required to work considerable overtime.
