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.