Responsibilities:
Financial operations and reconciliations (lead workstream ownership)
- Lead recurring operational support across grant and non-grant financial processes ensuring accurate recordation support reconciled results and defensible working papers for monthly/quarterly/annual reporting.
- Perform and continuously improve cross-enterprise reconciliations among UFMS JustGrants ASAP and relevant legacy data sources; research discrepancies document root causes and define requirements for permanent fixes when patterns emerge.
- Execute and enhance daily UFMSASAP payment reconciliation communicate results to stakeholders and support timely correction of rejected transactions and recurring authorization issues (including outreach/guidance to recipient users when needed).
- Maintain/enhance operational reconciliation tools and workflows including:
- Treasury CARS reconciliation support (identify cash differences provide remediation paths)
- Undelivered Order (UDO) analysis for grant and non-grant (identify GL differences posting errors)
- Advance drawdown liquidation monitoring and issue routing for resolution to protect GTAS/financial statement accuracy
- Excess cash analysis tool refreshes and monitoring aligned to SF-425 windows
Accruals reimbursables and enterprise support
- Support quarterly generation and refinement of grant and non-grant accrual draft entries (including lookback analyses and methodology updates) using MS Access automation and trend forecasting.
- Produce and reconcile enterprise extracts required to generate the Provider List (reimbursable agreement activity) ensuring GL tie-out and correct formatting for downstream use.
- Provide recurring accounting and budget process support by building ad hoc queries (MS Access/SQL) across enterprise data sources integrating results into USSGL-centric analysis and translating findings for accounting budgetary and grants viewpoints.
Tooling automation and documentation
- Develop/maintain MS Access databases queries reports and (as needed) VBA-enabled applications that automate reconciliations and controls including ODBC connections to Oracle-based UFMS data stores and other enterprise sources.
- Author time-sensitive ad hoc Oracle SQL Developer queries and produce reconciled outputs suitable for management and audit consumption.
- Contribute to preventative/detective controls and documentation that strengthen the internal control environment and auditability of financial statement data.
Leadership and coordination
- Serve as O&R workstream lead prioritizing work setting quality standards coordinating handoffs with other SMEs/subcontractor staff and ensuring repeatable processes and timely delivery.
- Provide status inputs for the monthly reporting/invoicing cycle including clear articulation of work performed issues/risks and next steps.
Qualifications :
- Education: Masters degree in Accounting Business Administration or similar; or bachelors degree plus 8 years of recent federal accounting system analysis/reporting experience in lieu of the Masters requirement.
- Experience: Minimum 10 years of recent experience supporting federal financial systems including complex reporting reconciliation and operational accounting support.
- Technical: Expert MS Access and MS Excel skills; strong SQL skills; demonstrated ability to use ODBC to connect to enterprise Oracle databases; ability to reconcile subsidiary/detail data to USSGL/GL.
- Domain: Strong knowledge of federal accounting/reporting practices (GAAP concepts as applicable in the federal environment; familiarity with SFFAS and OMB reporting/control expectations); experience supporting grant financial reporting data (e.g. SF-425) and analyzing spending patterns.
- Systems (preferred): UFMS (CGI Momentum) JustGrants ASAP Treasury CARS and working knowledge of legacy DOJ financial/grants data sources.
Security / Eligibility:
- Ability to obtain/maintain required Public Trust clearance consistent with a Moderate Risk/T2 investigation (or equivalent requirement stated for the effort); U.S. citizenship and DOJ residency requirements apply.
Additional Information :
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.
Remote Work :
No
Employment Type :
Full-time
Responsibilities: Financial operations and reconciliations (lead workstream ownership) Lead recurring operational support across grant and non-grant financial processes ensuring accurate recordation support reconciled results and defensible working papers for monthly/quarterly/annual reporting. Perf...
Responsibilities:
Financial operations and reconciliations (lead workstream ownership)
- Lead recurring operational support across grant and non-grant financial processes ensuring accurate recordation support reconciled results and defensible working papers for monthly/quarterly/annual reporting.
- Perform and continuously improve cross-enterprise reconciliations among UFMS JustGrants ASAP and relevant legacy data sources; research discrepancies document root causes and define requirements for permanent fixes when patterns emerge.
- Execute and enhance daily UFMSASAP payment reconciliation communicate results to stakeholders and support timely correction of rejected transactions and recurring authorization issues (including outreach/guidance to recipient users when needed).
- Maintain/enhance operational reconciliation tools and workflows including:
- Treasury CARS reconciliation support (identify cash differences provide remediation paths)
- Undelivered Order (UDO) analysis for grant and non-grant (identify GL differences posting errors)
- Advance drawdown liquidation monitoring and issue routing for resolution to protect GTAS/financial statement accuracy
- Excess cash analysis tool refreshes and monitoring aligned to SF-425 windows
Accruals reimbursables and enterprise support
- Support quarterly generation and refinement of grant and non-grant accrual draft entries (including lookback analyses and methodology updates) using MS Access automation and trend forecasting.
- Produce and reconcile enterprise extracts required to generate the Provider List (reimbursable agreement activity) ensuring GL tie-out and correct formatting for downstream use.
- Provide recurring accounting and budget process support by building ad hoc queries (MS Access/SQL) across enterprise data sources integrating results into USSGL-centric analysis and translating findings for accounting budgetary and grants viewpoints.
Tooling automation and documentation
- Develop/maintain MS Access databases queries reports and (as needed) VBA-enabled applications that automate reconciliations and controls including ODBC connections to Oracle-based UFMS data stores and other enterprise sources.
- Author time-sensitive ad hoc Oracle SQL Developer queries and produce reconciled outputs suitable for management and audit consumption.
- Contribute to preventative/detective controls and documentation that strengthen the internal control environment and auditability of financial statement data.
Leadership and coordination
- Serve as O&R workstream lead prioritizing work setting quality standards coordinating handoffs with other SMEs/subcontractor staff and ensuring repeatable processes and timely delivery.
- Provide status inputs for the monthly reporting/invoicing cycle including clear articulation of work performed issues/risks and next steps.
Qualifications :
- Education: Masters degree in Accounting Business Administration or similar; or bachelors degree plus 8 years of recent federal accounting system analysis/reporting experience in lieu of the Masters requirement.
- Experience: Minimum 10 years of recent experience supporting federal financial systems including complex reporting reconciliation and operational accounting support.
- Technical: Expert MS Access and MS Excel skills; strong SQL skills; demonstrated ability to use ODBC to connect to enterprise Oracle databases; ability to reconcile subsidiary/detail data to USSGL/GL.
- Domain: Strong knowledge of federal accounting/reporting practices (GAAP concepts as applicable in the federal environment; familiarity with SFFAS and OMB reporting/control expectations); experience supporting grant financial reporting data (e.g. SF-425) and analyzing spending patterns.
- Systems (preferred): UFMS (CGI Momentum) JustGrants ASAP Treasury CARS and working knowledge of legacy DOJ financial/grants data sources.
Security / Eligibility:
- Ability to obtain/maintain required Public Trust clearance consistent with a Moderate Risk/T2 investigation (or equivalent requirement stated for the effort); U.S. citizenship and DOJ residency requirements apply.
Additional Information :
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.
Remote Work :
No
Employment Type :
Full-time
View more
View less