BI Data Engineer

OneSource Consulting; Brussel; Hybride; EUR 60 000 - 90 000; Plein temps

Résumé du poste

OneSource Consulting is seeking a BI Data Engineer to design and maintain EDW, Data Lakes, and Lakehouse architectures across cloud, on-premises, and hybrid environments. You will build ETL/ELT pipelines, develop scalable data models, and create dashboards delivering actionable insights to business stakeholders.

Responsibilities include optimizing queries, ensuring data quality and governance, and enabling business users with certified datasets. Strong English required; French is a plus.

Qualifications

• University degree or equivalent professional experience.
• Strong knowledge of EDW design and dimensional modelling (star/snowflake).
• Experience with Data Lake and Lakehouse architectures.
• Excellent SQL and relational databases; NoSQL familiarity.
• Experience with BI, reporting, analytics, ETL/ELT and data pipelines (Power BI, Tableau, Qlik, dbt, Informatica, Talend, ADF).
• Knowledge of data modelling, OLAP, data integration, real-time ingestion, and CDC.
• Experience with cloud data/BI platforms; data governance, lineage, cataloguing and observability.
• Excellent English communication; French a plus.
• Certifications (Microsoft/Data Analyst, Azure Data Engineer, AWS Data Analytics) are a strong plus.

Responsabilités

• Design, develop, and maintain EDW, Data Lakes, and Data Lakehouse solutions across cloud, on-premises, and hybrid environments.
• Build and optimize ETL/ELT pipelines and data orchestration workflows.
• Design scalable data models and BI architectures for reporting and analytics.
• Develop dashboards and KPIs delivering actionable insights to stakeholders.
• Optimize database performance via tuning, indexing, partitioning, caching.
• Implement data quality, observability, lineage, and governance with GDPR/security in mind.
• Define and execute testing strategies; automate deployments via CI/CD and IaC.
• Produce and maintain technical docs and enable business users with curated datasets.

Connaissances

EDW design

Dimensional modelling

Data Lake/Lakehouse

SQL

Relational databases

NoSQL

BI/Analytics

ETL/ELT

Data pipelines

Power BI

Tableau

Qlik

dbt

Informatica

Talend

Azure Data Factory

Data governance

Data lineage

Data observability

Cloud BI platforms

Data modelling

OLAP

CDC

English communication

French language

Certifications (MS/Azure/AWS)

Formation

University degree in Computer Science/IT/Data Science/AI or related field

Outils

Power BI

Tableau

Qlik

dbt

Informatica

Talend

Azure Data Factory

Description du poste

MODE OF WORK: FULL TIME (HYBRID AND 3 DAYS ONSITE PER WEEK)

CONTRACT DURATION: UPTO 1 YEAR+POSSIBLE OF EXTENSION

JOB DESCRIPTION:

We are looking for BI Data Engineer with ETL, Data Engineer and PowerBI

Roles and Responsibilities:

• Design, develop, and maintain Enterprise Data Warehouses (EDW), Data Lakes, and Data Lakehouse solutions across cloud, on-premises, and hybrid environments.
• Build and optimize ETL/ELT pipelines, orchestration workflows, and data virtualization solutions to integrate and manage diverse data sources.
• Design scalable data models and modern BI architectures that support reporting, analytics, and business requirements.
• Develop dashboards, KPIs, and self-service BI solutions that provide actionable insights to business stakeholders.
• Optimize database and platform performance through query tuning, indexing, partitioning, caching, and resource scaling.
• Implement data quality, observability, lineage, and governance practices while ensuring compliance with GDPR and security standards.
• Define and execute testing strategies, automate deployments through CI/CD, and manage BI platform configurations using infrastructure-as-code.
• Produce and maintain technical documentation, support data stewardship initiatives, and enable business users through certified datasets and training.

REQUIRED SKILLS:

• University degree in Computer Science, Information Technology, Data Science, Artificial Intelligence, or a related field, or equivalent professional experience.
• Strong knowledge of Enterprise Data Warehouse (EDW) design and architecture, including dimensional modelling and star/snowflake schemas.
• Experience with Data Lake and Data Lakehouse architectures and scalable analytics platforms.
• Excellent knowledge of SQL and relational databases, with familiarity with NoSQL databases.
• Experience with BI, reporting, analytics, ETL/ELT, and data pipeline technologies, such as Power BI, Tableau, Qlik, dbt, Informatica, Talend, or Azure Data Factory.
• Knowledge of data modelling, OLAP, data integration, near-real-time ingestion, and Change Data Capture (CDC) technologies.
• Experience with cloud data and BI platforms, together with knowledge of data governance, data lineage, cataloguing, and data observability.
• Excellent English communication skills; knowledge of French is a plus.
• Certification is a strong plus: Microsoft Data Analyst Associate, Microsoft Azure Data Engineer Associate, Amazon Certified Data Analytics Specialty, or an equivalent certification.