Finance Specialist

The Staff Accountant is responsible for processing payroll, accounts receivables (AR) / accounts payable (AP), and supports the Council’s budgeting, audit grant, project, procurement, and Revolving Loan Fund (RLF reporting functions. Reporting to the Finance Director, the Staff Accountant maintains reliable accounting records, independently analyses and validates financial data, resolve reporting issues, and reconcile financial reports.

• Enter, review and maintain transactions and supporting records in Quick Books Desktop Enterprise (QBD), including timesheets, invoices, payments, deposits and related accounting data.
• Record journal entries, process payroll, accounts receivable, billing collections, and vendor and customer records maintenance.
• Extract, clean, combine, validate, and reconcile data from QBD, MS Excel, payroll, grants, banking, RL, and other approved sources.
• Support the annual budgeting process, financial audit, grant drawdowns, reimbursements, match documentation, reporting, closeout and procurement documentation.
• Prepare bank reconciliations and investigate related variances.
• Maintain organized and confidential financial records, provide backup for essential department functions, and perform other related duties as assigned.

The Staff Accountant will have:

• Working knowledge of US GAAP, reconciliations, accounts payable, accounts receivable, payroll support, and month-end closing.
• Advanced MS Excel skills, and working knowledge of Quick Books Desktop or Quick Books Enterprise.
• Ability to translate financial and operational requirements into reliable calculations, dashboards and clear management reports
• Strong analytical, data quality, documentation, organizational, and problem-solving skills with the ability to exercise discretion and independent judgment within assigned responsibilities.
• Ability to manage recurring deadlines, protect confidential information, communicate issues promptly, and work effectively with internal and external stakeholders.
• Ability to work well with people.

• Bachelor’s degree in accounting, Finance, Business Administration, or a related field is preferred
• At least 3 years of experience in accounting, financial analysis, financial reporting or related experience.
• Experience working with Power BI dashboards, Power Query and DAX preferred;
  Quick Books Enterprise and mid-advance MS Excel experience required.
• Government, non-profit, grant-funded, fund-accounting, public sector, and/or Revolving Loan Funds experience preferred.

Work is primarily performed in an office environment and requires extended computer use. Reasonable accommodation may be provided to enable qualified individuals to perform the essential functions.