Business Intelligence and Data Analyst with Security Clearance

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 State/Territories Metrics Brief • Produce 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 Mid-Year Appropriation Review and EOFY Status of Funds • 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 Decision Support Tools and Spreadsheet Development • 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 • Consolidate, interpret, and present data in reports and dashboards for internal and external stakeholders focused on budget and financial information Strawman Distribution Plan Support • Create an initial distribution plan annually in April by pulling the President's Budget (PB) lock position and producing the initial file in Excel format • Produce files and reports showing the impact of courses of action on the Start Points of all programs 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 • Produce final distribution plan files in Excel format for ARNG Checkbook load and pass results to the Government annually • Apply Congressional Marks annually when appropriations are passed: apply distributed marks per Congressional language, apply undistributed marks based on PPBC-G courses of action, produce files and reports showing impact on refund and revised start points for all programs (historically 10 versions during December-January), and calculate final withhold refunds based on PPBC-G decisions and current status of funds • 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 Cost Accounting Analysis - CAER and Scorecards • Produce monthly reports and provide data to support the Army Command Accountability and Execution Review (CAER) for Operations & Maintenance; pull feeder data from ASA(FM&C) reports and Army and DoW financial reporting systems to create ARNG-specific monitoring products; submit 12-15 CAER-related submissions annually with 3 quarterly program briefs • Provide analysis of established Key Performance Indicators (KPIs) to assist Government officials in identifying cost reporting anomalies and errors across ARNG appropriations and funds • Coordinate monthly CAER meetings with select states and staff; participate in routine and scheduled meetings regarding adjustments to CAER data with Army Guard and ASA(FM&C) personnel • Design monthly and other periodic reports to support the ARNG cost analysis and review cycle at the appropriation level and for specific cost elements • Create and post monthly cost accounting scorecards to Guard Knowledge Online reporting on cost reporting anomalies, execution in key cost tracking codes, and specific cost tracking errors for State and fund holder review; forward scorecards to Government officials for distribution • Serve as the technical point-of-contact for state United States Property Fiscal Officer (USPFO) Cost Accountants regarding bulletins on cost accounting updates and reports posted on Guard Knowledge Online • Review periodic Cost of War (COW) reports from ASA(FM&C) and OUSD(C) for ARNG Overseas Contingency Operations (OOC) cost collection errors and adjustments; create and maintain reports of base and OOC execution to support error analysis • 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 What you will bring: Key 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