Financial Data Cleansing Analyst – Navy

Financial Data Cleansing Analyst – Navy

Location: Arlington, VA (on-site hybrid Remote) Level: Senior Analyst Clearance: Active Secret required *All candidates must already have the above clearance listed. All candidates must be able to obtain and maintain their current clearance and any clearance level designated by Montcure at any given time, during their employment. Montcure, LLC is a Service-Disabled Veteran-Owned Small Business (SDVOSB) founded with a vision to revolutionize consulting and advisory services through innovative, data-driven solutions. The Montcure team recognize the unique challenges faced by organizations and governments in today’s rapidly evolving business environment.

Job Summary:

Montcure, LLC is hiring a Financial Analyst to support the Navy a financial data cleansing effort. You will research, reconcile, and resolve problem transactions that affect the accuracy and audit readiness of the department’s accounting records, including Unmatched Transactions (UMTs), Aged Accounts Payable (AAPs), Aged Accounts Receivable (AAR), and dormant Undelivered Orders (UDOs). Our core value of Dependability is paramount to this role: working across Navy ERP (NERP), Wide Area Workflow (WAWF), PIEE Electronic Data Access (EDA), and the Defense Cash Accountability System (DCAS), you will trace transactions from obligation through disbursement, identify root causes, assemble supporting documentation, and recommend corrective actions for Government review and approval. Your work will directly reduce problem disbursements, free up unneeded funds, and strengthen the Navy’s posture for financial statement audits.

Key Responsibilities:

• Serve as the financial analysist responsible for resolution of complex Unmatched Disbursements (UMDs), Negative Unliquidated Obligations (NULOs), and aged transactions, establishing department-wide reconciliation methodologies and directing corrective actions across disbursing, vendor pay, and program offices.
• Reconcile accounts payable and accounts receivable reconciliation outcomes across the department – including obligation-to-expenditure matching, vendor pay and invoice clearing, reimbursable billings, and collections – and define the controls and procedures that ensure transaction integrity and audit readiness enterprise-wide.
• Direct analysis of complex financial transactions and system data across the team to identify errors, inefficiencies, and control gaps, and advise leadership on corrective actions and risk mitigation.
• Direct budget execution oversight, funds status reporting, commitments, obligations, expenditures, and reconciliation processes for multiple Navy BSOs.

Unmatched Transactions (UMTs):

• Research and reconcile Unmatched Disbursements (UMDs), Negative Unliquidated Obligations (NULOs), and in-transit transactions by comparing DCAS disbursement and collection records against NERP obligations.
• Trace payments through WAWF invoices, receiving reports, and contract documents in PIEE EDA to determine the correct line of accounting and obligation match.
• Identify root causes (e.g., incorrect line of accounting, missing or late obligations, contract modification timing, duplicate payments) and prepare correction packages for Government action.

Aged Accounts Payable (AAPs):

• Analyze aged payables in NERP to validate whether liabilities remain valid, have been paid, or require adjustment.
• Verify invoice, receipt, and acceptance status in WAWF and confirm payment activity in DCAS.
• Coordinate with program offices, contracting officers, and vendors as directed to resolve open items and document the basis for each disposition.

Aged Accounts Receivable (AAR):

• Research aged receivables, including reimbursable billings and debts, to validate amounts due and collection status.
• Reconcile collections posted in DCAS against outstanding receivables in NERP and identify misapplied or unrecorded collections.

Dormant Undelivered Orders (UDOs):

• Support tri-annual reviews by identifying dormant and inactive UDOs in NERP and validating them against contract status, delivery, and billing activity in PIEE EDA and WAWF.
• Assemble evidence supporting de-obligation, contract closeout, or continued validity of each open obligation.
• Track de-obligation recommendations through Government approval and confirm postings in NERP.

Reporting & Documentation:

• Maintain organized, audit-ready supporting documentation for every researched transaction.
• Update tracking tools and status reports reflecting volumes worked, dollar value resolved, and aging trends.
• Identify recurring process gaps and recommend preventive controls aligned with OMB Circular A-123 and FIAR guidance.
• Support audit sampling and Prepared-By-Client (PBC) requests related to cleansed transactions as directed.

Qualifications:

Education:

• Bachelor’s degree in Accounting, Finance, Business, or a related field. An additional two (2) years of relevant experience may substitute for the minimum education requirement.

Experience:

• 6+ years of DoD or Navy financial management experience, including hands-on reconciliation of UMTs, AAPs, AAR, and UDOs.
• Demonstrated experience researching transactions end-to-end, from obligation through invoice, receipt, acceptance, and disbursement.
• Working knowledge of the Navy/DoW financial execution lifecycle, including commitments, obligations, expenditures, and reconciliation.
• Hands-on experience with Navy ERP (NERP), WAWF, PIEE EDA, and DCAS.

Skills:

• Working knowledge of federal appropriations law, fund status, and the DoD Financial Management Regulation (DoD FMR), particularly Volume 3 (Budget Execution) and Volume 5 (Disbursing Policy).
• Understanding of USSGL accounting and the relationship between obligations, accounts payable, expenditures, and collections.
• Strong analytical and problem-solving skills with high attention to detail.
• Advanced Microsoft Excel skills for reconciling large data sets.
• Clear written communication skills for preparing correction packages and documenting dispositions.

Preferred Qualifications:

• Experience supporting major Navy claimants (BSOs), SYSCOMs.
• Prior experience on a Navy or Marine Corps financial data cleansing, audit remediation, or problem disbursement effort.
• Advanced functional knowledge of Navy ERP (SAP ECC) financial modules (FI, MM, SD).
• Experience with DFAS reconciliation processes and Advana or similar DoD data analytics tools.
• Professional certifications (e.g., DoD FM Certification, CDFM, CPA, CGFM).

Job Type: Full-Time, fully funded ready for hire Salary Range: $95,000 - $125,000 (based on experience)

Montcure, LLC is an Equal Opportunity Employer. Montcure, LLC does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business.