Supervisory Financial Analyst III (OCFO - ODFS DIVISION - CURRENT ODFS EMPLOYEES ONLY)

OFFICE OF CHIEF FINANAIL OFFICER - ODFS DIVISION

(CURRENT

ODFS EMPLOYEES ONLY

) Supervisory Financial Analyst III Be a Part of the City You Love! The Office of the Chief Financial Officer - ODFS division is accepting applications for a Supervisory Financial Analyst III position. Job Summary The incumbent of this position is a Supervisory Financial Analyst in the Office of the Chief Financial Officer (OCFO) of the City of Detroit. The Supervisory Financial Analyst III will be assigned to lead and supervise financial professionals and paraprofessionals. Supervisory Financial Analyst IIIs perform functions in the OCFO's Office of Departmental Financial Services. The Supervisory Financial Analyst III has primary responsibility for planning, implementing, supervising and controlling all financial analysis related activities of the teams and projects assigned. The incumbent is responsible for ensuring the implementation of the appropriate modules of the ERP Cloud that impact the operation supervised. The Supervisory Financial Analyst III supervises staff engaged in a wide range of functions including financial planning and analysis, cost studies and alternative analysis, and compliance and ad hoc analysis. For Placement in Office of Departmental Financial Services Departmental Financial Services Assure the effective management and financial integrity of agency operations by developing, implementing and monitoring city-wide and department-wide plans, policies and systems in the areas of program analysis/evaluation, strategic planning, and performance metrics. Agency Chief Financial Officers ("Agency CFOs") will develop, track, and provide actionable data to assess the performance of City operations. Staff monitor project plans, track budget to actual spending and integrates budget/ actual financial data with agency operational data.

DUTIES AND RESPONSIBILITIES

Using ERP Cloud applications supervises/manages 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 Partnerships with City Agencies to develop and monitor multi year operating and capital plans, reserve forecasts, and long range financial strategies oversees: Creation of Financial Reports and Analyses
• Compliance of financial and operational performance measures Using ERP Cloud Technology and through appropriate application modules: Prepares detailed financial forecasts and models, cost projections, and recommendations based on actual results Analyzes accounting records and other data to determine the financial resources required to implement a program Analyzes prior year expenditures, grant balances, and fund sources Establishes and uses performance measures to improve the quality, effectiveness, and efficiency of City services while minimizing the cost of program delivery Assesses overall performance of City operations Reviews cost-benefit analyses to compare operating programs, review financial requests, or explore alternative financing methods Evaluates monthly financial and operational performance against plan, prior year, and forecast Generates various ah-hoc financial and operational reports Performs inquiries and run reports Enters, manipulates, and analyzes financial data Calculates and consolidates financial data Makes investment decisions by analyzing financial information and forecasts related to City, industry, or economic conditions Reviews plans of action for investment prepared by subordinates; Approves or denies requests for investments using financial analyses Drives functional enhancements to planning and forecasting processes and activities and ensures best practices are used by subordinates, agencies, and other departments Provides supervisory consultation and assistance to subordinates in preparing budgets, grants, proposals and contracts; Interprets, applies, and enforces budget and financial guidelines Identifies and advises on budget overruns, revenue shortfalls and other financial problems for large departments; Recommends options and solutions and works with management to resolve problems Consults with other supervisors and managers to ensure that budget adjustments are made in accordance with program changes Performs special projects and other duties as assigned

GENERAL MANAGEMENT / SUPERVISORY DUTIES AND RESPONSIBILITIES

