PWS HRO Manpower DataAnalytics 5-15-2026.docx
DOCX document 49 KB Posted
- Attached to
- HRO Manpower/Advanced Data Analytics Integrator
- Solicitation number
- W912JM26QA008
About this file
This is a Performance Work Statement (PWS) for Manpower/Data Analytics Integrator Services supporting the Human Resources Office (HRO) at the Georgia Army National Guard.
The contractor shall provide one full-time equivalent Data Analytics Integrator to serve as the primary technical architect for synchronizing manpower and budget data from multiple legacy systems including GFEBS, FTSMCS, DCPDS, and Power BI. Key deliverables include: (1) LWOP/RTD product for tracking leave without pay and return-to-duty status with 95% accuracy and 24-hour data refresh cycles; (2) centralized Awards/Quality Step Increases dashboard with 98% accuracy; (3) military service credit deposit tracker with 100% monthly accuracy; (4) Vacancy Fill & Projections tool with predictive modeling and 95% accuracy; (5) Tech/AGR Voucher Reconciliation Power BI dashboard with 95% accuracy; (6) Status of Funds Dashboard mirroring NGB systems with 98% accuracy and daily updates; (7) Customer Action Tracker for personnel and budget request workflow visualization with 95% accuracy; and (8) AGR/Tech Life Cycle Predictive Model forecasting retirements, attritions, and promotions with 95% accuracy. All data products require 24-hour refresh cycles from source systems except the military buyback product which updates monthly. The Government furnishes workspace, desks, telephones, computers, and other office equipment. The contractor is responsible for all other personnel, equipment, tools, materials, supervision, and quality control. Work shall not be performed on recognized U.S. federal holidays. Contractor employees must comply with all installation security and access requirements, including background checks and DoD personal identity verification standards, and must wear identification badges displaying company name, employee name, and "contractor" designation.
View the file
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
1.0 General:
1.1 Scope: The contractor shall provide all personnel, equipment, tools, materials, supervision, and quality control necessary, except as specified in Paragraph 3.0 as Government Furnished, to perform Manpower/Data Analytic Integrator Services, as defined in this PWS.
1.2 General Information:
1.2.1 Unscheduled gate closures by the Security Police may occur at any time causing all personnel entering or exiting a closed installation to experience a delay. This cannot be predicted or prevented. Contractors are not compensated for unexpected closures or delays. Vehicles operated by contractor personnel are subject to search pursuant to applicable regulations. Any moving violation of any applicable motor vehicle regulation may result in the termination of the contractor employee’s installation driving privileges.
1.2.2 The contractor’s employees shall become familiar with and obey the regulations of the installation; including fire, traffic, safety and security regulations while on the installation. Contractor employees should only enter restricted areas when required to do so and only upon prior approval. All contractor employees shall carry proper identification with them at all times, and shall be subject to such checks as may be deemed necessary. The contractor shall ensure compliance with all regulations and orders of the installation, which may affect performance. The Government reserves the right to direct the removal of an employee from Government property or revoke access to Government systems for misconduct, security reasons, or any overt evidence of communicable disease. Removal of contractor employees for reasons stated above does not relieve the Contractor from responsibility for total performance of this contract.
1.2.2 Recognized Holidays: The following are recognized United States (US) holidays. The contractor shall not perform services on these days:
· New Year’s Day: January 1st
· Martin Luther King, Jr.’s Birthday
· President’s Day
· Memorial Day
· Juneteenth National Independence Day: June 19th
· Independence Day: July 4th
· Labor Day
· Columbus Day
· Veteran’s Day: November 11th
· Thanksgiving Day
· Christmas Day: December 25th
1.2.3 Quality Control (QC): N/A
1.2.4 Quality Assurance (QA): The Government will evaluate the contractor’s performance under this contract in accordance with the Quality Assurance Surveillance Plan (QASP). This plan is primarily focused on what the Government will do to ensure that the contractor has performed in accordance with the performance standards. It defines how the performance standards will be applied, the frequency of surveillance, and acceptable quality level(s) or defect rate(s).
1.2.5 Installation Access and Security Requirements. The contractor shall comply with all applicable installation/facility access and local security policies and procedures, which may be obtained from the COR. The contractor and all associated subcontractor employees shall provide all information required for background checks to meet installation access requirements to be accomplished by installation Provost Marshal Office, Director of Emergency Services, or Security Office. The contractor shall ensure compliance with all personal identity verification requirements as directed by Department of Defense (DoD), Headquarters Department of Army (HQDA) and/or local policy (see PWS 6.0). Should the Force Protection Condition (FPCON) change, the Government may require changes in contractor security matters or processes.
1.2.6 Physical Security. The contractor shall safeguard all Government property provided for contractor use. At the close of each work period, Government facilities, equipment and materials shall be secured.
1.2.7 Special Qualifications: The contractor shall ensure all employees possess all required licenses for the operation of any equipment used in the performance of this contract. This does not include education or other qualifications for the position in which the contractor employee is performing, dress codes, or other information. (NOTE: The Government does not provide training to contractors. Contractors must ensure that any personnel performing under a contract are fully trained, licensed, certified, and otherwise qualified to provide services.)
1.2.8 Post Award Conference/Periodic Progress Meetings: The contractor agrees to attend any post award conference convened by the KO in accordance with FAR 42.5. The KO, COR and other Government personnel, as appropriate, may meet periodically with the contractor to review the contactor’s performance. At these meetings, the KO will apprise the contractor of how the Government views the contractor’s performance and the contractor shall apprise the Government of problems, if any, being experienced. The contractor shall resolve outstanding issues raised by the Government. Contractor attendance at these meetings shall be at no additional cost to the Government.
1.2.9 Contract Manager (CM): The contactor shall designate a CM who shall ensure performance under this contract. The name of this person, and an alternate who shall act for the contractor when the CM is absent, shall be designated in writing to the KO. The CM or alternate shall have full authority to act for the contractor on all contract matters relating to daily operation of this contract. The CM shall work through the COR, to resolve issues, receive technical instructions, and ensure adequate performance of services. The CM shall ensure that contractor employees do not perform any services outside the scope of the contract without an official modification issued by the KO. The CM shall ensure contractor employees understand that services performed outside the scope of the contract are performed wholly at the expense of the contractor.
1.2.10 Identification of Contractor Employees: All contractor personnel attending meetings, answering Government telephones and working in other situations where their contractor status is not obvious to third parties are required to identify themselves as such to avoid creating an impression that they are Government employees. The contractor shall ensure that all documents or reports produced by contractor personnel are suitably marked as contractor products or that contractor participation is appropriately disclosed. The contractor’s status as a “contractor” shall be predominantly displayed in all correspondence types (to include signature blocks on e-mail) and dealings with Government or non-Government entities. Contractor personnel shall wear identification badges distinguishing themselves as such. The badges shall have the company name, employee name and the word “contractor” displayed.
1.2.11 Organizational Conflicts of Interest (OCI): The contractor and subcontractor personnel performing services under this contract may receive, have access to or participate in the development of proprietary or source selection information (e.g., cost or pricing information, budget information or analyses, specifications or work statements, etc.) or perform evaluation services which may create a current or subsequent OCIs, as defined in FAR Subpart 9.5. The contractor shall notify the KO immediately whenever it becomes aware that such access or participation may result in any actual or potential OCI and shall promptly submit a plan to the KO to avoid or mitigate any such OCI. The contractor’s mitigation plan will be determined to be acceptable solely at the discretion of the KO. In the event the KO unilaterally determines that any such OCI cannot be satisfactorily avoided or mitigated, the KO may impose other remedies as he or she deems necessary, including prohibiting the contractor from participation in subsequent contracted requirements which may be affected by the OCI.
2.0 Definitions and Acronyms:
2.1 Definitions:
2.1.1 Contractor: A supplier or vendor awarded a contract to provide specific supplies or service to the Government. The term used in this contract refers to the prime.
2.1.2 Defective Service: A service output that does not meet the standard of performance associated with the PWS.
2.1.3 Deliverable: Anything that can be physically delivered and includes non-manufactured things such as meeting minutes or reports.
2.1.4 Key Personnel: Contractor personnel that are evaluated in a source selection process and that may be required to be used in the performance of a contract by the PWS. When key personnel are used as an evaluation factor in best value procurement, an offer can be rejected if it does not have a firm commitment from the persons that are listed in the proposal.
2.1.5 Physical Security: Actions that prevent the loss or damage of Government property.
2.1.6 Quality Assurance: The Government procedures to verify that services being performed by the Contractor are performed according to acceptable standards.
2.1.7 Quality Assurance Surveillance Plan (QASP): An organized written document specifying the surveillance methodology to be used for surveillance of contractor performance.
2.1.8 Quality Control: All necessary measures taken by the Contractor to ensure that the quality of an end product or service shall meet contract requirements.
2.1.9 Subcontractor: One that enters into a contract with a prime contractor. The Government does not have privity of contract with the subcontractor.
2.2 Acronyms:
| AR | Army Regulation |
| AT/OPSEC | Antiterrorism/Operational Security |
| COR | Contracting Officer Representative |
| DA | Department of the Army |
| DFARS | Defense Federal Acquisition Regulation Supplement |
| DoD | Department of Defense |
| FAR | Federal Acquisition Regulation |
| KO | Contracting Officer |
| NGB | National Guard Bureau |
| OCI | Organizational Conflict of Interest |
| PII | Personally Identifiable Information |
| POC | Point of Contact |
| PRS | Performance Requirements Summary |
| PWS | Performance Work Statement |
| QA | Quality Assurance |
| QASP | Quality Assurance Surveillance Plan |
| QC | Quality Control |
| SCR | Service Contract Reporting |
| TE | Technical Exhibit |
3.0 Government Furnished Property, Material, Equipment and Services (GFP/M/E/S): The Government will provide the property, material, equipment, and/or services listed below solely for the purpose of performance under this contract:
3.1 Property: The Government will furnish the necessary workspace for the contractor to perform services outlined in this PWS to include desk space, telephones, computers and other items necessary to maintain an office environment.
4.0 Contractor Furnished Property, Materials, and Equipment (CFP/M/E):
4.1 General: Except for those items specifically stated to be Government-Furnished in Paragraph 3.0, the contractor shall furnish everything required to perform these services as indicated in Paragraph 1.1.
5.0 Requirements: The contractor shall:
5.1 Data Analytics Integration
5.1.1 Description: This function will serve as the primary technical architect for synchronizing Manpower and Budget data. The core mission is to bridge the gap between human resources information and financial execution, transforming raw data from disparate legacy systems into actionable predictive data for senior leadership.
5.1.2 Duty Requirements: The Data Analytics Integrator will design, develop, and maintain a suite of data products by extracting, transforming, and loading data from human resource and budget source systems, including but not limited to: General Fund Enterprise Business System (GFEBS), Full-Time Support Management Control System (FTSMCS), and Defense Civilian Personnel Data System (DCPDS), and Power BI on a daily basis.
5.1.3 Tasks and responsibilities are as follows:
5.1.3.1 The contractor shall automate and maintain a LWOP/RTD product for tracking leave without pay and Return to Duty status to ensure pay accuracy and position management.
5.1.3.2 The contractor shall generate a centralized dashboard for Quality Step Increases (QSI) and monetary awards to monitor budget impact and processing timelines.
5.1.3.3 The contractor shall generate a product for tracking the status of civilian employees’ military service credit deposits.
5.1.3.4 The contractor shall create and maintain a Vacancy Fill & Projections tool with real-time visibility into current vacancies with predictive modeling for anticipated “time-to-fill’ metrics.
5.1.3.5 The contractor shall generate a product using data from varies source systems that shows reporting discrepancy between AGR/Tech personnel and accounting system of record.
5.1.3.6 The contractor shall generate and maintain a Status of Funds (SoF) Dashboard that mirrors NGB Dashboard to show integrated views of available, committed, and obligated funds specifically tied to personnel accounts.
5.1.3.7 The contractor shall develop a Customer Action Tracker for workflow visualization tool to monitor the lifecycle of personnel and budget requests from initiation to completion.
5.1.3.8 The contractor shall develop a sophisticated model to forecast personnel trends (retirements, attritions, and promotions) to project future budgetary requirements and manpower gaps over a multi-year horizon.
TECHNICAL EXHIBIT 1
Performance Requirements Summary (PRS)
This PRS includes performance objectives the Government will use to determine contractor performance and will compare contractor performance to the Acceptable Quality Level (AQL).
| Performance Objective |
| Performance Standard |
| Acceptable Quality Levels (AQL) |
| Surveillance Method / By Whom |
5.1.3.1 LWOP/RTD Product Data Integration & Dashboard Reliability
| The contractor shall provide LWOP/RTD tracker with integrated budget impacts and updated by the required data refresh schedule. |
| 95% accuracy rates. Data refreshes completed within 24 hours of source system updates. |
| Periodic Inspection / COR |
5.1.3.2 Awards/QSI Product
| The contractor shall provide a centralized dashboard for Awards/QSI data. |
| 98% accuracy rate. No more than 1 minor error per deliverable, and zero critical errors that impact strategic decision-making. |
| 100% inspection of final deliverables. / COR |
5.1.3.3 Military Buyback Product
| Automate and maintains data pulled from HRO systems to track military service credit deposits. . |
| 100% accuracy rate for military service credit deposits. Updated monthly |
| Monthly Inspection / COR |
5.1.3.4 Vacancy Fill & Projections Tool
| Create tool using Data form DCPDS with predictive modeling. |
| 95% accuracy rates. Data refreshes completed within 24 hours of source system updates |
| Bi-Weekly Inspection/COR |
5.1.3.5 Tech/AGR Voucher Reconciliation
| Create power BI to provide discrepancy reports using GFEBS, FTSMCS, and DCPDS. |
| 95% accuracy rates. Data refreshes completed within 24 hours of source system updates. |
| Bi-Weekly Inspection/COR |
5.1.3.6 SoF Dashboard
| The contractor shall provide an integrated dashboard with daily SoF updates. |
| 98% accuracy rate. No more than 1 minor error per deliverable, and zero critical errors that impact strategic decision-making. |
| Bi-Weekly Inspection/COR |
5.1.3.7 Customer Action Tracker
| The contractor shall Create tool using Data form DCPDS to monitor personnel lifecycle |
| 95% accuracy rates. Data refreshes completed within 24 hours of source system updates |
| Bi-Weekly Inspection/Benefits Supervisor |
5.1.3.8 AGR/Tech Life Cycle Predictive Model
| Create and maintain AGR/Tech life cycle tool using Data from various source systems |
| 95% accuracy rates. Data refreshes completed within 24 hours of source system updates |
| Monthly Inspection / COR |
TECHNICAL EXHIBIT 2
Estimated Workload Data
This information is provided for historical background only. It is not a guarantee of workload quantities.
| ITEM |
| Work Performed |
| ESTIMATED FTE |
| 1 |
| Data Analytics Integrator |
| 1 |
File details come from the government source that posted it. Updated .