Business Intelligence and Data Analyst

Grow, innovate, and generate progress: Harness your expertise to solve challenges and celebrate success! JCS Solutions LLC is seeking a highly skilled and motivated Business Intelligence and Data Specialist to support our Army National Guard (ARNG) client at the National Guard Bureau (NGB), 111 South George Mason Drive, Arlington, VA. The candidate will report onsite Monday through Friday, 8:00 AM to 4:30 PM, and must possess the stability, technical depth, and federal financial management expertise to support the ARNG-RMC Budget Execution (BE) Branch under the Planning, Programming, and Budget Execution System (PPBES). The ideal candidate brings advanced proficiency in Power BI, Excel, and data integration across Army financial systems, a strong foundation in federal cost accounting and Operations Research and Statistical Analysis (ORSA) methodologies, and demonstrated experience producing the full range of statistical, financial, and decision-support products required by the ARNG Comptroller's Office, Office of the Secretary of War – Comptroller (OSW-C), and the Assistant Secretary of the Army for Financial Management and Comptroller (ASA-FMC). What’s in it for you: - Join a premier technology firm specializing in innovative solutions. - Be part of a collaborative, inclusive, and innovative work culture. - Enjoy tremendous growth potential in a high-performing team environment. - A robust benefits package: 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 And more! **What you will do:** Key Responsibilities Financial Systems Integration and Daily Reporting • 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), consolidating funding and execution status at the Appropriation level for both Base and Overseas Operational Costs (OOC) • 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 • Produce a compact Daily Status of Funds Summary report in a Contractor-provided format for daily submission to the Government • 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 Spend Plans and Historical Analysis • 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 • Analyze historical disbursement trends over the life of appropriations to identify programs and states/territories responsible for grow-back; support distribution-of-funds decisions and validate unfunded requirement requests Monthly Execution Review (MER) • 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 • Prepare summary…