Senior Financial Reporting & Data Lead (UFMS/Momentum)

At i360technologies,we'rea team of driven professionals specializing in business consulting and technology services for federal agencies.We'repassionate about solving complex challenges through strategic thinking and innovative solutions. Since our founding in2001,we'vefostered a collaborative, fast-paced environment where initiative is recognized, professional growth is encouraged, and careers flourish. We offer competitive pay, comprehensive benefits for full-time employees, and abundant opportunities for advancement. Ifyou'remotivated, solutions-oriented, and ready to make an impact,you'llfind a rewarding and supportive home at i360.

Enterprise reporting leadership (cloud + on-prem)

• Lead development, maintenance, and enhancement of custom financial reports and executive dashboards, including mission-critical operational reporting across budgets, commitments, obligations, payments, collections, AR/AP, and workflow/approvals metrics.
• Build dashboards and data visualizations using Tableau (prototype, refine, publish), incorporating interactivity (actions/tooltips) to support what-if analysis, anomaly detection, and leadership "financial health" indicators.
• Author andoptimizetime-sensitive ad hoc reporting usingOracle SQLagainst the UFMS real-time operational data store (ODS), including advanced SQL techniquesappropriate forcomplex enterprise datasets.

Data analysis and cross-enterprise reconciliations

• Perform data analysis across major budgetary, accounting, and financial systems;identifyanomalies, debug report errors, and reconcile financial data acrossJustGrants, ASAP, UFMS (and legacygrants financial datawhere needed).
• Research discrepancies, document root causes, and translate recurring failure patterns into clear requirements for system/reporting fixes.
• Build reusable grant reporting data marts and curated datasets that enable multi-perspective analysis and improve staff data literacy and interpretation.

Cloud data lake reporting & governance

• Develop complex SQL queries/views inAWS Athenato support enterprise data marts; deploy reconciled SQL as views for daily publishing into the cloud governance/reporting layer, managing timing differences caused by once-daily refresh cycles.
• Maintain and publish curated datasets and dashboards inTyler Socrata, including dataset assets, filtered views, charts, and story assets, integrating Tableau content (e.g.,iFrames/workbooks) for cohesive user experience.
• Develop and refine DOJ-wide reports inJEDI-NG, working with pre-definedcalcViews, iterating with stakeholders, and coordinating publishing with the host organization.

Data dictionary, standards, and documentation

• Build andmaintaina centralized data dictionary spanning UFMS and ASAP; define business rules for financial, budgetary, and grants variables; implement reusable metadata standards and naming conventions to improve reconciliation transparency and organizational data literacy.
• Create clear technical documentation for report logic, data lineage, and reconciliation approach so productsremainmaintainable andaudit-defensible.

MS Access reporting and rapid-turnaround data calls

• Develop professional, reconciled ad hoc reports using MS Access with heavy ODBC linkage/imports (Oracle tables, text, Excel, and Access sources), iterating incrementally with requestors (FOIA, program offices, leadership, auditors, Congress) to meet urgency and formatting expectations.
• Use Access queries to stage, scrub, and reconcile data; format final outputs withappropriate headings/totals; apply VBA for advanced presentation when needed.

Internal controls and audit enablement (supporting)

• Apply enterprise data and process knowledge to strengthen data quality and control monitoring through reporting and automation, supporting management insight into the health of operations and systems.

• Education:Master's degree in Accounting, Business Administration, or similar discipline; orBachelor'sdegree plus 8 years of recent federal accounting system analysis/reporting experience (substitution).
• Experience: Minimum 10 years of recent federal financial systems support experience, including medium-to-complex enterprise reporting technology and development lifecycle work.
• Technical Expertise: Strong skills inOracle SQL Developer, MS Access, and MS Excel; ability to reconcile subsidiary data to USSGL and leverage ODBC connectivity to enterprise Oracle databases for reconciled reporting outputs.
• Preferred Platform Experience: Tableau, AWS Athena, JEDI-NG, UFMS (CGI Momentum),JustGrants, ASAP, experience with authoring Socrata Dataset Assets, Filtered View Assets, Chart Assets, and Story Assets.
• Nice to haves:cBEYONDdatafinancial reporting platform,SAP Hana technologies, knowledge of baseline CGI Momentum database structure

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.