AI Summary
Design and maintain enterprise data warehouses, data lakes, and BI architectures for an EU Institution in Brussels. Deliver ETL/ELT pipelines, data models, dashboards, and data governance while ensuring GDPR compliance and performance. Requires excellent SQL, data warehouse design, cloud BI experience, and English C1; hybrid work in Brussels.
Key Highlights
Hybrid contract based in Brussels, Belgium, supporting European Union institutions
Focus on enterprise data warehousing, lakehouse architectures, ETL/ELT, and self-service BI
Strong emphasis on data governance, GDPR, data quality, and SLAs/SLOs
Requires C1 English and deep expertise in SQL and BI platforms
Key Responsibilities
Create and maintain Enterprise Data Warehouses (EDW) and complex Business Intelligence Solutions (Data Lakes / Data Lakehouses).
Design modern BI architectures for cloud, on-premises, and hybrid environments, ensuring compliance with security and data residency requirements.
Gather and analyse business requirements for data pipelines, storage, and reporting solutions.
Design and implement modern 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.
Design and optimize the physical database schema, including indexing, partitioning, and storage strategies.
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 with data observability and defined 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).
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 through partitioning, caching, clustering, query optimization, and 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.
Technical Skills Required
Benefits & Perks
Mind-blowing workplace culture with a professional, dynamic and collaborative team
Flexibility to work remotely and hybrid arrangement
International career opportunities and professional growth across Portugal, Belgium, Luxembourg, Denmark and beyond
Health and Life Insurance
Tech Visa assistance for candidates outside the European Union
Nice to Have
Microsoft Data Analyst Associate
Microsoft Azure Data Engineer Associate
Amazon Certified Data Analytics Specialty
Job Description
Do you live in Portugal and would like to work for European institutions in Brussels? Then this opportinuty is for you!
We are hiring a BI Data Engineer for the EU Institution in Brussels, Belgium:
Nature of the tasks
- Create and maintain Enterprise Data Warehouses (EDW) and complex Business Intelligence Solutions (Data Lakes / Data Lakehouses).
- 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.
Searching for Data Science roles that provide visa sponsorship? Connect with international employers through Data Science Jobs with Visa Sponsorship opportunities actively seeking talented professionals.
- 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.
- Optional: One of the following or an equivalent certification:
Explore our comprehensive directory of visa sponsorship jobs from employers worldwide who are ready to sponsor talented international professionals.
Microsoft Azure Data Engineer Associate,
Amazon Certified Data Analytics Specialty.
Languages
English level C1
Location
Brussels, Belgium
Work mode
Hybrid (on-site at Brussels offices + remote)
What can you expect from us?
Mind-blowing workplace culture. You will be integrated in a professional, dynamic and collaborative team.
100% Remote opportunities
We want you to have the flexibility to work where you feel most comfortable and productive.
International Career
- You can expect professional growth and to be connect with the world.
- We are represented in Portugal, Belgium, Luxembourg, and Denmark.
- And with projects in many other countries: Netherlands, Luxembourg, Singapore and in the United States of America (and a lot more is coming…)
If you wish to work with us and you are outside European Union (good news…) we are a Tech Visa Company, We will help!
As a plus, we provide Health and Life Insurance.
Similar Jobs
Explore other opportunities that match your interests
Visa Sponsorship
Relocation
Remote
Job Type
Full-time
Experience Level
Mid-Senior level
Nameless Ventures
United Arab Emirates
Principal Data Analyst
••••••
••••••
••••••
Job Type
••••••
Experience Level
••••••
Capital One
United State
Visa Sponsorship
Relocation
Remote
Job Type
Full-time
Experience Level
Entry level
ATC
United State