Description
For a 30-day assignment between now and the end of February 2027, we (NEO) are looking for a hands-on Analytical Engineer to join our Data Office team and perform an in-depth assessment of the quality, completeness, consistency, and usability of our CMDB data.
The assignment focuses on identifying structural data quality issues, missing or incorrect relationships between configuration items, and gaps between the current CMDB content and the information needed by stakeholders.
The ideal candidate combines strong CMDB and data quality expertise with advanced analytical data modeling skills. They understand CMDB concepts, dependencies, and stakeholder information needs, can design governed analytical datasets using dbt and Kimball dimensional modeling principles, and translate complex data findings into clear business insights. They are capable of structuring analytical data into dimensions, facts, marts, and wide analytical tables while maintaining traceability to the underlying CMDB data. The assignment will result in a structured final report containing findings, identified gaps, proposed next steps, open tasks, and recommendations for analytical data model improvements.
KEY RESPONSIBILITIES :
CMDB Data quality analysis :
- Analyze CMDB data for completeness, accuracy, consistency, duplicates, and missing relationships between configuration items.
- Identify data quality issues, structural gaps, and recurring patterns that reduce the reliability and usability of the CMDB
- Translate analysis findings into clear insights, priorities, and concrete improvement actions
GAP analysis & documentation :
- Perform gap analyses between the expected CMDB structure, the existing data, and stakeholder information needs.
- Document findings, root causes, impact, proposed next steps, and open tasks in a clear and actionable final report.
- Work with CMDB owners, service management, infrastructure teams, and data stakeholders to validate interpretations and align expectations.
Data modeling with DBT :
- Design, build, and maintain analytical data models using dbt, with a clear focus on reusable, governed, and business-oriented datasets.
- Apply Kimball dimensional modeling principles by structuring data into dimensions, facts, marts, and wide analytical tables that support clear business analysis and reporting needs.
- Map CMDB entities, relationships, and stakeholder questions to the appropriate analytical model design, ensuring the resulting datasets remain traceable to the underlying CMDB reality.
- Implement dbt tests, documentation, lineage, and naming conventions to improve transparency, reliability, and maintainability of the data model.
REQUIRED SKILLS & EXPERIENCE :
Soft Skills :
- Analytical thinking
- Clear communication
- Natural curiosity
- Ownership & accountability
- Problem-solving mindset
- Accuracy and attention to detail
Technical Skills :
- CMDB concepts, entities, and relationships
- Data quality analysis
- SQL and data profiling
- dbt data modeling, transformations, model structuring, and Kimball dimensional modeling
- dbt testing, documentation, lineage, and naming conventions
- Gap analysis and root-cause analysis
- Kimball dimensional modeling: dimensions, facts, marts, and wide analytical tables
- Reporting and visualization
- IT service management or asset management
- Python for data analysis, data quality controls, automation, and reporting
- Data engineering practices (ETL/ELT, data pipelines, data integration)
- Azure Data Platform and cloud-based data environments
- Metadata analysis, lineage management, and data traceability
- Data governance and analytical dataset management
- Dashboarding and analytical reporting (Power BI or equivalent)
Nice to have :
- Experience with OmniTracker or a comparable CMDB/ITSM tool.
- Knowledge of ITIL processes, configuration management, and service lifecycle management.
- Experience with data quality tooling, profiling frameworks, or automated quality controls.
- Experience working in highly regulated environments and/or experience in public service organisations.
- Experience with Azure-based data platforms and cloud-native data solutions.
- Experience building and maintaining data pipelines and integrating heterogeneous data sources.
- Experience with metadata management, data lineage, and traceability concepts.
- Experience with Python for analytical automation, data validation, and reporting.
- Experience with dashboarding and data visualization tools such as Power BI.
- Knowledge of modern data engineering practices (DevOps, CI/CD, automated testing).
- Experience working with large datasets and performing root-cause investigations across complex data ecosystems.
In addition to their CV, candidates, holding a Master’s degree in Computer Science, must answer these two questions (failure to provide an answer, or an inadequate answer, will result in disqualification):
What’s it’s difference between dbt manifest and the catalogue ?
When do you use a macro and when a UDF ?

