Business Intelligence and Data Analyst

About the role

Harness your expertise to support the ARNG-RMC Budget Execution (BE) Branch under the Planning, Programming, and Budget Execution System (PPBES). This role requires advanced proficiency in Power BI, Excel, and data integration across Army financial systems.

Responsibilities

• Maintain the daily status of all ARNG funds by integrating data from the ARNG Checkbook, General Fund Enterprise Business System (GFEBS), and Operational Data Store (ODS).
• Update and maintain a daily tracking sheet capturing the distribution of funds to major account categories, Budget Execution (BE) and Program Manager (PM) withholds, pending distributions, and undistributed amounts.
• Calculate daily metrics including percent of Program Budget Guidance (PBG) Obligation, percent of Allotment Obligation, and percent of Unliquidated Obligation (ULO); identify changes since the previous report and flag programs and states/territories responsible for changes.
• Submit 52–55 weekly reports annually integrating status of funds, obligation tracking, and program-level execution data; run 150–200 obligation and commitment reconciliation reports weekly and on-demand.
• Develop spend plans for all 54 states, territories, and the District of Columbia using current-year obligations, three-year obligation averages, and requirements entered in the ARNG Checkbook system.
• Analyze historical funding trends and produce written analyses explaining changes in funding between and within fiscal years, covering President's Budget Requests, Congressional Marks, PBAC Withholds, execution-year transfers and reprogramming, Unprogrammed Requirements (UPR) and Unfunded Requirements (UFR) paid, fund migration, and EOFY turn-ins.
• Produce the Monthly Execution Review (MER) in PowerPoint format with embedded spreadsheets based on appropriations, portfolios, and programs identified by the Budget Execution Branch; verify accuracy of finance data using cProbe and DMOPS systems; submit 12 MER packages annually.
• Create and post monthly State/Territories Metrics Briefs (October through June) and weekly or daily briefs (July through September, as EOFY approaches) covering all 54 states/territories using three measures: (1) percent of each state's monthly spend plan that is obligated; (2) percent of each state's allotment that is obligated; and (3) percent of unliquidated obligations.
• Create the Mid-Year Appropriation Review annually in April; prepare reports submitted to OSW in OSW-prescribed format, including status of funds, historical execution, spend plan, EOFY projections, Civilian Pay Execution, and Readiness metrics.
• Create the End of Fiscal Year (EOFY) Status of Funds annually in October as an Excel spreadsheet used by BE and Budget Formulation analysts to compare obligated amounts against the DFAS 1002 Report and map EOR/Commitment items to OP 32 lines for Operation and Maintenance Army National Guard (OMNG) analysis.
• Implement and maintain integrated decision support tools — currently Power BI — that enable and enhance PBAC-driven decision-making, providing actionable insights, visualizations, and reporting capabilities for Government officials to make timely, accurate, and defensible decisions; coordinate with and receive Government approval on all tool formats.
• Build and maintain a spreadsheet tool to assist the Budget Execution team in balancing Annual Funded Program and Allotment across the ARNG Checkbook, GFEBS, and PBAS systems.
• Support the creation of an initial distribution plan annually in April by pulling the President's Budget (PB) lock position and producing the initial file in Excel format.
• Apply Congressional Marks annually when appropriations are passed: apply distributed marks per Congressional language, apply undistributed marks based on PPBC-G approved UPR amounts and withhold rules, CRA withhold amounts and PPBC-G distribution rules, and Risk Management Account (RMA) withhold amounts and PBAC distribution.
• Execute cut drills mandated by Congress, OSW, and Army for sequestration and rescission when the 80/20 target is not met; produce files and reports showing the impact of PPBC-G courses of action on affected programs.
• Design monthly and other periodic reports to support the ARNG cost analysis and review cycle at the appropriation level and for specific cost elements.
• Maintain and deliver statistical objects, analytical products, and reporting tools as operationally required for emergent Army, DoW, or Congressional reporting requirements; ensure products are developed, updated, and disseminated in alignment with evolving tasking, data availability, and Government guidance.
• Maintain and update a tool for analyzing and reporting ARNG execution by element of resources and programs to support the calculation of monthly and annual adjustments to retirement pay accrual disbursements in current and prior years to the military retirement trust fund.

