Database specialist Jobs in Lynn, MA

Grant Specialist

The Grant Specialist (GS) reports to the Director of Post Award Grant Accounting and assists with overseeing the financial management and compliance of all sponsored grants and contracts awarded to the Boston Public Health Commission (BPHC). This position will provide financial and grant management oversight and leadership to the programmatic staff, while ensuring that BPHC meets the terms and conditions of the sponsors/funders by tracking and meeting report deadlines, managing audit compliance, and implementing institutional policies and procedures. Responsibilities for this position include, but are not limited to, the following:

• Maintain financial management and oversee compliance for an assigned portfolio of grants and contracts; in accordance with government regulations, funder requirements, and BPHC Policies.
• Review new/revised grants/contracts set-up requirements within accounting system for accuracy and compliance.
• Work collaboratively with programs & departments to ensure compliance requirements of grants/contracts are met.
• Assist with managing annual Uniform Guidance Audit and other sponsor audits as necessary.
• Review grant-related financial transactions prior to entry into accounting system.
• Ensure project expenditures are expensed in accordance with the terms and conditions of the award and/or BPHC policy.
• Review general ledger for unallowable costs posted to awards.
• Prepare detailed, accurate, timely, and quality financial analyses of grant transactions. Ensure that project records are kept in good order and readily available for review and audit.
• Ensure that the project complies with all appropriate Commission payroll, reimbursement, accounting, and personnel policies and practices.
• Ensure cost-share budget and expense reports comply with BPHC's cost-sharing policy and are available for audit.
• Advise and assist Program Directors (PDs) and Bureau Administrators (BAs) in fulfilling the departmental award closeout requirements in accordance with the sponsor's and BPHC's closeout policies.
• Provide backup coverage to the other grants specialists for vacation coverage or during high volume.
• Other job-related duties as assigned.

Grant Accounting/Budgeting:

• Assist PDs and BA's in the financial management of new and continuing grants/contracts, including budget amendments, budget-to-actual analysis, no-cost extensions, close-outs, reporting, and interpretation of sponsor/funder regulations.
• Routine review of project expenditures, including fringe benefit and facilities and administration costs.
• Process invoices to grantor agencies/funders in a timely manner and monitor collection of grant receivables.
• Reconcile grant A/R billings with cash receipts and financial reports. Work to resolve discrepancies with the Accounting team.
• Prepare grant-related journal entries, including salary and wage, indirect expense allocations and reclassifications.
• Ensure that cost transfers resulting from unusual circumstances or unanticipated project expenses are appropriately documented and transferred to the correct source of funds prior to close-out of the award.
• Meet regularly with PDs and BAs to keep them apprised of the grant/contract's progress, review project financial transactions/reconciliations, and provide direction where needed.
• Monitor encumbrance balances on a monthly basis and ensure that the balance reflects current purchase obligations for the award and that obsolete purchase orders are voided or closed on a timely basis.
• Assist in the preparation of grant/contract financial reports or invoices that require confirmation of completion of deliverables prior to submission or any required supplemental information.

Minimum Skill Set and Qualifications:

• Minimum requirements BA/BS in Finance, Accounting, Business, or related field required or; Associate Degree in Finance, Accounting, Business, or related field and 2 years transferable Post-AWard Grants experience or; 4 years of transferable Post-Award Grants experience may be substituted in lieu of degree.
• Plus at least 2-3 years of transferable Post-Award Grants experience is required.
• Prior experience working with a nonprofit or a city/municipal agency is preferred.
• Master's Degree a Plus
• Comprehensive knowledge of the Federal Uniform Grant Guidance, OMB 2 CFR 200. An understanding of related federal and state rules, regulations, policies, and procedures as well as the ability to interpret those of other sponsoring agencies, including federal subaward monitoring policies a plus.
• Experience with Microsoft Great Plains 2018 or ReQlogic requisitioning software a plus.
• Ability to solve problems, think logically, take initiative, and pay attention to detail. Able to organize complex and diverse information. Able to work in a fast paced, deadline driven environment. Excellent quantitative skills, including ability to analyze data.
• Must be self-motivated with the ability to work effectively as an individual or as a member of a team.
• Excellent communication (both oral and written) and interpersonal skills, with the ability to work effectively and efficiently with all levels of staff and management.

Additional Information:

• Boston residency is required.
• A Criminal Offenders Records Information (CORI) request must be completed for this position. However, a record is not an automatic bar to employment but is reviewed in relation to the job applied for.
• Any position that requires an advanced degree will be subject to education verification.
• The Boston Public Health Commission is an Equal Opportunity Employer and all applicants meeting the minimum qualifications are eligible to apply.