About the Opportunity
DMI, LLC is seeking an IT Budget & Financial Governance Analyst to support the daily financial execution, data integration, and governance enforcement for the OCIO budget. Operating within a hybrid and evolving tool ecosystem, this role ensures data compliance with newly established financial structures and validation rules. You will work closely with the Senior Lead to track allocations, reconcile core ledger data, assist with the Front Office spend plan, and act as the front-line resource helping program offices execute their validation battle rhythms.
Duties and Responsibilities:
- Pulling, cleaning, and manually or semi-automatically ingesting raw data exports from core enterprise financial networks, data warehouses, and procurement modules into the central budget system.
- Executing day-to-day transaction logging, ledger balance checks, and tracking for the Front Office spend plan alongside broader consolidation efforts.
- Monitoring and facilitating the upcoming division validation process, acting as the primary point of contact for program staff during reporting cycles.
- Tracking division compliance against established reporting timelines, ensuring program teams verify their ingested ledger data within the mandatory windows.
- Analyzing contract Periods of Performance (POPs), processing purchase requisitions, and flagging execution delays that could disrupt executive disbursement strategies.
- Populating, updating, and verifying the underlying data integrity behind executive Quad Charts, pivot tables, and visual tracking dashboards.
- Working across a flexible toolset to reconcile disparate reports originating from various offices utilizing different software platforms.
- Identifying and documenting system inefficiencies, manual data bottlenecks, and opportunities where automated tools or APIs could streamline operations.
- Leveraging Generative AI platforms to draft rapid variance explanations, build data-cleaning logic, and create notification templates for division stakeholders.
- Maintaining organized digital repositories of historical spend plans, Inter-Agency Agreements (IAAs), Service Level Agreements (SLAs), and signed financial allocations.
- Conducting routine variance analysis on an individual project level to spot underspending or overspending trends early in the fiscal year.
Qualifications
Education and Years of Experience:
- Bachelor’s degree and 8 years of professional experience
- At least 3 years of professional experience in financial analysis, budgeting, or a data-intensive role.
- Advanced proficiency in either Microsoft Excel or Google Sheets (e.g., complex lookups, nested logic, pivot tables, data cleaning).
- Experience manually exporting, cleaning, and validating large, unformatted raw datasets from enterprise databases or core financial systems.
- Direct experience tracking multi-phased project timelines, contract periods of performance (POPs), or multi-year project allocations.
- Familiarity with integrating artificial intelligence and Large Language Models (LLMs) into daily workflows (e.g., using Gemini or Microsoft Copilot for drafting variance narratives or formatting data).
- Exposure to the federal budget lifecycle, financial execution phases, or public sector spend planning.
- Strong verbal and written communication skills with a track record of coordinating across diverse teams to gather data or enforce submission deadlines.
Required Skills & Certifications:
- Bachelor’s degree in related field such as Finance, Accounting, Business Administration, Economics, or Data Analytics.
- Advanced mastery of Smartsheet architecture, including cross-sheet referencing, automated approval workflows, and executive dashboard design.
- Proven capability in building advanced Excel Macros (VBA) or Google Apps Script to automate repetitive data manipulation tasks.
- Advanced skill in leveraging Generative AI (e.g., prompt engineering for complex financial trend analysis, script generation, or dataset cross-referencing).
- Prior experience working with or manipulating data directly originating from the Business Applications Solution (BAS) ecosystem, specifically EBS, EDW, or PRISM modules.
- Experience designing high-density visual reporting layouts, such as corporate Quad Charts or interactive business intelligence dashboards, for C-suite or executive leadership briefings.
- Ability to analyze fragmented, legacy workflows (e.g., tracking sheets scattered across Excel and Google Sheets) and provide recommendations on how to centralize and consolidate them into a unified system.
Citizenship Status Required: Must be a U.S. Citizen
Physical Requirements: None required for this position.
Location: Remote, US
***************** No Agencies Please *****************
