Senior Federal Financial Systems SME (UFMS / Momentum)

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.