Accounting Data Scientist

Role Overview

• Design and execute complex SQL queries to monitor the integrity of the entire USSGL chart of accounts, identifying abnormal balances or non-standard posting logic across the General Ledger
• Build automated "Tie-Point" analyses within ADVANA to ensure cumulative results of operations and net position are mathematically consistent across all financial statements
• Develop SQL-based models to automate the reconciliation between the Core Financial System and the SF-133 (Report on Budget Execution and Budgetary Resources) and the Schedule of Spending
• Create data pipelines that aggregate disparate data sources into a "Single Source of Truth" for the Consolidated Balance Sheet and Statement of Net Cost
• Implement machine learning or statistical trend analysis to perform "Fluctuation Analysis" (Flux) across fiscal years, highlighting significant variances for leadership review
• Automate the identification of "Unmatched Transactions" and "Trading Partner" Eliminations to streamline the intra-governmental reconciliation process
• Oversee the data flow from all subsidiary ledgers (Payables, Receivables, Property, and Payroll) into the General Ledger, ensuring that automated interfaces maintain USSGL compliance at the transaction level
• Perform deep-dive data mining to resolve systemic issues causing "Suspense" account bloating or "Journal Voucher" (JV) over-reliance
• Transform raw ADVANA data into interactive visual narratives for senior leadership, translating complex accounting adjustments into clear operational impacts
• Serve as the technical lead for data-driven "Audit Readiness" reviews, ensuring that all financial data is supported by a clean, digital audit trail

Requirements

• Bachelor’s degree in a related field
• Holds a DoW Secret clearance
• Mastery of SQL for data extraction and ADVANA (or similar big-data environments) for large-scale financial modeling
• Deep functional knowledge of the USSGL, including the relationship between budgetary and proprietary accounting
• Experience with FASAB standards and the Treasury Financial Manual (TFM)
• Creativity and adaptability in problem-solving
• Ability to work with clients to understand their needs
• Strong organizational and time-management skills
• Excellent written and verbal communication skills
• Professional presence

Tech Stack

• Flux
• SQL

Benefits

• Competitive salaries
• Generous Paid Time Off (PTO) package
• Paid holidays aligned to the Federal calendar
• Full health benefits including medical, dental, vision, and life insurance
• 401(k) retirement plan
• Team building events
• Professional development support