Deadline Date:
Monday 3 March 2025
Requirement:
Product Portfolio Data Analysis and Reporting
Location:
The Hague, NETHERLANDS
Full Time On-Site:
Yes
Not to Exceed:
128,700 EUR
Required Start Date:
14 April 2025
Required Security Clearance:
NATO Secret
Bidding Instructions:
Bidders shall submit a proposal clearly providing the following information:
- The proposed approach to address the required scope of work and the defined deliverables (maximum 10 pages, A4 size) with sufficient details to allow assessment for feasibility of the proposal. The proposal should address the minimum requirements from the Statement of work (Annex A). We expect the following key topics to be covered in each bid submission to ensure alignment with the project requirements:
- Clear understanding and approach for data modelling and integration. Demonstrate a structured methodology for integrating and managing datasets.
- Technical expertise in relevant tools and platforms. Proven experience with PowerBI.
- Proven ability to work in an Agile environment. Outline bidders experience with sprint-based execution, detailing how they will work independently while maintaining effective collaboration with stakeholders.
- Relevant portfolio of experience. Include examples of previous work in projects, services, and resource management. Bidder should demonstrate expertise in similar data analysis projects.
- Coordinating user stories and business needs. Demonstrate and provide examples of how they have worked with stakeholders to refine user stories and ensure the solution meets business needs.
- Communication and reporting approach. The role requires independent work, the proposal should specify how progress updates, reporting, and stakeholder communication will be handled. The bidder should provide an example of how they have previously delivered insights to non-technical stakeholders.
- Risk management and problem-solving capabilities. The proposal should outline potential risks (e.g., data inconsistencies, integration issues) and describe how the bidder will proactively mitigate them. The bidder should demonstrate a problem-solving mindset with examples of how they have successfully resolved data integration or analysis challenges in past projects.
- It will be considered an advantage if the bidder can provide case studies or references.
- To evaluate the qualifications and experience for this this contract, the Bidder should provide evidence of successfully delivering three similar projects within the last five years. Evidence should demonstrate proof of performance and be comparable in size and scope to the requirements of this role. Evidence should showcase the ability to manage data and reports, as well the ability to use Business Intelligence tools like SQL, PowerBI and dashboards delivered with Microsoft Excel.
- CVs of the assigned resource(s) for the project with relevant experience regarding bullet points above.
- It is up to the bidder to propose the size of the team that executes the work and produces the deliverables in the time line allocated. The Purchaser may accommodate a reasonable number of personnel at the current facilities.
- The CVs shall clearly distinguish if the proposal is for Key Personnel or not. Relevant experience within NATO is considered as an advantage.
The purpose of this Statement of Work (SOW) is to provide an outline of deliverables and performance expectations for the services to be rendered by the bidding company (hereafter referred to as the “Bidder”), as represented by one or more contractors (hereafter referred to as “the Contractor”) to the NATO Information and Communication Agency, as represented by the NATO Digital Workplace Centre (hereafter referred to as “the Client”). This document will serve as the basis for bidding and selection.
Introduction:
The NATO Information and Communication Agency (NCIA) located The Hague, the Netherlands, is currently involved in the development and support of new and existing capabilities for NATO. In light of these activities, the NATO Digital Workplace Centre (NDWC), within the framework of its mandate, is adapting innovative and secure communications solutions for NATO staff across the Enterprise.
In order to improve the service delivered, NDWC is looking for Product Portfolio Data Analyst and Reporting support to monitor business performance, and to assist management in establishing and preserving clear definition for Service measures and metrics.
These tasks are all geared toward the realization of NDWC’s 2030 objectives. Specifically, the Lines of Efforts are the following:
- Design reports/ dashboards to help Chiefs, Product Owners, Service Delivery Managers (SDMs), Project Managers and other stakeholders understand business behavior, consolidated performance and trends
- Work with other business areas to build and integrate datasets, enabling automation in report generation and enhancing data analysis
- Provide daily reports for operational activities, weekly reports on SLA and Business trends and rolling monthly and quarterly reports on key business metrics.
- The services shall be provided mainly at the NCIA offices in The Hague, but may involve some travel to other NATO and NCIA entities.
The deliverables from the Statement of Work refer to tangible or intangible outputs of the Business Management strategy.
The main objectives of this Statement of Work can be summarized as follows:
- Collect requirements and user stories from key stakeholders including Chiefs, Product Owners, SDMs, Project Managers and others
- Work independently to gather data from different domains and propose improvement to drive data integration and automation
- Design, generate and present data models, dashboards and reports using Power BI and Power Excel to enable NDWC to make data-driven decisions
- Deliver regular reporting to support day-to-day management
This contract uses an iterative approach to delivering data analysis solutions is essential to foster both flexibility and adaptability in addressing evolving business needs. Each iteration will be two-weeks in duration and commence with the definition of a prioritized set of user stories ensuring a clear alignment with business objectives. Acceptance criteria will be addressed up front. These will be set in writing, prior to each iteration.
In addition to these planned deliverables, each iteration will allocate dedicated time to accommodate ad hoc data analyses, maintenance & quality control and other urgent requests. This ensures the contractor can address repeatable maintenance work, unanticipated needs or high-priority data analyses and quality control issues without disrupting the overall progress of the predefined work.
Maintenance work, quality control and ad hoc analyses will be weighed and prioritized in each iteration.
By integrating these activities into the iteration structure, this approach maintains both responsiveness and structured development.
This SoW covers the following epics:
Scope of Work:
Effective business performance tracking ensures NDWC has clear visibility and control in the execution of its strategic objectives and covers business topics such as: financial health, resource allocation, cost management and other quantitative business assessments. These insights are essential for strategic decision-making, aligning financial & human resources with business priorities and ensuring we stay on the right course. The scope of user stories will cover, amongst others, the following areas:
- Budget analysis and monitoring
- Cost management and tracking
- Resource management and optimization
Monitoring and controlling the product portfolio provides a structured approach to evaluating SLA compliance, project outcomes, and service performance. This ensures NDWC meets business expectations and enables NDWC to match the correct resource allocation, both human and financial, with the right priorities. The scope of user stories will cover, amongst others, the following areas:
- SLA (Service Level Agreement) tracking and reporting
- Project performance tracking and reporting
- Service performance tracking and reporting
- Resource leveling and utilization
Maintenance and quality control underpin the reliability, availability and accessibility of data and reporting outputs. It ensures accurate insights and adaptability to changing business needs, thereby supporting effective monitoring and control of both the business performance and the product portfolio. The scope of user stories will cover, amongst others, the following areas:
- Creation and delivery of repeatable and automated reporting outputs
- Execution of repeatable technical tasks (e.g., data model maintenance, data refreshes)
- Addressing repeatable data-driven tasks (e.g., follow-up on data quality issues)
- Managing user access and control
- Conducting user training
- Implementing incremental improvements
- Developing automated data quality checks
Given the nature of the work and the necessity for in-person collaboration, the contractor is required to reserve and include in the offer 10 options for two-day trips within Europe at a fixed price. These travel arrangements are crucial to ensuring the smooth execution of iteration tasks and facilitating timely and effective communication.
Constraints:
All the deliverables in this statement of work shall use the Client’s templates or templates agreed with the NDWC Chief.
All project work package material shall be stored on the Client’s SharePoint Portal.
To complete the deliverables, the Contractor will be provided:
- Network access to NR and NS
- Microsoft Office platform
- Power BI platform
Practical Arrangemeents:
The assigned resource(s) shall be required to provide services on‐site at the NCI Agency in The Hague, the Netherlands.
The resource(s) will provide services under the direction and guidance of the NDWC Business Manager or their designated representative.
The NCI Agency will provide the assigned resource(s) with access to the internal systems and business tools as required.
Travel outside of the country will be required. Travel requests must be made in writing to the NDWC Business Manager at least two working days ahead of the desired date of travel. Travel costs will be reimbursed after travel is complete, as per the deliverables in section 4.1.1. above.
Non-Performance And Remedies:
Performance Reviews:
At the conclusion of each iteration, a performance review will be conducted. This review will evaluate the contractor's work against the defined objectives and deliverables for the iteration. The performance review aims to ensure that the project is on track, identify any areas for improvement, and provide constructive feedback to enhance future performance.
Quality Assurance and Rework:
If a deliverable does not meet the agreed-upon quality standards or fails to pass the acceptance criteria, the Client will be allowed to request two rounds of revisions, if necessary.
If after two rounds of revision, the deliverable still does not meet the quality standards, the Client will reject the deliverable and withhold payment accordingly.
Requirements:
Bidders shall submit a proposal clearly providing the following information:
- The proposed approach to address the required scope of work and the defined deliverables (maximum 10 pages, A4 size) with sufficient details to allow assessment for feasibility of the proposal. The proposal should address the minimum requirements from the Statement of work (Annex A). We expect the following key topics to be covered in each bid submission to ensure alignment with the project requirements:
- Clear understanding and approach for data modelling and integration. Demonstrate a structured methodology for integrating and managing datasets.
- Technical expertise in relevant tools and platforms. Proven experience with PowerBI.
- Proven ability to work in an Agile environment. Outline bidders experience with sprint-based execution, detailing how they will work independently while maintaining effective collaboration with stakeholders.
- Relevant portfolio of experience. Include examples of previous work in projects, services, and resource management. Bidder should demonstrate expertise in similar data analysis projects.
- Coordinating user stories and business needs. Demonstrate and provide examples of how they have worked with stakeholders to refine user stories and ensure the solution meets business needs.
- Communication and reporting approach. The role requires independent work, the proposal should specify how progress updates, reporting, and stakeholder communication will be handled. The bidder should provide an example of how they have previously delivered insights to non-technical stakeholders.
- Risk management and problem-solving capabilities. The proposal should outline potential risks (e.g., data inconsistencies, integration issues) and describe how the bidder will proactively mitigate them. The bidder should demonstrate a problem-solving mindset with examples of how they have successfully resolved data integration or analysis challenges in past projects.
- It will be considered an advantage if the bidder can provide case studies or references.
- To evaluate the qualifications and experience for this this contract, the Bidder should provide evidence of successfully delivering three similar projects within the last five years. Evidence should demonstrate proof of performance and be comparable in size and scope to the requirements of this role. Evidence should showcase the ability to manage data and reports, as well the ability to use Business Intelligence tools like SQL, PowerBI and dashboards delivered with Microsoft Excel.
- CVs of the assigned resource(s) for the project with relevant experience regarding bullet points above.
- It is up to the bidder to propose the size of the team that executes the work and produces the deliverables in the time line allocated. The Purchaser may accommodate a reasonable number of personnel at the current facilities.
- The CVs shall clearly distinguish if the proposal is for Key Personnel or not. Relevant experience within NATO is considered as an advantage.