Senior Financial Management Analyst – FBWT, Advana
Posted 2hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Financial Management Analyst improving DoD FBWT reconciliation and Advana reporting. CSCI Consulting delivers information technology and financial management consulting services.
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 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:
- 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:
- 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
















