Logo for Keystone Solutions

Analytical Engineer

Role overview

Summary

This role focuses on assessing and improving the quality of CMDB data for Keystone Solutions' clients. You will work closely with CMDB owners and stakeholders to identify data quality issues and design analytical models that enhance data usability and reporting.

Qualifications

  • Experience with CMDB concepts, entities, and relationships.
  • Proficiency in SQL and data profiling.
  • Experience with dbt data modeling and transformations.
  • Knowledge of data governance and analytical dataset management.
  • Active knowledge of English and Dutch.

Responsibilities

  • Analyze CMDB data for completeness, accuracy, consistency, duplicates, and missing relationships between configuration items.
  • Perform gap analyses between the expected CMDB structure and existing data, documenting findings and proposed next steps.
  • Design, build, and maintain analytical data models using dbt, applying Kimball dimensional modeling principles.
  • Implement dbt tests, documentation, lineage, and naming conventions to improve data model transparency and reliability.

Key facts

Hard skills

Key skills for this role

Other skills

  • Analytical Thinking
  • Communication
  • Curiosity
  • Problem Solving
  • Detail Oriented

About the company

Keystone Solutions logo

Keystone Solutions

  • IT Services & Consulting
  • SME
  • 51–200
Are you looking for a new partner that provides IT Services ?​As a Belgian IT services company, we are specialized in Professional Software Development services and IT security. We create custom software based on our client's specifications to effectively support their business operations. We also support them in managing the security of their information.​ With our dedicated engineers managing and delivering solutions from A to Z, we bring our expertise to energize internally managed projects in a consultancy model to achieve digital transformation goals.​Our values are:​• Commitment : Customer satisfaction is our main concern​• Integrity : We respect our fellowmen, colleagues, and clients​• Solutions : We fix problems and offer creative and first-class solutions internally and externally​At Keystone Solutions, we do our best to make a positive contribution to society by continuously improving the Environmental, Social, and Governance (ESG) criteria. First, we care about the environment and aim to minimize the impact of our activities on pollution, deforestation and climate change. Second, we strive to provide a dynamic work environment that encourages learning and growth. Within our team, we also keep and encourage diversity. Third, we are transparent about our governance and ensure openness in contacts between Keystone Solutions and shareholders.​To find out more about us, visit our website : www.keystone-solutions.be.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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

If you are ready to tackle technical and strategic challenges in a dynamic consultancy environment, apply today at Keystone Solutions Career Portal.


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


Skills required:

  • CMDB - Level: Confirmed - Most recent: Any time
  • Data Factory - Level: Confirmed - Most recent: Any time
  • Data Lake - Level: Confirmed - Most recent: Any time
  • Databricks - Level: Confirmed - Most recent: Any time
  • DevOps - Level: Confirmed - Most recent: Any time
  • Docker - Level: Confirmed - Most recent: Any time
  • GitHub - Level: Confirmed - Most recent: Any time
  • GitLab CI/CD - Level: Confirmed - Most recent: Any time
  • Grafana - Level: Confirmed - Most recent: Any time
  • Kubernetes - Level: Confirmed - Most recent: Any time
  • Micorsoft Azure DevOps - Level: Confirmed - Most recent: Any time
  • PostgreSQL - Level: Confirmed - Most recent: Any time
  • POWER BI - Level: Confirmed - Most recent: Any time
  • Python - Level: Confirmed - Most recent: Any time
  • REST API - Level: Confirmed - Most recent: Any time
  • SQL - Level: Confirmed - Most recent: Any time
  • Terraform - Level: Confirmed - Most recent: Any time

Language requirements:

Dutch
Level Active knowledge
English
Level Active knowledge
French
Level Passive knowledge

Related jobs

See all Analytics Engineer jobs

Other jobs at Keystone Solutions