Senior Financial Management Analyst

CSCI Consulting is looking for a Senior Financial Management Analyst to support our Department of War (DoW / DoD) client. In this role, the consultant will support FBWT reconciliation, financial data quality, and audit readiness activities. The analyst will focus on improving the accuracy of Advana FBWT reporting by researching undistributed transactions, identifying data ingestion and reconciliation issues, and tracing financial information across DoD accounting, entitlement, and reporting systems. Candidates should have a strong foundation in DoD financial reporting and business processes, familiarity with systems such as GFEBS, DEAMS, NERP, MOCAS, DCAS, and DCPS, and experience using Advana, Databricks, and SQL to analyze and reconcile financial data.

- 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 applicable 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, including DD 1307, DD 1002, SF 133, and Standard Financial Information Structure (SFIS) Lines of Accounting (LOA)

- Apply an understanding of end-to-end DoD financial business processes, including Accounts Payable, Accounts Receivable, and financial reporting, to identify where data or transaction discrepancies originate

- Support audit engagements by assisting with sample populations, data standardization, transaction research, and alignment of audit samples with applicable business processes and financial systems

- Investigate undistributed and unreconciled transactions and coordinate research across the appropriate financial, accounting, entitlement, and reporting environments

- Assess data-quality issues that may result in overstated or understated financial metrics and help determine the underlying source of discrepancies