Senior Financial Management Analyst – FBWT & Advana

The role

The consultant will support FBWT reconciliation, financial data quality, and audit readiness activities for a Department of War client. The analyst will focus on improving Advana FBWT reporting by researching transactions and tracing financial information across DoD systems.

What you will do

• Support review, validation, and cleanup of Advana FBWT dashboards
• Analyze financial data across DoD accounting, entitlement, and reporting systems
• Trace financial transactions from Advana reporting outputs to source systems
• Develop and execute Databricks/SQL queries to analyze large financial datasets
• Support analysis of DoD financial statements and related financial reporting
• Apply understanding of end-to-end DoD financial business processes
• Support audit engagements with sample populations and data standardization
• Investigate undistributed and unreconciled transactions
• Assess data-quality issues resulting in overstated or understated metrics
• Document data anomalies, reconciliation results, and corrective actions

Required qualifications

• 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
• DoD financial statements and reporting, including DD 1307, DD 1002, SF 133, and SFIS/LOA structures
• Fund Balance with Treasury (FBWT) reconciliation concepts
• DoD audit engagements, including financial data populations and sampling
• End-to-end DoD financial process flows, particularly Accounts Payable (AP) and Accounts Receivable (AR)
• 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

Nice to have

• Experience using SQL within Databricks or a comparable data analytics environment
• Data reconciliation, exception analysis, root-cause analysis, and data-quality validation
• DoD financial, accounting, entitlement, and reporting environments, with familiarity with applicable systems
• Ability to analyze information across multiple source systems to determine cause of discrepancies
• Ability to work in a team environment, as well as independently
• Strong customer and vendor relationship skills
• Demonstrated ability to comply with data standards and policies
• Motivation to learn new technologies and methodologies

Benefits

• 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

About the company

CSCI is an information technology and financial management consulting firm. The company follows the philosophy to do what is right, always.