Sap Business Intelligence Consultant

ThoughtLabs Belgium; Brussel Hoofdstad; On-site; EUR 90,000 - 130,000; Full time

Job summary

ThoughtLabs Belgium is hiring a senior BI/EDW architect to create and maintain the eGrants EDW, design BI architectures for cloud, on‑premises, and hybrid environments, and ensure security and data residency compliance. The role gathers business requirements for data pipelines, storage, and reporting, and leads ETL/ELT development and data modeling for actionable analytics.

You will build dashboards and KPIs for stakeholders, establish data quality and observability, and drive CI/CD testing and

Qualifications

• 10+ years in IT with BI and data warehousing focus.
• At least 10 years of practical SAP Business Objects experience.
• At least 8 years with SAP Data Services.
• Strong enterprise data warehouse design knowledge with dimensional modeling.
• Proficient in SQL; experience with BI reporting tools for enterprise dashboards.
• Experience with ETL/ELT tools to manage enterprise pipelines.
• Knowledge of cloud/on-prem BI architectures and data lake concepts.
• Fluent English; French is a plus.

Responsibilities

• Create and maintain the eGrants EDW and BI models.
• Design BI architectures for cloud, on-premises and hybrid environments.
• Gather and analyze business requirements for data pipelines and reporting.
• Design and implement ETL processes and orchestration workflows.
• Model data (dimensional) to support reporting and analytics.
• Build dashboards, KPIs, and self-service BI for stakeholders.
• Implement data quality frameworks, observability, and SLAs/SLOs.
• Define CI/CD test programs for BI solutions and maintain documentation.
• Govern the BI semantic layer and ensure consistency of metrics.

Skills

Data warehousing

SQL

Data modelling

ETL/ELT

SAP BO

BI tools

SAP Data Services

Power BI

Education

University degree in IT

Tools

SAP Business Objects

Informatica

Talend

dbt

Azure Data Factory

Power BI

Tableau

Qlik

Job description

• Create and maintain the eGrants Enterprise Data Warehouses (EDW);
• Design Business Intelligence (BI) architectures (e.g., data warehouse, data lakehouses) for cloud, on-premises, and hybrid environments, ensuring compliance with security and data residency requirements.
• Gather and analyse business requirements specifically for data pipelines, storage, and reporting solutions;
• Design and implement modern Extract, Transform, Load (ETL) processes and orchestration workflows, incorporating data contracts and schema evolution management;
• Design and implement data models (e.g., dimensional modelling) to support reporting and analytics, ensuring alignment with business requirements;
• Design and build reporting and analytics applications, creating dashboards, KPIs, and self- service BI tools that deliver actionable insights to business stakeholders;
• Design and implement data quality frameworks and health monitoring processes that include data observability (lineage, freshness) and defined Service Level Agreements/Service Level Objectives (SLAs/SLOs);
• Define and execute test programs for BI solutions, including data validation, regression tests, contract tests, and automated pipelines integrated into CI/CD;
• Produce and maintain technical documentation (data dictionaries, lineage, design specifications, runbooks) to support transparency, governance, and audit readiness;
• Govern the BI semantic layer (KPIs, metrics catalog, naming conventions, row-level security) to ensure consistency and trusted insights;
• Optimize cost and performance of BI platforms and warehouses (partitioning, caching, clustering, query optimization, resource scaling);
• Enable self-service BI capabilities for business users through curated datasets, certified reports, and training/support.

Requirements

• University degree in IT combined with relevant IT professional experience of at least 10 years;
• At least 10 years of practical experience with SAP Business Objects is required;
• At least 8 years of practical experience with SAP Data Services is also Required;
• Excellent knowledge of enterprise data warehouse design and architecture, including dimensional modelling and star/snowflake schema design;
• Excellent knowledge of relational database systems applied to data warehousing;
• Excellent knowledge of SQL and PLSQL;
• Excellent knowledge of BI reporting and analytics tools (e.g., SAP Business Objects, Power BI, Tableau, Qlik) for enterprise dashboards and self-service analytics;
• Excellent knowledge of ETL and ELT tools (e.g., SAP DataServices, Informatica, Talend, dbt, Azure Data Factory) to manage enterprise data pipelines;
• Knowledge of non-relational databases (e.g., MongoDB, Cassandra, Hadoop HBase) for handling unstructured and semi-structured data would be an asset;
• Knowledge of SAP BO universe design and SAP BO admin;
• Knowledge of data lake and lakehouse design patterns (e.g., Delta Lake, Apache Iceberg) to support large-scale analytics would be an asset;
• Knowledge of modelling tools to design data models;
• Knowledge of OLAP technologies and data mining tools;
• Knowledge of cloud BI architectures (e.g., Azure Synapse, Snowflake, AWS Redshift) to enable scalable analytics would be an asset;
• Excellent command of the English language, French will be considered as an asset.