2025-0225 Microsoft Power BI Dashboard and Visualization Dev (NS) - THU 21 Aug

Time On-Site: 60%

2026 Option: 1st January 2026 until 26st December 20262027 Option: 1st January 2027 until 31st December 20272028 Option: 1st January 2028 until 31st December 2028

The NATO Information and Communication Agency (NCI Agency) located in The Hague, The Netherlands, is involved in the maintenance and development of command and control capabilities for NATO as well as in the support of these capabilities.In the light of these activities, the C2 Business Area is looking for support related to data analysis and developing Power BI dashboards and visualizations.

The main objective of this statement of work is to provide the technical expertise in data analysis and design and developing Power BI dashboards and visualisation solutions to enable data-driven decision-making within the area of force management and operations planning application services (TOPFAS).Delivery of the services under this statement of work requires skills of one Microsoft Power BI Data Analysis, Dashboard and Visualization expert.

The contractor’s personnel will be work under the direction and guidance of a NCI Agency technical lead and product manager, and will provide the service using an agile and iterative approach using multiple sprints. Each sprint is planned for an approximate duration of 2 weeks.The services shall be executed mainly on-site at the NCI Agency; some sprints might require the visit to other NATO locations. The development work will be carried out accessing the Azure DevOps NATO Software Factory development environment.The scope of the assignment will be covering the following activities:•       Functional and technical analysis of existing capabilities and data models, and assess how it can be utilized within Power BI;•       Perform data analysis on test and operational environment (NS);•       Analyse operational requirements, develop user stories, including acceptance criteria and test cases to evaluate the final functionality;•       Coordinate requirements and user stories with users;•       Design dashboard and visualisation solutions to enable data-driven decision-making;•       Coordinate the technical work with the team and systems required to integrate, including integration testing;•       Implement data modelling and transformation techniques to clean, map and transform the data•       Implement and test the solutions, traceable through the Azure DevOps NATO Software Factory development environment;•       Deploy and test the solution to the operational environment (NS);•       Support the user on the operational environment (NS), correct issues and provide stability improvements;•       Create and update documentation to facilitate knowledge transfer and future maintenance.The services are required to be delivered within NCI Agency business hours as per paragraph 9 of this statement of work and their related acceptance criteria.

The content and scope of each sprint will be agreed with the technical lead and product manager during the sprint-planning meeting in writing.The contractor shall participate in workshops, events and conferences related to the supported services, as requested by the NCI Agency project team.

The contractor’s personnel shall report to the NCI Agency’s designated technical lead and product manager.The contractor shall participate in daily status update meetings, sprint planning, sprint retrospectives and other meetings, in person or via electronic means using conference call capabilities, according to project manager’s instructions. When using conference call capabilities, the camera feature should be used at all times.For each sprint to be considered as complete and payable, the contractor:•       Must report the progress of his/her service and any impediments during the sprint daily meetings;•       Should report verbally the service completed during the sprint review;•       Should prepare a demo of the service completed and present it to the team during the sprint demo meeting.Due to the agile and iterative approach, there is a need to define a set of specific arrangements between the NCI Agency and the contractor that specifically defines the deliverables to be provided for each sprint as well as their associated acceptance criteria.

This includes sprint planning, execution and review processes, which are detailed below:

