Accounting Data Scientist : CSCI Consulting

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

• 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

Preferred Skills

• Ability to work in a team environment, as well as independently
• Strong customer and vendor relationship skills
• Demonstrated ability to comply with data standards and policies
• Motivation to learn new technologies and methodologies that demonstrate value
• Past experience working with a Federal agency
• Department of War experience is a plus!

About CSCI

CSCI is an award-winning information technology and financial management consulting firm founded on one simple philosophy: “Do what is right, always.” We apply this philosophy across all elements of our growing business, from delivering world-class services for customers to providing an environment where associates thrive both personally and professionally. At CSCI, work and fun aren’t diametrically opposed!

At CSCI, our goal is to hire people with proven track records and retain them with an energizing, diverse company culture. We value each associate’s natural drive to excel, and we provide them with the freedom to do things their way. CSCI seeks the best and brightest in the industry—those who are ready to move their lives and career forward. Join us today and get excited about Mondays again!

Benefits of Working at CSCI

• 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