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 Histori #J-18808-Ljbffr