Business Intelligence and Data Analyst

JCS Solutions LLC

Arlington, VA

Apply

JOB DETAILS

JOB TYPE

Full-time

SKILLS

Accounting, Accounting Standards and Regulations, Adjudication, Administrative Skills, Analysis Skills, Background Investigation, Budget Management, Budget Reporting, Budgeting, Business Administration, Business Intelligence, Business Skills, Business Solutions, Calendar Management, Cisco ASA (Adaptive Security Appliance), Cloud Computing, Communication Skills, Comparative Analysis, Computer Software, Contract Creation, Cost Accounting, Cost Analysis, Cost Reporting, Customer Experience, Data Analysis, Data Processing, Data Quality, Data Sets, Data Visualization, Decision Support, Dental Insurance, Disbursements, Embedded Systems, Federal Government, Finance, Financial Management, Financial Modeling, Financial Reporting, Financial Systems, Funding, Government, Government Reporting, International Operations, Internet Security, Life Insurance, Major Accounts, Management Consulting, Metrics, Microsoft Access Database, Microsoft Excel, Microsoft PowerPoint, Microsoft Product Family, Military, Operational Audit, Operations Research, Operations Security (OPSEC), Performance Analysis, Performance Metrics, Pivot Tables, Plan Meetings, Power BI, Presentation/Verbal Skills, Problem Solving Skills, Product Support, Professional Services, Project/Program Management, Reconciliation, Reimbursement, Reporting Dashboards, Reporting Skills, Requirements Validation/Verification, Retirement Funds, Risk Management, Scorecarding, Secret Clearance, Service Delivery, Software Administration, Software Development, Spreadsheets, Statistics, Status Reports, Stewardship, System Integration (SI), Team Player, Time Management, Trend Analysis, United States Citizen, United States Department of Defense (DoD), Vision Plan, Writing Skills

LOCATION

Arlington, VA

POSTED

Today

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, 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

How you will wow us:
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

JCS Solutions (JCS) is a premier technology firm providing innovative solutions and high-quality services in defense, national security, and civilian sectors. JCS offers enterprise-wide solutions including cloud computing, software development, cybersecurity, digital modernization, and management consulting for the federal government. At JCS, we elevate our customers’ mission through the application of technology and professional services. Our commitment to investing in our workforce drives innovation and progress for our clients, employees, and communities.

JCS is both a Great Place to Work and a Washington Post’s Top Places to Work certified company.

Our employees embody our core values, and we are looking for others who do too!

Accountability: Take ownership of and pride in our actions and service delivery
Stewardship: The careful and responsible management of something entrusted to our care.
Customer Experience: Strive for excellence and delight our clients
Innovation: Embrace creative thinking to enable continual growth and powerful solutions
Inspire: Be inspired to be your best self and have fun in the process
Integrity: Do the right thing, the right way, every time!

At JCS Solutions, compensation is based on a number of factors such as location, qualifications, and applicable contract terms. The general salary range for this position is as follows: $125,000.00-$140,000.00

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.

About the Company

JCS Solutions LLC

Resume Resources

Free Resume Templates Free Resume Builder