Supervises a subordinate staff of professionals and paraprofessionals who perform professional financial analysis work including financial planning and analysis, cost studies and alternative analysis, and compliance and ad hoc analysis. Plans work to be accomplished by subordinates including the implementation of the ERP Cloud modules and technology applications that impact the work supervised. Ensures compliance with all of the implementation guidelines required for successful implementation and use of new technologies. Identifies operational issues associated with ERP Cloud and new technology applications and brings these to the attention of higher-level personnel for resolution. Sets priorities and prepares schedules for completion of work. Assigns work to subordinates based on priorities, selective consideration of the difficulty and the requirements of the assignments, and the capabilities of employees Evaluates performance of subordinates including conducting periodic reviews of performance including a six month and annual review Gives advice, counsels, or instructions to individual employees on both work and administrative matters Interviews candidates for positions in his unit. Makes recommendations for appointment, promotion, or reassignment involving such positions. Hears and resolves complaints from employees. Refers group grievances and the more serious complaints not resolved to higher level supervisors. Recommends minor disciplinary measures such as warnings and reprimands. As needed, consults with specialists on training needs, and decides on training problems related to the units supervised including training in ERP Cloud applications and new technologies. Identifies developmental and training needs of employees in consultation with the Chief Learning Officer. Provides or makes provision for such development and training. Qualifications (required): Bachelor's degree from an accredited college or university, with major course work in accounting, business, public administration, or a closely related field. Such education must include at least twenty-four (24) semester (36 terms) credits for coursework in accounting, finance, or economics Minimum of two (2) years of relevant professional experience. Two (2) years of experience and must have two (2) years of verifiable experience leading teams and/or providing guidance and training to subordinate staff. Preferred Qualifications Completion of the Supervisor Training Program Licenses, Certifications and Other Special Requirements Possession of a Certified Financial Planning and Analysis (CFPA) certificate sponsored by Association of Finance Professionals. 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:

08/20/2024 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:

• Financial theory and principles and business management operations and practices
• Concepts, principles, practices, and methods of budget formulation, enactment and execution, accounting and finance functional area(s)
• Obtaining, compiling, and summarizing narrative information and quantitative data for use by others
• Economic and accounting principles and practices, the financial markets, banking, and the analysis and reporting of financial data
• Federal, state, and local legislation, regulations and ordinances affecting preparation, review, and implementation of operating and capital budget requests and financial analysis
• Established work methods and procedures
• Pertinent regulatory or statutory provisions in performing assigned financial and operational analysis and evaluation work
• Operation and organization of the Departments and Agencies appropriate to the affected position
• Techniques commonly used in locating errors in financial and operational reports and statements
• Structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar
• Personal computer capabilities and the application of computer systems to issues of format and content in City and departmental financial management
• Mathematical and statistical procedures generally employed in the fields of financial asset investment, accounting, and budgeting to verify data, to project costs, to budget, etc.
• Enterprise resource planning systems for finance, budget, general ledger, human resources, and other management systems and software programs Skill 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 public 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 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 team Physical Demands - The employee generally remains in a stationary position for an extended period of time operating standard office equipment which may include computers, telephones, photocopiers, and fax machines.

The employee is expected to move about to accomplish tasks such as opening file cabinets and moving files. Must be able to lift, push, pull, and carry up to 20 pounds. Work Environment - Work is performed primarily in an office environment. Some work requires travel to meetings, conferences, and other work sites with exposure to seasonal weather conditions.

PROBATIONARY PERIOD

Individuals appointed to a position in this class will be required to serve a probationary period of six months with the possibility of a six-month extension for a total of twelve months. The performance will be carefully evaluated during the probationary period. Continued employment in this class will be contingent upon the successful completion of the probationary period and meeting all of the performance expectation requirements.

THIS RECRUITMENT IS OPEN TO ACTIVE EMPLOYEES ONLY PLEASE ATTACH AN UPDATED RESUME AND ANY CERTIFICATIONS WITH YOUR APPLICATION INCOMPLETE APPLICATIONS WILL NOT BE CONSIDERED

Notes:

A review of the applicant's attendance records and work performance will be considered in the promotional process. Person applying must meet the position qualifications, including licensing and certifications. Completion of an evaluation process is required. If you have previously applied for this position, you must re-apply to be considered for this vacancy. 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.