Business Intelligence and Data Analyst

Overview 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). Salary range: $125,000 - $140,000. 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. 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. Additional benefits available. Responsibilities Financial Systems Integration and Daily Reporting Maintain the daily status of all ARNG funds by integrating data from the ARNG Checkbook, GFEBS, and 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 distribution of funds to major account categories, Budget Execution and Program Manager 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) 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 OMNG analysis. Decision Support Tools and Spreadsheet Development Implement and maintain integrated decision support tools (Power BI) that enable and enhance PBAC-driven decision-making, providing actionable insights, visualizations, and reporting capabilities; 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 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 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 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. 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. Must have demonstrated experience with Microsoft Power BI in a federal financial reporting context. 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. Key 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. Working knowledge of Army financial systems including ARNG Checkbook, GFEBS, ODS, and PBAS; familiarity with cProbe and DMOPS preferred. 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. Strong understanding of federal cost accounting standards, ORSA-type methodologies, and fiscal reporting requirements applicable to the ARNG Comptroller's Office and ASA-FMC. 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-visibility federal environment. Commitment to Non-Discrimination All qualified applicants will receive consideration for employment without regard to any protected status protected by applicable federal, state, or local laws. #J-18808-Ljbffr JCS Solutions LLC