Requirements

• United States citizenship required.
• Must be eligible to obtain and maintain a Common Access Card (CAC) requiring at minimum a favorably adjudicated Tier 1 background investigation in accordance with Army Directive 2014-05; Secret clearance eligibility preferred.
• Bachelor's or Master's Degree from an accredited U.S. college or university, preferably in Finance, Accounting, Business Administration, Data Analytics, Operations Research, or a related field.
• 8+ years of relevant experience in federal financial management, budget execution, cost accounting analysis, or statistical analysis, preferably in a DoD or Army National Guard environment.
• Advanced proficiency in Microsoft Power BI for dashboard development, data visualization, and executive-level reporting.
• Advanced proficiency in Microsoft Excel, including complex financial modeling, pivot tables, and formula development.
• Proficiency in Microsoft Access and experience writing and maintaining macros and queries for automated data processing.
• Familiarity with Army financial systems including ARNG Checkbook, GFEBS, ODS, and PBAS; familiarity with cProbe and DMOPS preferred.
• Strong understanding of federal cost accounting standards, ORSA-type methodologies, and fiscal reporting requirements applicable to the ARNG Comptroller's Office and ASA-FMC.
• Thorough knowledge of the Planning, Programming, Budget, and Execution System (PPBES) and the federal budget cycle, including PPBC-G, PBAC, Congressional Marks, UPR/UFR, and sequestration/rescission processes.
• Knowledge of ARNG appropriations management, fund distribution, obligation tracking, and Unliquidated Obligation (ULO) analysis across 54 states, territories, and DC.
• Familiarity with DFAS reporting including the DFAS 1002 Report and OP 32 line structure.
• Excellent analytical and problem-solving skills with demonstrated ability to identify funding trends, disbursement variances, and cost anomalies in large federal financial datasets.
• Strong written and verbal communication skills; ability to produce briefing-quality PowerPoint presentations with embedded spreadsheets for senior Government officials.
• Ability to manage multiple concurrent reporting deliverables on daily, weekly, monthly, and annual schedules with high accuracy.
• Ability to work independently and as part of a team in a fast-paced, high-pressure environment.

Qualifications

• Must be able to complete all required security and training requirements (AT Level 1, iWATCH, Cyber Awareness, AUP, OPSEC, CIAR, CUI) within required timeframes after contract start date.

Skills

• Advanced proficiency in Microsoft Power BI for dashboard development, data visualization, and executive-level reporting.
• Advanced proficiency in Microsoft Excel, including complex financial modeling, pivot tables, and formula development.
• Proficiency in Microsoft Access and experience writing and maintaining macros and queries for automated data processing.
• Familiarity with Army financial systems including ARNG Checkbook, GFEBS, ODS, and PBAS; familiarity with cProbe and DMOPS preferred.
• Strong understanding of federal cost accounting standards, ORSA-type methodologies, and fiscal reporting requirements applicable to the ARNG Comptroller's Office and ASA-FMC.
• Thorough knowledge of the Planning, Programming, Budget, and Execution System (PPBES) and the federal budget cycle, including PPBC-G, PBAC, Congressional Marks, UPR/UFR, and sequestration/rescission processes.
• Knowledge of ARNG appropriations management, fund distribution, obligation tracking, and Unliquidated Obligation (ULO) analysis across 54 states, territories, and DC.
• Familiarity with DFAS reporting including the DFAS 1002 Report and OP 32 line structure.
• Excellent analytical and problem-solving skills with demonstrated ability to identify funding trends, disbursement variances, and cost anomalies in large federal financial datasets.
• Strong written and verbal communication skills; ability to produce briefing-quality PowerPoint presentations with embedded spreadsheets for senior Government officials.
• Ability to manage multiple concurrent reporting deliverables on daily, weekly, monthly, and annual schedules with high accuracy.
• Ability to work independently and as part of a team in a fast-paced, high-pressure environment.

Benefits

• Health, dental, and vision insurance.
• Life insurance.
• Short-and-long term disability.
• Paid time off (PTO).
• 401k retirement plan with employer match.
• Annual Professional Development Reimbursement Program.

Pay

Competitive salary commensurate with experience.

Schedule

Onsite Monday through Friday, 8:00 AM to 4:30 PM.