Responsibilities:
Federal financial systems operations & reconciliations
- Provide expert support for grant and non-grant financial system operations and cross-system reconciliations.
- Reconcile and analyze data across grants management, grant payment, and financial systems; investigate discrepancies; document root causes and recommend fixes.
- Perform recurring operational support aligned to month-end and quarterly close processes.
Accruals, provider/reimbursable reporting, and key accounting functions
- Produce and refine quarterly grant accrual and non-grant accrual methodologies (including lookback analysis and concentration factor adjustments).
- Support complex reporting such as Provider Listing / reimbursable agreement reporting, revenue detail, and other grant accounting outputs.
- Develop reconciled working papers and support accurate recordation of accounting entries.
Financial reporting & analytics
- Develop and maintain general ledger–reconciled financial reports and executive-ready outputs.
- Build and enhance dashboards and reporting solutions that support accounting, budgetary execution, grants monitoring, and management insights.
- Create curated data marts and contribute to data dictionaries/metadata standards to improve transparency and organizational data literacy.
Tools & reporting environments (hands-on)
- Write advanced Oracle SQL (including analytical functions) for near real-time reporting needs.
- Build and maintain MS Access reports and automated applications (VBA), including ODBC connectivity across enterprise Oracle data sources.
- Develop dashboards/visualizations (e.g., Tableau) and support cloud/data-lake style querying environments (e.g., Athena-style SQL), where applicable.
Audit support & internal controls
- Provide substantial support during the annual external financial statement audit cycle by translating PBC requirements into reconciled technical reporting outputs.
- Design/improve automated and manual internal controls; support A-123/internal control testing response and other audit inquiries (e.g., oversight audits).
- Produce repeatable, auditable report generation processes and documentation.
- Master’s degree in accounting, Business Administration, or similar discipline from an institution accredited by one of the regional institutional accreditation agencies recognized by the U.S. Department of Education.
- Education Substitution - A Bachelor’s degree and eight years of recent (within the past decade) experience in the successful analysis and reporting of federal accounting system data, may be substituted for the Master’s requirement.
- Minimum of ten years recent (within the past decade) experience in the successful support of federal financial systems.
- Extensive experience in medium to complex enterprise system development and IT lifecycle management.
- 5-10+ years of experience in increasingly complex utilization of reporting technology, including SQL, MS Access, MS Excel, and other commercially available reporting tools.
- Extensive knowledge in the analysis and support of financial management systems, as well as knowledge of federal government accounting and reporting practices.
- Understanding of Generally Accepted Accounting Principles (GAAP), SFFAS 1, Accounting for Selected Assets and Liabilities.
- Experience in analyzing and predicting grantee spending patterns.
- 7+ years’ experience with key accounting functions required to produce federal financial statements, including calculation and verification of grant accrual, prior year up/down adjustments, accounting for reimbursable agreements.
- Ability to produce detailed, accurate, and reconciled PBC’s associated with above OJP accounting functions within very short financial statement deadlines.
- Expert experience with MS Access and MS Excel and extensive knowledge on how to use these tools to extract, analyze, and report financial data.
- Knowledge of SF-425 - Federal Financial Report (FFR) and the ability to use the FFR to analyze spending patterns and cycles.
Benefits:
- Referral Bonus
- (401k) Matching
- Holidays – Eleven
- Adoption Assistance
- Tuition Reimbursement
- Technology Reimbursement
- Short-Term & Long-Term Disability
- Life Insurance (Basic, Voluntary & AD&D)
- 80% Employer Paid Health Care Plan (Medical, Dental & Vision
- Paid Time Off (0-3 years - 15 Days PTO | 3+ years 20 Days)
- Perks at Work – Employee perks program that helps you live a better and healthier life.
i360 is an Equal Opportunity Employer - Minority/Female/Veteran/Disability
All qualified applicants will receive consideration for employment regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or status within any other protected group.
Only Direct Hires - No recruiting or staffing firms’ submissions will be considered.
