Federal Financial Management SME/Senior Accountant – Federal Systems

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 UFMS–ASAP 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.