DoW Financial Reporting Systems Analyst (OneStream)

RM Advisory Services LLC; Alexandria (VA); On-site; USD 90,000 - 130,000; Full time

Job summary

RM Advisory Services LLC seeks a Functional / Management Analyst to support a Department of War financial management and data analytics program in the DoW Advana environment. You will analyze financial data, map reporting to source systems, and translate accounting requirements into system solutions to improve data quality and reporting efficiency.

The role focuses on DoW reporting, consolidation processes, and modernization of financial reporting through OneStream or similar platforms,

Qualifications

• Bachelor's degree in Accounting, Finance, Business, Information Systems, or a related field.
• Experience supporting Department of War financial management, accounting, financial reporting, or financial statement preparation/compilation.
• Working knowledge of federal and/or DoW financial reporting processes.
• Understanding of how accounting and transactional data flows from source systems through financial reporting processes.
• Experience analyzing financial data and researching reconciliation, reporting, or data-quality issues.
• Ability to translate financial and accounting requirements into functional, data, or system requirements.
• Strong analytical, problem-solving, documentation, and communication skills.
• Ability to work effectively with both financial management professionals and technical/data teams.

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.

Skills

Analytical

Problem solving

Communication

Documentation

Team collaboration

Education

Bachelor's degree in Accounting/Finance/Business/IS

Tools

SQL

Power BI

Python

Job description

RM Advisory Services LLC seeks a Functional / Management Analyst to support a Department of War financial management and data analytics program in the DoW Advana environment. You will analyze financial data, map reporting to source systems, and translate accounting requirements into system solutions to improve data quality and reporting efficiency.

The role focuses on DoW reporting, consolidation processes, and modernization of financial reporting through OneStream or similar platforms,