Senior DoD Financial Data Analyst - FBWT, Advana, SQL

CSCI Consulting; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Generous PTO

Federal holidays

Full health benefits

Team building events

Job summary

CSCI Consulting, Inc. is seeking a Senior Financial Management Analyst to support DoD FBWT reconciliation, data quality, and audit readiness activities.

You will research undistributed transactions, trace data across DoD systems, and develop Databricks/SQL queries to reconcile large datasets. The role requires a strong DoD finance background, experience with Advana and DoD reporting, and the ability to coordinate across accounting and entitlement environments.

Qualifications

• Bachelor’s degree in Accounting, Finance, or a related field is required.
• Active Secret clearance or higher is required.
• Minimum of 10 years of experience in financial management and accounting, preferably in a federal or defense-related environment.
• Experience with DoD financial statements and reporting (DD 1307, DD 1002, SF 133, SFIS/LOA).
• FBWT reconciliation concepts and end-to-end DoD financial processes.

Responsibilities

• Support the review, validation, and cleanup of Advana FBWT dashboards, including investigation and resolution of undistributed transactions and data discrepancies.
• Analyze financial data across DoD accounting, entitlement, and reporting systems to identify reconciliation issues, data ingestion errors, and potential causes of inaccurate dashboard metrics.
• Trace financial transactions from Advana reporting outputs back to source accounting and entitlement systems to validate completeness and accuracy.
• Develop and execute Databricks/SQL queries to analyze large financial datasets, isolate exceptions, research transactions, and support reconciliation activities.
• Support analysis of DoD financial statements and related financial reporting (DD 1307, DD 1002, SF 133, SFIS/LOA).
• Understand end-to-end DoD financial processes (AP, AR, reporting) to identify data or transaction discrepancies.
• Support audit engagements by assisting with sample populations, data standardization, and alignment of audit samples with processes and systems.
• Investigate undistributed and unreconciled transactions across financial, accounting, entitlement, and reporting environments.
• Assess data-quality issues that may cause overstated/understated metrics and identify root causes.

Skills

DoD finance

FBWT reconciliation

Data analysis

Audit readiness

Client interaction

Communication

Time management

Education

Bachelor’s degree in Accounting, Finance, or a related field

Tools

GFEBS

DEAMS

NERP

MOCAS

DCAS

DCPS

Advana

Databricks

SQL

Job description

CSCI Consulting, Inc. is seeking a Senior Financial Management Analyst to support DoD FBWT reconciliation, data quality, and audit readiness activities.

You will research undistributed transactions, trace data across DoD systems, and develop Databricks/SQL queries to reconcile large datasets. The role requires a strong DoD finance background, experience with Advana and DoD reporting, and the ability to coordinate across accounting and entitlement environments.