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.

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.