•       Objective: Plan the objectives for the upcoming sprint.•       Kick-off meeting: Conduct a bi-weekly (every two weeks) meeting with the contractor to plan the objectives of upcoming sprint and review contractor`s manpower to meet the agreed deliverables.•       Set sprint goals: Define clear, achievable goals for the sprint and associated acceptance criteria, including specific delivery targets, Quality standards as well as Key Performance Indicators (KPIs) for each task to be recorded in the sprint meeting minutes.•       Agree on the required level of effort for the various sprint tasks.•       Backlog Review: Review and prioritise the backlog of tasks, issues, and improvements from previous sprints.•       Assess each payment milestone cycle duration of two sprints.

State of completion and validation of each sprint status and sign off sprints to be submitted for payment as covered in Section 4.

•       Objective: Contractor to execute the agreed “sprint plans” with continuous monitoring and adjustments.•       Regular meetings between NCIA and the contractor to review sprint progress, address issues, and make necessary adjustments to the processes or production methodology. The Meetings will be physically in the office.•       Continuous improvement: Contractor to establish a continuous feedback loop to gather input from all stakeholders for ongoing improvements and their subsequent implementation depending on NCIA approval.•       Progress Tracking: Contractor to use a shared dashboard or tool to track the status of the sprint deliveries and any issues.•       Quality Assurance/Quality Check: Contractor shall ensure that the quality standards agreed for the sprint deliverables are maintained throughout the sprint.•       Quality Control: NCIA to perform the final quality control of the agreed deliverables and provide feedback on any issues.

•       Objective: Review the sprint performance and identify areas for improvement.•       At the end of each sprint, there will be a meeting between the NCIA and the Contractor to review the outcomes against the acceptance criteria comprising sprint goals, agreed quality criteria and Key Performance Indicators (KPIs).•       Define specific actions to address issues and enhance the next sprint.

•       For each sprint to be considered as complete and payable, the contractor must report the outcome of their service during the sprint, first verbally during the sprint review meeting and then in writing within three (3) days after the sprint’s end date. A report must be sent by email to the NCIA service manager, listing the achievements and services held against the agreed tasking list set for the sprint.•       The contractor's payment for each sprint will be depending upon the achievement of agreed acceptance criteria for each task, defined at the sprint planning stage.

This will include specific delivery targets, quality standards as well as Key Performance Indicators (KPIs) for each task.•       The payment shall be dependent upon successful acceptance as set in the above planning/review meetings. This will follow the payment milestones that shall include a completed Delivery Acceptance Sheet (DAS) – (Annex B).•       Invoices shall be accompanied with a Delivery Acceptance Sheet (DAS) – (Annex B) signed by the Contractor and project authority.•       If the contractor fails to meet the agreed acceptance criteria for any task, the NCIA reserves the right to withhold payment for that task/sprint.At the end of the project, the contractor shall provide a project closure report that is summarizing the activities during the period of performance at high level.

The following deliverables are expected from this statement of work:1) Complete the activities/tasks agreed in each sprint meeting as per sections 2 and 3 above.2) Produce sprint completion reports (format: e-mail update), which include details of activities performed. Specifically, the resolved Product Backlog Items will be broken down into number of Tasks, traceable through Azure DevOps NATO Software Factory development environment.Payment schedule will be at the end of each two sprints, following the acceptance of the sprint report.The NCIA reserves the possibility to exercise a number of sprints at a later time and or additional options, based on the same sprint deliverable timeframe and cost, depending on project priorities and requirements.The payment shall be dependent upon successful acceptance of the sprint report and the Delivery Acceptance Sheet (DAS) – (Annex B), signed by the contractor and the NCIA POC.Invoices shall be accompanied with a signed Delivery Acceptance Sheet (Annex B)The following deliverables are expected within the performance period.  2025 BASE: 22 September 2025 to 31 December 2025Deliverable:  7 Sprints Payment Milestones: Upon completion of each two sprints following acceptance.

2026 OPTION: 01 January 2026 to 31 December 2026 Deliverable: Up to 23 Sprints Cost Ceiling: Price will be determined by applying the price adjustment formula as outlined in CO‐115786‐ AAS+ Special Provisions article 6.5. Payment Milestones: Upon completion of each two sprints following acceptance. 2027 OPTION: 01 January 2027 to 31 December 2027 Deliverable: Up to 23 Sprints Cost Ceiling: Price will be determined by applying the price adjustment formula as outlined in CO‐115786‐ AAS+ Special Provisions article 6.5. Payment Milestones: Upon completion of each two sprints following acceptance. 2028 OPTION: 01 January 2028 to 31 December 2028 Deliverable: Up to 23 Sprints Cost Ceiling: Price will be determined by applying the price adjustment formula as outlined in CO‐115786‐ AAS+ Special Provisions article 6.5. Payment Milestones: Upon completion of each two sprints following acceptance.

This task order will be active immediately after signing of the contract by both parties.The BASE period of performance is as soon as possible but not later 22nd September 2025 and will end no later than 31st December 2025.If the 2026 option is exercised, the period of performance is 01st January 2026 to 31st December 2026.If the 2027 option is exercised, the period of performance is 01st January 2027 to 31st December 2027.If the 2028 option is exercised, the period of performance is 01st January 2028 to 31st December 2028.

Performance of the services described in this statement of work require a valid NATO SECRET security clearance prior to the start of the engagement.The contractor shall be aware of all security rules pertaining to the handling of NATO classified information.Personnel Security Clearance (PSC). Individuals who require access or may have access to information classified NATO Confidential or above during the course of their duties shall have a PSC at the appropriate level, which is valid for the duration of the authorized access.

In addition, such individuals are required to:• Have a need-to-know;• Have been briefed on their security obligations in respect to the protection of NATO classified information; and• Have acknowledged their responsibilities either in writing or an equivalent method which ensures non-repudiation.

All the documentation provided under this statement of work will be based on NCI Agency templates or agreed with project point of contact.All scripts, documentation and required code will be stored under configuration management and/or in the provided NCI Agency tools.All developed solutions, tools and code under this statement of work will be property of the NCI Agency.

The contractor will be required to provide servises 60% (3 days/week) on site, NCI Agency The Hague, and up to 40% (2 days/week) off-site, working from home, following standard business hours:• NCIA core business hourso Monday to Thursday 0830 – 1700, and Friday 0830 – 1500 (CET)• Contractor Furnished Services:o Contractor shall furnish everything required to perform the contract.Access to relevant environments and licenses to commercial third-party libraries required to perform the contract will be provided by NCI Agency.The work depicted in this statement of work is expected to be carried by a SINGLE RESOURCE.

There may be requirements to travel to other sites within NATO for completing these tasks.Travel expenses are out of scope and will be borne by the NCI Agency separately in accordance with Article 5.5 of AAS Framework Contract and within the limits of the NCIA Travel Directive.

The consultancy support for this service requires a Microsoft Power Business Intelligence (BI) developer with the following qualifications:Required minimum qualifications are:

Preferable qualifications are:

Relevant soft skills are: