Financial Analyst (Special Services Arpa)

Salary : $49,982.40 - $99,985.60 Annually
Location : MI, MI
Job Type: Appointed-Directors-Discretion of Mayor/Leg Body
Job Number: 20230199929107SR
Department: ARPA STAFFING
Opening Date: 03/13/2024
Bargaining Unit: 9000
Description
The successful candidate will play a critical role on the Jobs, Economy & Detroit at Work team led by the Mayor's Group Executive of Jobs, Economy & Detroit at Work to ensure the programming and compliant spending of these stimulus dollars, meant to spur a robust and equitable economic recovery and provide needed support to residents across the City. Foundational investments will be made in nearly every aspect of Detroit including economic development, workforce development, home ownership and repair, healthcare, digital inclusion, parks and recreation, blight remediation, infrastructure, and transportation. Priorities will be determined based on community engagement and informed by existing data and results of past initiatives.
Examples of Duties

• Ensures invoices are in compliance with appropriate contracts, guidelines and regulations; Reviews invoices for billing accuracy and for the reconciliation of unbilled balances
• Ensures proper documentation and placement of program budgets
• Acts as liaison to OCFO and other City agencies to ensure proper tracking and spending of ARPA finances
• Develops, implements, monitors, and ensures compliance of financial and operational performance measures
• Prepares monthly, quarterly, and ad-hoc financial analyses and reports to maintain expenditure control; Provides information to relevant leadership as requested
• Prepares, provides, and responds to requests and inquiries regarding financial, expenditure, revenue/fund status, appropriation transfers, and variance reports to management to enable financial and budgetary monitoring and control; Compiles information to fit various audiences
• Summarizes budgets, submits recommendations, and prepares reports for the approval or disapproval of Notice of Funding Availability, Request for Proposal, or Amendment applications or requests
• Develops cost analyses of projects or performs cost benefit or economic evaluations of current or projected programs and explore alternative financing or procurement methods.
• Prepares budget proposals and supports proposals to OCFO as assigned
• Prepares program closeout reports as assigned, in collaboration with relevant City agencies
• Performs special projects and other duties as assigned to ensure efficient, effective and compliant management of ARPA funds

Minimum Qualifications
Minimum Qualifications:

• Bachelor's degree required in business/finance, public administration, public policy, economics, accounting, or related field.
• Two years of professional experience in reviewing, analyzing, developing and monitoring government grant programs, including analysis of and reporting on management and programmatic issues having budgetary implications
• Demonstrated experience in collaborative project management role in public, private, or non-profit sector setting
• Experience with federal grant compliance (2 CFR 200) is highly desirable.
• Demonstrated proficiency with integrated word processing and spreadsheet functions.
• Master's degree preferred but not required in business/finance, policy, technology, engineering, or related field.
• Demonstrated interest in the field of work of economic and workforce development is highly encouraged but not required.

Supplemental Information
Appointment term is based on availability of grant funds
Medical Plan Offering for Administrative Special Services Employees
The City of Detroit is pleased to continue to provide a medical plan option to our Administrative Special Services Employees for the 2020 plan year. This plan is provided by Blue Care Network of Michigan and utilizes their PCP Focus Network. This plan provides you with the opportunity to receive an enhanced level of benefits and pay less out of your paycheck for your medical plan. There are two important requirements that you should consider and understand if you should decide to enroll in this plan. You will have to choose a primary care physician that serves within the PCP Focus network. This primary care physician coordinates your care. The network includes over 22,000 Primary Care Physicians. There are also Wellness Requirements that you (the subscriber) must meet in order to remain in the enhanced level of benefit.
Administrative Special Services Staff (Exempt) are eligible for the following benefits:

• CURRENT SICK LEAVE - Granted (3) months of continuous service. (1) day per month, not to exceed (12) days per year.
• VACATION - Granted (1) day per pay period, not to exceed 20 days per fiscal year
• PAID HOLIDAYS - Granted if paid for 600 straight time hours in the (12) months prior to the holiday
• MILEAGE REIMBURSEMENT - Granted on same basis as regular employees.
• WORKERS COMPENSATION - Covered by applicable laws.
• UNEMPLOYMENT COMPENSATION - Covered by applicable laws.
• HOSPITALIZATION - You are eligible to purchase healthcare benefits for yourself and your dependents under a group rate. You will be responsible for the full premium, no employer contribution will be applied.Please review the Health Care Plan Options Booklet for more detailed information.
• This position is not eligible for the City Pension Plan, dental, vision, optical, death, life, disability, funeral, reserve sick or jury duty.

Administrative Special Services Staff (Non-Exempt) are eligible for the following benefits:

• CURRENT SICK LEAVE - Granted (3) months of continuous service. (1) Day per month, not to exceed (12) days per year.
• VACATION - Granted on the following basis:

Terms of Service Vacation leave Earned
Less than 6 months None
After 6 months & (1000 work hours)5 days
After 1 year An additional 5 days
2-5 years 10 days
6-7 years 11 days
8-9 years 12 days
10-12 years 13 days
15- years15- years

• PAID HOLIDAYS - Granted if paid for 600 straight time hours in the (12) months prior to the holiday
• OVERTIME - Granted on same basis as regular employees.
• MILEAGE REIMBURSEMENT - Granted on same basis as regular employees.
• WORKERS COMPENSATION - Covered by applicable laws.
• UNEMPLOYMENT COMPENSATION - Covered by applicable laws.
• HOSPITALIZATION - You are eligible to purchase healthcare benefits for yourself and your dependents under a group rate. You will be responsible for the full premium; no employer contribution will be applied.Please review the Health Care Plan Options Booklet for more detailed information.
• This position is not eligible for the City Pension Plan, dental, vision, optical, death, life, disability, funeral, reserve sick or jury duty.