Senior Financial Reporting & Data Lead; UFMS​/Momentum

• Full-time

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 using
  Oracle SQL
  against the UFMS real-time operational data store (ODS), including advanced SQL techniques appropriate forcomplex enterprise datasets.

Data analysis and cross-enterprise reconciliations

• Perform data analysis across major budgetary, accounting, and financial systems;identify anomalies, debug report errors, and reconcile financial data across
  
  Just Grants, ASAP, UFMS (and legacy grants 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 in
  AWS Athena
  to 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 in
  Tyler 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 in
  JEDI-NG
  , working with pre-definedcalc
  
  Views, 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 with appropriate 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; or Bachelor’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…