Financial Analyst - Inventory Reconciliation

Systems Planning and Analysis, Inc.; Alexandria (VA); On-site; USD 100,000 - 130,000; Full time

Job summary

Intrepid, an SPA Company, seeks a Financial Analyst-Inventory Reconciliation to deliver DoW-wide inventory reconciliations using Advana or Palantir Foundry for accurate financial reporting and audit readiness.

The role involves reconciling subledger to GL, tracking WIP and in-transit items, managing inter-agency transfers, and harmonizing master data to improve accountability and efficiency across the DoW enterprise.

Qualifications

• Bachelor's degree required.
• 3+ years experience in subledger-to-GL reconciliations.
• 5+ years experience identifying unmatched/unreconciled balances.
• Experience with Advana and Foundry environments.
• Active SECRET clearance and ability to maintain it during employment.

Responsibilities

• Perform DoW-wide inventory reconciliations in Advana or Palantir Foundry to enable accurate financial reporting and audit readiness.
• Reconcile subledger-to-GL tie-points by mapping quantities, values, and financial line items; track WIP and in-transit inventory.
• Manage inter-agency transfers, including denials and returns, and establish traceability to source transactions.
• Harmonize master data elements (material numbers, UICs, storage locations, condition codes) across systems.
• Identify unmatched balances, assign age buckets and root-cause codes, and propose workflow-driven corrective actions.

Skills

Subledger-to-General Ledger

Identify unmatched balances

Data reconciliation

Education

Bachelor's Degree

Tools

Advana

Foundry

Job description

Overview

Intrepid, an SPA Company, brings more than 20 years of experience supporting the Department of Defense and U.S. Government, consistently setting the standard for excellence in the federal marketplace. Committed to advancing the mission of the U.S. Warfighter, Intrepid leverages technological superiority to deliver innovative solutions across air, space, land, and sea domains. We are proud to foster a collaborative, dynamic work environment, offering competitive compensation and an industry-leading 401k contribution. Our team is built through merit and achievement, and we're always looking for the best and brightest to join us in our growth. We treat our people like family, we are mission-focused, and we give back! Join us today.

SPA has an immediate need for a Financial Analyst-Inventory Reconciliation.

Responsibilities

The position focuses on delivering Department of Work (DoW)-wide inventory reconciliations within Advana or Palantir Foundry to enable accurate financial reporting and audit readiness, including valuation assessments and General Ledger (GL) tie-outs. This involves creating robust inventory reconciliations for each Working Capital Fund (WCF) DoW agency using advanced data platforms. Key responsibilities include reconciling subledger-to-GL tie-points by mapping quantities, values, and financial line items, as well as tracking Work-in-Process (WIP) and in-transit inventory items to ensure comprehensive oversight. The scope also includes managing inter-agency transfers, such as handling denials and returns, and establishing traceability to source transactions for improved accountability. Additionally, the role requires harmonizing master data elements like material numbers, Unit Identification Codes (UICs), storage locations, and condition codes to achieve consistency across systems. A critical aspect of this effort is identifying unmatched or unreconciled balances, categorizing them with age buckets and root-cause codes, and proposing workflow-driven corrective actions to address discrepancies. This initiative is integral to enhancing inventory management, financial transparency, and operational efficiency across the DoW enterprise.

Qualifications

Required Qualifications:

• Bachelor's Degree
• At least 3 years experience in Subledger-to-General Ledger
• At least 5 years experience identifying unmatched/unreconciled balances
• Experience with Advana/Foundry environments
• Active SECRET Clearance and the ability to maintain it throughout employment

Pay Range Information

At SPA, we strive to deliver a robust total compensation package that will attract and retain top talent. Elements of the compensation package include competitive base pay and variable compensation opportunities. SPA provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health insurance, flexible spending accounts, health savings accounts, retirement savings plans, life and disability insurance programs, and a number of programs that provide for both paid and unpaid time away from work. The specific programs and options available to any given employee may vary depending on eligibility factors such as geographic location, date of hire, etc. Please note that the salary information shown below is a general guideline only. Salaries are commensurate with experience and qualifications, as well as market and business considerations. , Pay Transparency Salary range: USD $100,000.00/Yr. - USD $130,000.00/Yr.