Accounting Data Scientist

CSCI Consulting

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

Posted 3/28/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

FluxSQL

About the role

Key responsibilities & impact

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

What you’ll need

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

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata extractiondata modelingmachine learningstatistical trend analysisdata miningdata pipelinesfinancial reconciliationautomated interfacesaudit readiness

Soft Skills

creativityadaptabilityproblem-solvingclient engagementorganizational skillstime-managementwritten communicationverbal communicationprofessional presence

Certifications

Bachelor’s degreeDoW Secret clearance