3180 BI Data Engineer

☞ Contact One Communications, Inc.

View: 105

Update day: 14-11-2025

Location: Braine-l’Alleud Walloon Brabant

Category: IT - Software IT - Hardware / Networking Information Technology

Industry:

Loading ...

Job content

  • Business Intelligence
  • Data Engineer
  • Iterative approach using sprints

Required Security Clearance: NATO SECRET

SCOPE OF WORK
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 behavior 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.

SKILL, KNOWLEDGE & EXPERIENCE

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 analyze 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.
DESIRED Requirements
  • 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.
This is a condensed version of the job description. A full, detailed job description will be provided during the application process.
Loading ...
Loading ...

Deadline: 29-12-2025

Click to apply for free candidate

Apply

Report job
Loading ...

SIMILAR JOBS

Loading ...
Loading ...