Analytical Engineer

Brussel · Voltijds · Telewerk

Over de functie

Mission Overview

Keystone Solutions is seeking a hands-on Analytical Engineer for a consultancy mission at a client site. This role involves performing an in-depth assessment of the quality, completeness, consistency, and usability of CMDB data.

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, focusing 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; 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.

Application Process

In addition to their CV, candidates holding a Master’s degree in Computer Science must answer two specific questions. Failure to provide an answer, or an inadequate answer, will result in disqualification:

  • What’s the difference between dbt manifest and the catalogue?
  • When do you use a macro and when a UDF?

At Keystone Solutions, we pride ourselves on our consultancy nature, offering dynamic projects that provide turbo-charged learning opportunities and a commitment to skyrocketing ambition. Being a

Duration: As soon as possible - 28/02/2027 4 months • (full time)

Skills required

  • CMDBErvaren
  • Data FactoryErvaren
  • Data LakeErvaren
  • DatabricksErvaren
  • DevOpsErvaren
  • DockerErvaren
  • GitHubErvaren
  • GitLab CI/CDErvaren
  • GrafanaErvaren
  • KubernetesErvaren
  • Micorsoft Azure DevOpsErvaren
  • PostgreSQLErvaren
  • POWER BIErvaren
  • PythonErvaren
  • REST APIErvaren
  • SQLErvaren
  • TerraformErvaren

Language requirements

  • NederlandsActieve kennis
  • EngelsActieve kennis
  • FransPassieve kennis

Vergelijkbare vacatures

Wij gebruiken cookies om uw ervaring op onze website te verbeteren. Door deze website te bezoeken, gaat u akkoord met ons gebruik van cookies. Lees meer over ons Privacybeleid.