Location: Braine l’Alleud, Belgium

Duties & Roles

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.

Education, Experience and Training (essential)

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

Education, Experience and Training (desired)

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