Senior Financial Management Analyst – FBWT, Advana

This is a fully remote position, open to applicants in United States.

📋 Description

• Assist in the review, validation, and refinement of Advana FBWT dashboards, including the investigation and resolution of undistributed transactions and data inconsistencies.

• Examine financial data across DoD accounting, entitlement, and reporting systems to uncover reconciliation challenges, data ingestion errors, and potential reasons for inaccurate dashboard metrics.

• Trace financial transactions from Advana reporting outputs back to relevant source accounting and entitlement systems to ensure completeness and accuracy.

• Create and execute Databricks/SQL queries to analyze extensive financial datasets, identify exceptions, investigate transactions, and aid in reconciliation efforts.

• Assist in the analysis of DoD financial statements and associated financial reporting, including DD 1307, DD 1002, SF 133, and SFIS Lines of Accounting (LOA).

• Implement end-to-end DoD financial business processes, such as Accounts Payable, Accounts Receivable, and financial reporting, to pinpoint the origins of data or transaction discrepancies.

• Support audit engagements by facilitating sample populations, data standardization, transaction research, and ensuring alignment of audit samples with relevant business processes and financial systems.

• Investigate undistributed and unreconciled transactions, coordinating research across appropriate financial, accounting, entitlement, and reporting environments.

• Evaluate data-quality issues that could lead to overstated or understated financial metrics and assist in identifying the root causes of discrepancies.

• Document data irregularities, reconciliation outcomes, root causes, and corrective measures to enhance the reliability and traceability of financial information.

• Aid in leadership reporting and analysis concerning 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.

• At least 10 years of experience in financial management and accounting, ideally within a federal or defense-related context.

• Familiarity with DoD financial statements and reporting, including DD 1307, DD 1002, SF 133, and SFIS/LOA structures.

• Knowledge of Fund Balance with Treasury (FBWT) reconciliation concepts, including undistributed transactions and reconciliation between reporting tools and authoritative accounting systems.

• Experience with DoD audit engagements, including financial data populations, sampling, supporting documentation, and alignment of samples to relevant processes and systems.

• Understanding of end-to-end DoD financial process flows, specifically Accounts Payable (AP), Accounts Receivable (AR), and financial reporting.

• Proficiency in Advana and its application for DoD financial data analysis and reporting.

• Creativity and flexibility in problem-solving.

• Ability to collaborate with clients to grasp their requirements.

• Strong organizational and time-management capabilities.

• Excellent written and verbal communication abilities.

• Professional demeanor.

• Preferred: Experience utilizing SQL within Databricks or a comparable data analytics platform for financial data analysis.

• Preferred: Skills in data reconciliation, exception analysis, root-cause analysis, and data-quality validation across multiple interconnected financial systems.

• Preferred: Familiarity with DoD financial, accounting, entitlement, and reporting environments, along with applicable systems.

• Preferred: Proven ability to analyze information across various source systems and identify the cause of discrepancies between source-system data and reporting outputs.

• Preferred: Capacity to work effectively in a team setting as well as independently.

• Preferred: Strong skills in customer and vendor relationship management.

• Preferred: Demonstrated ability to adhere to data standards and policies.

• Preferred: Eagerness to learn new technologies and methodologies that provide value.

🏝️ Benefits

• Competitive salaries.

• Generous Paid Time Off (PTO) package.

• Paid holidays aligned with the Federal calendar.

• Comprehensive health benefits including medical, dental, vision, and life insurance.

• 401(k) retirement plan.

• Team-building events.

• Support for professional development.