Job Description
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.
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