"Alerted.org

Administrative Special Services Staff II (ARPA) - Accountant 2

Print (https://www.governmentjobs.com/careers/detroit/jobs/newprint/4965713)

Apply



Administrative Special Services Staff II (ARPA) - Accountant 2

Salary

$56,807.00 - $70,000.00 Annually

Location

Coleman A Young Municipal Center, MI

Job Type

Appointed-Directors-Discretion of Mayor/Leg Body

Remote Employment

Flexible/Hybrid

Job Number

202504929102OCFODJ

Department

ARPA STAFFING

Division

ARPA Staffing

Opening Date

06/06/2025

Closing Date

6/20/2025 11:59 PM Eastern

Bargaining Unit

9801-Administrative Special Service-Non-Exempt

+ Description

+ Benefits

+ Questions

Description

The City of Detroit is currently accepting applications for an Administrative Special Services Staff II (ARPA) - Accountant 2 to work within the Office of the Chief Financial Officer (OCFO).

The Administrative Special Services Staff II (ARPA) - Accountant 2 is an intermediate level accounting professional within the City of Detroit Office of the Chief Financial Officer. The Administrative Special Services Staff II (ARPA) - Accountant 2 performs significant accounting duties that are required to support timely and accurate financial statement reporting. The key services provided include, but are not limited to: preparing, analyzing, interpreting, and presenting accounting data; operating, maintaining, and modifying accounting systems; using accounting information to recommend solutions to management problems and structuring of organization programs; managing, operating, and analyzing cost accounting systems in connection with functions, activities and financial operations; and designing, implementing, and assessing internal control processes and systems. Many of these services will be performed within the appropriate modules of the ERP Cloud that impact the operations of this position.

Examples of Duties

Using ERP Cloud applications performs the following activities:

1. Creation of Financial Reports

2. Editing of reporting templates

3. Use of Business Intelligence Publisher templates and data models

4. Creation of Transactions Business Intelligence dashboard and reports

5. Analysis of data through SmartView and Account Monitor

+ Identifies accounting problems such as inadequate maintenance of fund controls, inaccurate records and reports, improper methods for document control, and lack of documentary evidence to support performance of regulatory reconciliations

+ Conducts searches and examinations of budget and financial records to provide factual data on the amount and type of funds available for submission to others within the employing entity who will use the data to prepare budget estimates and reprogramming actions

+ Compiles centrally requested cost reports and reports of variance from standards. Develops reports comparing actual results to plans and budgets

+ Conducts special cost analysis of various operations to determine, for example, if proposals for revised methods or new equipment would affect savings. Performs statistical analyses of agency productivity trends. Participates with other accountants in developing cost estimates for in-house projects and contractor proposals

+ Tracks ongoing operations and solves problems that arise; studies existing reports, accounts, or instructions to streamline operations or provides reports with greater detail; prepares specific instructions for ongoing operations; documents accounting system features designed by higher level accountants; and advises managers or others when transactions differ from norms on nature and volume

+ Uses conventional accounting methods to reconcile payroll system and general ledger payroll data and to analyze internal controls over accounts receivable overpayments

+ Prepares, examines, or analyzes accounting records, financial statements, or other financial reports to assess accuracy, completeness, and conformance to reporting and procedural standards

+ Reports to management regarding the finances of establishment

+ Establishes tables of accounts and assigns entries to proper accounts Develops, implements, modifies, and documents recordkeeping and accounting systems, making use of current computer technology

+ Assists in executing portions of an audit plan that tracks process flow, verifies reported data, or assures that functional operating instructions generate desired results

+ Computes taxes owed and prepares tax returns, ensuring compliance with payment, reporting, or other tax requirements

+ Performs accounting functions consistent with Generally Accepted Accounting Principles (GAAP), standardized bookkeeping processes, accounting terminology, accounting techniques, and other financial rules and regulations

+ Researches, analyzes, and implements accounting rules and regulations as stipulated by Governmental Accounting Standards Board (GASB) or other regulatory agencies

+ Compiles and analyzes statistical and accounting data relative to the preparation and monitoring of the Annual Budget; Prepares and updates revenues and expenditures, base requests, changes adjustments, rate and fee setting, position changes, and budget set-up

+ Posts journal entries, reconciles dates, and manages inter-agency billings and transfers required to support financial reporting

+ Provides experience in using the specific procedures of automated systems to find, review, or change accounting data in transaction files, ledgers, accounts, summary reports, and financial statements

+ Performs grant management, monitoring, and administrative duties and activities (e.g. financial, set-up, post-award, closeout, etc.) to ensure timely expenditures and reimbursement, and regulatory and audit compliance

+ Checks data and compares reports or transactions to source documents, or authorizations against transactions to ensure their acceptability for further processing

+ Creates accounting codes and structures to ensure accurate recording, reporting, and control in financial systems; Participates in annual audits

+ Conducts surveys; Prepares recommendations for revision and participates in development and installation of accounting and fiscal procedures and methods

+ Maintains ledger and computer systems required to conduct payroll and financial reporting

+ Acts as a liaison between accounting staff, financial staff, information systems staff, and other key departmental staff in order to keep abreast of issues and initiatives that may impact accounting and financial information

+ Presents, prepares, and explains to financial and non-financial managers, co-workers, and clients an analysis of the issues, problems, and trends identified; Creates accounting procedures, internal controls, policies, and recommendations for business re-alignment

+ Assists in the preparation of the Consolidated Annual Financial Report (CAFR)

+ Performs special projects and other duties as assigned

Minimum Qualifications

Education:

BS degree in Accounting from an accredited college or university, with major course work in accounting, finance, business administration, statistics, or a closely related field.

Experience:

Two years or more of Accounting experience

Equivalency:

Equivalent combinations of education and experience may be substituted to meet the education and experience requirements of this position.

Supplemental Information

Licensing and Certifications License / Certificates Possession of a CPA may be substituted for one year of Accountant II experience. Possession of a Certified Management Accountant certification (CMA) may be substituted for six months of Accountant II experience. Possession of a CPA and/or CMA certification is preferred.

Knowledge, Skills and Abilities

Knowledge of:

+ Theories, practices, methods, and techniques of accounting, financial, and operational auditing and financial management

+ Standardized bookkeeping processes, accounting terminology, generally accepted accounting procedures (GAAP), accounting techniques, and other financial rules and regulations

+ Federal grant policies, procedures, and reporting requirements

+ Grants Management accounting, including SEFA and other requirements

+ Cost accounting and cost funding procedures

+ Procurement policies and practices of the City of Detroit

+ Techniques commonly used in locating errors in accounting records

+ Arithmetic, algebra, geometry, calculus, statistics, and their applications 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, human resources, and other management systems and software programs.

Skill in:

+ Use of personal computers

+ Use of Microsoft Office (e.g. Word, Excel, Access, PowerPoint) and other office suite software packages

+ Use of Excel (e.g. Formulas, Pivot Tables, Vlookup, Hlookup, other functions, charts, tables) and other financial management software packages functionality

+ Use of large, complex, multi-departmental financial systems and demonstrate the knowledge required to interpret resulting financial and accounting reports, summaries, and budgets

+ Analytical and problem solving

+ Interpersonal skills to interact effectively with personal contacts in a business-like, customer service oriented manner, and maintain favorable public relations

+ 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 mathematics to solve problems Presenting concise financial information to a variety of audiences

+ Presenting concise financial information to a variety of audiences

Ability to:

+ Analyze and interpret fiscal, accounting, and other data and reports

+ Advise City Agencies and the Office of the Chief Financial Officer (OCFO) staff on appropriate accounting polices, procedures, and requirements

+ Maintain general and subsidiary ledgers and journals and to prepare, analyze, and maintain regular financial statements and reports

+ Collect, organize, and interpret accounting data, tax rules, and regulations; synthesize data and work cross functionally to create and establish accounting guidelines, policies, and memos

+ Prepare accurate and reliable financial reports

+ Present accounting data orally, in writing, or in PowerPoint in a clear and understandable manner to both technical and non-technical users

+ Analyze and recommend improvements in accounting systems

+ Formulate solutions to difficult and complex accounting and related financial problems

+ Utilize independent judgment

+ Understand cost-benefit and business case analyses to provide insight and recommendations regarding best accounting methodology and suggestions to improve outcome

+ Learn and use contemporary financial management software and other related software for program and financial management systems

+ Interact effectively with senior leadership, subordinates, department personnel, and others with tact and diplomacy

+ Listen to and understand information and ideas presented through spoken words and sentences

+ Communicate information and ideas in speaking so others will understand

+ Make mathematical computations

+ Work as part of a team

Distinguishing Characteristics

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 (x) 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. 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 (x) 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.

Appointment term is based upon 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.

01

Do you possess a Bachelor's Degree from an accredited college or university, with major course work in accounting, finance, business administration, statistics, or a closely related field?

+ YES

+ NO

02

Describe your professional experience and hands-on responsibility related to grant fiscal support, accounting, public budgeting, and/or finance?

03

Select your skill level using all functions of Microsoft Excel in an accounting/finance work environment?

+ None

+ Entry level

+ Working level

+ Expert level

04

Please describe your experience with the evaluation of accounting data and the preparation of related financial and managerial reports.

Required Question

Employer

City of Detroit

Address

Coleman A. Young Municipal Center 2 Woodward Ave ste 316 Detroit, Michigan, 48226

Website

http://www.detroitmi.gov/Detroit-Opportunities/Find-A-Job

Apply

Please verify your email address Verify Email