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
- 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
- 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!
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
Legal
CSCI complies with all applicable Federal, state, and local employment regulations. Please reach out to [email protected] with any questions.
Equal Employment Opportunity
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or veteran status, or any other applicable state or federal protected class. CSCI provides affirmative action in employment for qualified Individuals with a Disability and Protected Veterans in compliance with Section 503 of the Rehabilitation Act and the Vietnam Era Veterans’ Readjustment Assistance Act.
If you require an accommodation, please contact CSCI Human Resources for further assistance. For questions regarding the qualifications listed above, please contact the CSCI Recruiting Team.
E-Verify
CSCI participates in E-Verify to confirm the employment eligibility of all newly hired employees. For more information, please visit www.dhs.gov/E-Verify.
California Consumer Privacy Act (CCPA) Notice
As part of the application and recruitment process, CSCI Consulting, Inc. may collect personal information as described under the California Consumer Privacy Act (CCPA).
This information is collected solely for employment-related purposes, including evaluating your qualifications, processing your application, and complying with legal obligations.
By applying to this position, you acknowledge that you have read and understand the following notice regarding the collection of your personal information as a job applicant:
- Categories of Information Collected: Personal identifiers, employment history, educational information, and any other information provided in your application or as part of the interview process.
- Purposes for Collecting Information: To review your application, assess your qualifications, and manage the hiring process.
- Retention and Security: Information collected will be retained indefinitely and will be securely stored and handled in accordance with CCPA guidelines and CSCI Consulting, Inc. policies.
- Rights of Applicants: Under CCPA, California residents have the right to request information about the personal data we collect, delete it, and request restrictions on certain uses. However, some information may be retained as required by law.
For further information, or to exercise your rights under the CCPA, please contact CSCI’s HR team.
Disclaimer
The above declarations are not intended to be an all-inclusive list of the duties and responsibilities of the job described, nor are they intended to be such a listing of the skills and abilities required to do the job. Rather, they are intended only to describe the general nature of the job.
Top Skills
Similar Jobs
What you need to know about the Colorado Tech Scene
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
