Deadline Date:
Tuesday 16 September 2025
Requirement:
Support for Business Intelligence Development, Modelling and Service Integration
Location:
Braine-l'Alleud, BELGIUM
Full Time On-Site:
No
Time On-Site:
30%
Not to Exceed:
2025 Base: NTE 46,440 EUR (12 weeks x 4,300 EUR per week)
2026, 2027, 2028 options
Period of Performance:
2025 Base: 1 October 2025
Required Security Clearance:
NATO SECRET
Please do NOT
apply for any NATO contract positions unless you meet ALL the following criteria:
- Current National or NATO SECRET clearance
- Nationality of one of the NATO member countries
- Current work visa for the specific location if applying for an in-country position
Any applications that do NOT meet all the above - and do not CLEARLY show these on the CV - will be deleted.
Introduction:
- To strengthen the Alliance through connecting its forces, the NCIA delivers secure, coherent, cost effective and interoperable communications and information systems in support of consultation, command & control and enabling intelligence, surveillance and reconnaissance capabilities, for NATO, where and when required. It includes IT support to the Alliances' business processes (to include provision of IT shared services) to the NATO HQ, the Command Structure and NATO Agencies.
- The NATO Business Application Centre (NBAC), as part of the NCIA, and in line with the Agency's Charter and its Cloud broker role, is to provide Business Applications Capabilities & Services to the Agency, and across NATO Enterprise, and ensure their harmonization rationalisation, and coherence, with the aim to enable overall efficient day-to-day operations, support transparency, and foster internal control.
- In the light of these activities, NBAC (hereafter referred to as the "Purchaser") is seeking Business Intelligence Development, Modelling and Service Integration support to contribute to the NBAC Business Area - the Analytics and Core Business Applications Branch. This service will focus on ensuring the development, configuration, and deployment of data pipelines from ServiceNow (on-premise) to the reporting database (Oracle Database). The goal of the activity is to move away from using the non-standard ODBC interface for ServiceNow data extraction in ETLs and use vendor supported official interface (API). This activity will provide more stability in the data pipelines with the ServiceNow application upgrades and prepare us for the future move to the cloud version of the ServiceNow application.
- The Contractor is expected to design, develop, and implement efficient, scalable, and maintainable ETL processes using Oracle Data Integrator (ODI) to extract data from ServiceNow APIs and load into the target reporting database (Oracle). The solution must cover both initial full loads and incremental load strategies, with the goal of delivering a sustainable and extensible data pipeline framework for internal use. The service includes coordinating with the internal BI and ServiceNow teams, alignments with business stakeholders, documenting technical work.
- The Analytics and Core Business Applications is a Branch in NATO Business Application Centre (NBAC) consisting of multiple flavours, It provides technical, architectural, and operational support for enterprise business applications and data analytics platforms; and enables business users to access, interpret, and leverage data-driven insights across NATO entities, including ACO, NATO HQ, and the NCIA.
- 2.2 The work depicted in this SOW is expected to be carried by a SINGLE RESOURCE and aims to enhance the support model for NBAC Analytics and Core Business Applications, focusing on the data pipelines development, data modelling, data integration and end-user enablement.
Under the direction / guidance of the local NCIA Point of Contact or NBAC Analytics and Core Business Application Head, the contractor will support the following below:
Review of Existing ServiceNow API-based ETLs:
Assess the current prototype ETL implementation provided by the Purchaser, identifying performance bottlenecks, scalability challenges, and maintainability gaps.
Troubleshoot known issues and propose corrective actions.
Improvement and Re-implementation Strategy:
Deliver a recommended improvement or reimplementation strategy for the existing ETL prototypes.
Where performance limitations are critical, propose viable alternative approaches, including options other than the current API usage.
Performance and Scalability Assessment
Evaluate end-to-end performance of the prototype ETLs.
Establish whether current load times, throughput, and system behaviour can meet production-level expectations, and propose adjustments to improve scalability and stability.
Review and Enhancement of Attribute Mappings
Revisit the mapping of ServiceNow attributes into the target reporting datasets.
With input from business stakeholders, validate existing mappings and create additional mappings as required to deliver the full defined dataset.
Implementation of ETL Pipelines for Defined Tables
Configure ServiceNow APIs and implement ODI ETL jobs for the eight (8) defined tables.
ETLs must support both initial and incremental load scenarios, and conform to NCIA development guidelines and naming standards.
Deleted Record Handling
Incorporate logic to properly handle deleted records from the source system by leveraging the sys_audit_delete table.
Ensure that downstream reporting datasets remain consistent with the current ServiceNow system state.
Reusable Framework and Templates
Use reusable components, templates, and configurations to enable future extensibility of ETLs.
Ensure these are delivered in form that can be applied to additional datasets beyond the initial scope.
Deployment and Environment Promotion
Provide deployment scripts and clear operational instructions to promote ETL jobs across environments (DEV-TEST-PROD).
Ensure processes are repeatable and compliant with NATO/NCIA guidelines.
ETL Performance Benchmarks
Validate that ETLs meet minimum performance criteria: initial load of all tables within one working day, and incremental loads of all tables within 180 minutes under normal conditions (subject to review after assessment).
Technical Documentation
Produce complete documentation covering ETL architecture and design, job flows, load logic, error handling, configuration details, and extension procedures.
Documentation must enable independent operation by NBAC staff.
Knowledge Transfer and Training
Conduct handover sessions with the NBAC BI team (accommodating both in-person and remote formats).
Walk through ETL components, orchestration logic, and troubleshooting steps, ensuring continuity of operations.
Stakeholder Alignment and Sign-off
Present findings, proposals, and documentation to internal stakeholders.
Host review meetings to answer questions, capture feedback, and update deliverables as required until sign-off and team readiness are confirmed.
The contractor will be part of the project management and implementation team, working closely with the Analytics and Core Business Application team, ensuring the secure, available, managed and compliant delivery of Power BI services to NCIA, NATO and its Strategic Commands.
The measurement of execution for this work is sprints, with each sprint being planned for a duration of 5 working days.
Requirements
Required Classification:
Contractor - MANDATORY Requirements:
- All contractor personnel delivering services on the contract must hold a NATO SECRET Security Clearance.
- 7 - 10 years of Data engineering implementation experience and in configuring and integration of business applications.
- 5 years+ experience using Oracle Data Integrator.
- 2 years+ working experience with ServiceNow data extraction, via native APIs and/or alternatives such as data replication APIs.
- 2 years+ working knowledge of the ServiceNow data model and processes.
- 5 years+ working experience in Oracle Databases.
- Experience developing complex SQL queries and ETL.
- Data Modelling and Design. Proficient in designing normalized and denormalized data models, star/snowflake schemas.
- Proven work experience of Level 2 and Level 3 support—including incident, problem, change, and service request fulfilment—using ITIL processes and service-management tooling.
- Strong analytical and problem-solving skills with the ability to analyse complex data sets.
- Excellent communication and interpersonal skills, with the ability to explain technical concepts to both technical and non-technical audiences.
- Strong project management and organizational skills.
- The ability to document processes, perform knowledge transfer.
- Ability to work independently and as part of a team.
- Full proficiency in the English language.
- Proven experience as a BI Consultant, a strong understanding of DWH architecture, components, functionalities and Oracle and ServiceNow technologies.
- Prior experience of working in Agile development methodologies.
- Prior experience of working in an international environment comprising both military and civilian elements.
- Knowledge of NATO responsibilities and organization, including ACO and ACT.