Business Intelligence and Data Analyst Security Clearance
Job in
Arlington, Arlington County, Virginia, 22201, USA
Listed on 2026-07-17
Listing for:
JCS Solutions LLC
Full Time
position Listed on 2026-07-17
Job specializations:
-
Finance & Banking
Financial Reporting, Financial Analyst, Financial Compliance
Job Description & How to Apply Below
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 slides and Situation Reports to support Budget Execution Branch monthly briefings; attend and participate in all required weekly and periodic Government meetings…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×