BI Data Engineer

Spektrum have a wide range of exciting opportunities in several global locations.

We are always looking to add great new talent to our team and look forward to hearing from you.

Spektrum supports apex purchasers (NATO, UN, EU, and National Government and Defence) and their Tier 1 supplier ecosystem with a wide range of specialist services. We provide our clients with professional services, specialised aerospace and defence sales, delivery, and operational subject matter expertise. We are looking for personnel to join our team and support key client projects.

Who we are supporting 

The NATO Communication and Information Agency (NCIA) is responsible for providing secure and effective communications and information technology (IT) services to NATO's member countries and its partners. The agency was established in 2012 and is headquartered in Brussels, Belgium.

The NCIA provides a wide range of services, including:

• Cyber Security: The NCIA provides advanced cybersecurity solutions to protect NATO's communication networks and information systems against cyber threats.
• Command and Control Systems: The NCIA develops and maintains the systems used by NATO's military commanders to plan and execute operations.
• Satellite Communications: The NCIA provides satellite communications services to enable secure and reliable communications between NATO forces.
• Electronic Warfare: The NCIA provides electronic warfare services to support NATO's mission to detect, deny, and defeat threats to its communication networks.
• Information Management: The NCIA manages NATO's information technology infrastructure, including its databases, applications, and servers.

Overall, the NCIA plays a critical role in ensuring the security and effectiveness of NATO's communication and information technology capabilities.

The program

Assistance and Advisory Service (AAS)

The NATO Communications and Information Agency (NCI Agency) is NATO’s principal C3 capability deliverer and CIS service provider. It provides, maintains and defends the NATO enterprise-wide information technology infrastructure to enable Allies to consult together under Article IV, and, when required, stand together in the face of attack under Article V.

To provide these critical services, in the modern evolving dynamic environment the NCI Agency needs to build and maintain high performance-engaged workforce. The NCI Agency workforce strategically consists of three major categorise's: NATO International Civilians (NIC)'s, Military (Mil), and Interim Workforce Consultants (IWC)'s. The IWCs are a critical part of the overall NCI Agency workforce and make up approximately 15 percent of the total workforce.

Role ID – 2025-0277

Role Background

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

Role Duties and Responsibilities

• 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
• 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.

Essential Skills, Experience and Certifications

• 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.

Desirable Skills, Experience and Certifications

• 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.

Languages

• Full proficiency in the English language.

Working Location

• Braine l’Alleud, Belgium

Working Policy

• Hybrid (30% onsite/7-% offsite)

Travel

• Some travel to other NATO sites may be required

Security Clearance

• Valid National or NATO Secret personal security clearance

We never know what new opportunities might be just over the horizon. If this opportunity isn't for you please feel free to send us your resume anyway and be the first to know if something suitable for your skills and experience comes up.