Accounting Data Scientist

Job Description

CSCI Consulting is looking for an Accounting Data Scientist to support our Department of War (DoW) client. In this role, the consultant will will leverage advanced analytics, SQL-based data modeling, and the ADVANA platform to support large-scale financial management and audit readiness initiatives. This role is responsible for transforming complex data from disparate systems into actionable financial insights, ensuring that the USSGL-compliant data within the General Ledger aligns with operational reality. 

Responsibilities

• 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
  

Minimum Requirements