BI Data Engineer

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 NATOs 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 NATOs communication networks and information systems against cyber threats.
• Command and Control Systems: The NCIA develops and maintains the systems used by NATOs 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 NATOs mission to detect deny and defeat threats to its communication networks.
• Information Management: The NCIA manages NATOs information technology infrastructure including its databases applications and servers.

Overall the NCIA plays a critical role in ensuring the security and effectiveness of NATOs communication and information technology capabilities.

The program

Assistance and Advisory Service (AAS)

The NATO Communications and Information Agency (NCI Agency) is NATOs 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 categorises: 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 Agencys 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 sysauditdelete 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 (DEVTESTPROD).
  • 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 supportincluding incident problem change and service request fulfilmentusing 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 lAlleud 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