Senior Financial Management Analyst – FBWT, Advana

CSCI Consulting

. Support the review, validation, and cleanup of Advana FBWT dashboards, including investigation and resolution of undistributed transactions and data discrepancies .

Posted 10/30/2026full-timeRemote • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in DoD financial management, including reconciliation processes, financial reporting, and data analysis using SQL and Databricks. Proven ability to identify discrepancies and improve data quality across financial systems while supporting audit engagements and leadership reporting.

Highest-signal resume keywords

DoD Financial Statements and ReportingFund Balance With Treasury ReconciliationSQL and Databricks Data AnalysisFinancial Management and Accounting ExperienceAudit Engagement Support

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Financial Data AnalysisReconciliation ProcessesData Quality ValidationException AnalysisRoot-Cause AnalysisFinancial ReportingAccounts PayableAccounts ReceivableData StandardizationTransaction Research

Soft Skills

Problem-SolvingOrganizational SkillsTime-Management SkillsWritten CommunicationVerbal Communication

Tools & Technologies

DatabricksSQLAdvana

Certifications & Qualifications

Active Secret Clearance

Industry Keywords

DoD Financial ProcessesFinancial ManagementEntitlement SystemsAudit ReadinessMateriality Analysis

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

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 SFIS Lines of Accounting (LOA)
Apply 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 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
Document data anomalies, reconciliation results, root causes, and corrective actions to improve the reliability and traceability of financial information
Support leadership reporting and analysis related to materiality, financial reporting risk, audit readiness, and consolidated DoD financial reporting

Requirements

What you’ll need

Bachelor’s degree in Accounting, Finance, or a related field
Active Secret clearance or higher
Minimum of 10 years of experience in financial management and accounting, preferably within a federal or defense-related environment
DoD financial statements and reporting, including DD 1307, DD 1002, SF 133, and SFIS/LOA structures
Fund Balance with Treasury (FBWT) reconciliation concepts, including undistributed transactions and reconciliation between reporting tools and authoritative accounting systems
DoD audit engagements, including financial data populations, sampling, supporting documentation, and alignment of samples to applicable processes and systems
End-to-end DoD financial process flows, particularly Accounts Payable (AP), Accounts Receivable (AR), and financial reporting
Advana and its use for DoD financial data analysis and reporting
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
Preferred: Experience using SQL within Databricks or a comparable data analytics environment to conduct financial-data analysis
Preferred: Data reconciliation, exception analysis, root-cause analysis, and data-quality validation across multiple interconnected financial systems
Preferred: DoD financial, accounting, entitlement, and reporting environments, with familiarity with applicable systems
Preferred: Demonstrated ability to analyze information across multiple source systems and determine the cause of discrepancies between source-system data and reporting outputs
Preferred: Ability to work in a team environment, as well as independently
Preferred: Strong customer and vendor relationship skills
Preferred: Demonstrated ability to comply with data standards and policies
Preferred: Motivation to learn new technologies and methodologies that demonstrate value

Benefits

Comp & perks

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