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 ledgerreconciled 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. 

Qualifications :

• Masters 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 Bachelors 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 Masters 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 PBCs 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. 

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