CSCI Consulting

Accounting Data Scientist

CSCI Consulting

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

FluxSQL

About the role

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