BI DATA ENGINEER

Ayesa Digital; Brussel Hoofdstad; Sur place; EUR 90 000 - 120 000; Plein temps

Avantages offerts par ce poste

Prestigious EU projects

International multicultural team

Continuous expert support

Résumé du poste

Ayesa Digital is seeking a BI Data Engineer to join its international team, contributing to EDW and BI solutions across cloud, on-prem, and hybrid environments.

You will design architectures, model data, build dashboards, ensure data quality, security, and governance, with GDPR compliance and strong collaboration.

Qualifications

• Experience with enterprise data warehouses and dimensional modelling.
• Knowledge of data lakehouse patterns and data contracts.
• Experience securing data and GDPR compliance.
• Ability to translate business requirements into BI solutions.

Responsabilités

• Design BI architectures for cloud, on-premises, and hybrid environments.
• Gather and analyze requirements for pipelines, storage and reporting.
• Develop ETL/ELT and orchestration workflows with CI/CD integration.
• Maintain data models and dashboards delivering insights.
• Govern the semantic layer and data lineage.

Connaissances

Data Modeling

SQL

ETL/ELT

DWH/EDW

Data Governance

Data Observability

Cloud BI

English Proficiency

Formation

Microsoft Azure Data Engineer Associate

Microsoft Data Analyst Associate

Amazon Certified Data Analytics Specialty

Outils

Power BI

Tableau

Qlik

Informatica

Talend

dbt

Azure Data Factory

Delta Lake

Apache Iceberg

Kafka

Debezium

Description du poste

At Ayesa Digital, we grow with you.

Every professional in our company is essential. Thanks to their talent, we continue to expand: today, we are a global team of more than 11,000 people working toward a shared mission.

Ayesa Digital is currently participating in high-impact European Union projects designed to address major European challenges and drive science and innovation. These strategic technological initiatives stand out for their international scope and strong commitment to socially oriented results.

We are looking for a BI Data Engineer to join our international team and contribute to the creation and maintenance of the Enterprise Data Warehouses (EDW) and complex Business Intelligence Solutions (Data Lakes/ Data Lakeshouses).

Key Responsibilities

• Design modern Business Intelligence (BI) architectures (e.g., data lakehouse) 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/Extract, Load, Transform (ETL/ELT) processes and orchestration workflows, incorporating data contracts and schema evolution management.
• Implement and manage data virtualization layers to provide unified access to heterogeneous data sources while optimizing performance and security.
• Design and implement data models (e.g., dimensional modeling) 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 optimize the physical database schema, including indexing, partitioning, and storage strategies, to balance performance, cost, and maintainability.
• Conduct ongoing database performance analysis, tuning queries, optimizing resource utilization, and ensuring SLAs for latency and throughput are met.
• 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.
• Perform deployment and configuration of BI systems and platforms, applying infrastructure-as-code, version control, and environment management practices.
• Govern the BI semantic layer (KPIs, metrics catalog, naming conventions, row-level security) to ensure consistency and trusted insights.
• Manage access controls and data security within BI platforms in alignment with GDPR and internal data protection policies.
• Optimize cost and performance of BI platforms and warehouses (partitioning, caching, clustering, query optimization, resource scaling).
• Define and enforce data lineage and stewardship practices, ensuring transparency, auditability, and compliance.
• Enable self-service BI capabilities for business users through curated datasets, certified reports, and training/support.

What We Are Looking For (Requirements):

• Knowledge of enterprise data warehouse design and architecture, including dimensional modelling and star/snowflake schema design.
• Knowledge of data lake and lakehouse design patterns (e.g., Delta Lake, Apache Iceberg) to support large-scale analytics.
• Excellent knowledge of relational database systems applied to data warehouse.
• Knowledge of non-relational databases (e.g., MongoDB, Cassandra, Hadoop HBase) for handling unstructured and semi-structured data.
• Excellent knowledge of SQL.
• Knowledge of BI reporting and analytics tools (e.g., Power BI, Tableau, Qlik) for enterprise dashboards and self-service analytics.
• Knowledge of ETL and ELT tools (e.g., Informatica, Talend, dbt, Azure Data Factory) to manage enterprise data pipelines.
• Knowledge of modelling tools (e.g., ERwin, SAP PowerDesigner, ArchiMate for data flows) to design logical and physical data models.
• Knowledge of OLAP technologies (e.g., SSAS, Essbase) and data mining tools (e.g., SAS Enterprise Miner, RapidMiner).
• Knowledge of near real-time data ingestion and change data capture (CDC) technologies (e.g., Kafka, Debezium, GoldenGate).
• Knowledge of cloud BI architectures (e.g., Azure Synapse, Snowflake, AWS Redshift) to enable scalable analytics.
• Knowledge of data governance and cataloguing practices (e.g., Collibra, Alation, Azure Purview) to ensure trusted data assets.
• Knowledge of data observability practices (e.g., freshness, lineage, anomaly detection) to monitor and assure pipeline quality.
• Ability to understand, speak and write English, optionally French as an additional asset.

One of the following or an equivalent certification:

• Microsoft Data Analyst Associate.
• Microsoft Azure Data Engineer Associate.
• Amazon Certified Data Analytics Specialty.

What We Offer:

• Prestigious projects within European institutions.
• International, innovative, and multicultural environments.
• Continuous support from a team of experts in EU projects.

If you are ambitious, enthusiastic, and seeking a new professional challenge in international projects with real-world impact, this is the place for you!

In accordance with Organic Law 3/2007 of March 22, the company is committed to promoting the defense and effective application of the principle of equality between men and women, preventing any type of labor discrimination based on sex, and guaranteeing equal entry opportunities. Furthermore, we promote diversity and reject any discrimination based on race, gender, functional diversity, religion, sexual orientation, gender identity, or any other personal or social condition, striving to build an inclusive and enriching environment.