Senior DoW Financial Management and Data Analyst, Advana Experience Needed
Category
Job Location
Tracking Code
Position Type
Position Summary
RM Advisory Services is seeking a Senior DoW Financial Management and Data Analyst who will utilize strong technical and analytical skills to normalize finance and accounting data from multiple sources to support Department of War (DoW) audit readiness and delivery. Using expertise in financial management, internal controls, audit readiness, and project management, develop and implement solutions for the DoW’s complex financial reporting and audit challenges. Leverage understanding of common data model design, data acquisition and ingestion, and the application development lifecycle to bridge gaps between technologists and defense financial managers, ensuring software solutions meet audit priorities. Normally requires a bachelor’s degree and five to seven years of DoW or Fortune 500 financial management, audit, internal controls and/or data analytics experience.
This position is well suited for a financial management professional who understands how DoW financial data moves from underlying accounting and feeder systems through the financial reporting and financial statement compilation process and can translate functional accounting requirements into data, reporting, and system requirements.
Experience with OneStream or other enterprise financial reporting/consolidation platforms is highly desirable. This person must have worked with the Advana platform. Similar experience does not translate for this role.
Key Responsibilities
- Support DoW financial reporting and financial statement compilation activities, including analysis of financial data used to prepare DoW component and consolidated financial statements.
- Apply knowledge of DoW accounting, financial management, and reporting processes to identify reporting requirements, data issues, and opportunities for process improvement.
- Analyze financial and transactional data supporting financial statement balances, disclosures, reconciliations, and management reporting.
- Assist with mapping financial reporting requirements to source systems, data elements, business rules, and Advana data products.
- Work with functional and technical teams to translate accounting and financial reporting requirements into actionable system, data, dashboard, and reporting requirements.
- Support reconciliation, validation, and research of financial data across multiple DoW systems and data sources.
- Identify data quality, completeness, reconciliation, and financial reporting issues and assist stakeholders in developing solutions.
- Develop and document business processes, functional requirements, data requirements, workflows, and reporting requirements.
- Support modernization and automation of financial reporting and financial statement compilation processes.
- Collaborate with DoW financial management organizations, system owners, data teams, and other stakeholders.
- Support development of briefings, analyses, recommendations, and other deliverables for government leadership.
Required Skills
Position Requirements:
· 5+ years of DoW or Fortune 500 experience in the areas of financial reporting, audit, internal controls and/or data analytics
· Knowledge of the United States Standard General Ledger (USSGL) chart of accounts, USSGL account transactions, Treasury Federal Account Symbols and Titles (FAST), DoW Financial Management Regulation (FMR), Generally Accepted Government Auditing Standards (GAGAS), OMB Circular A-123, and other related guidance
· Experience acquiring accounting data, building databases, generating audit samples, and responding to provided by client (PBC) requests
· Experience writing SQL scripts to query databases and build reconciliations
· Experience with project management and Scrum Agile development
· Experience leading teams, reviewing work, and helping the team achieve tight deadlines
· BA, BS or BBA degree in accounting, finance, business management, statistics, mathematics, engineering, computer science, or related area
· CPA, CGFM, CDFM, CIA or other related designation
· Active Secret clearance - Required: Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information. Secret clearance is required.
Required Experience
Nice If You Have
Experience with modern relational databases, including MySQL or PostgreSQL
· Experience with Big Data systems (e.g., Hadoop, HDFS, Hive, Cloudera)
· Experience providing recommendations using dashboards, visualizations, or reports using BI platforms such as QlikSense or Tableau
· Ability to manipulate and integrate databases with SQL, SAS, or other languages
· Ability to comprehend stakeholder needs effectively, communicate development plans, and track progress milestones
· Ability to navigate a complex matrix environment and manage competing priorities
· Ability to successfully work on cross functional projects and teams
· Possession of excellent communication skills, including briefing senior leadership
· Possession of excellent quantitative skills, including statistical analysis, process design, and data management
· Possession of excellent organization and time management skills to handle multiple tasks simultaneously
· Possession of excellent thinking skills, including assessing numbers, trends, and data in order to reach new conclusions based on findings
This position is located at Defense Health Headquarters building, AF/SGY, 7700 Arlington Boulevard, Falls Church, VA. View the Google Map in full screen.
Home