BI Data Engineer Consultant | EU Institutions

Ayesa Digital; Brussel Hoofdstad; Hybrid; EUR 75,000 - 95,000; Full time

Benefits offered by this job

Prestigious projects

Multicultural environment

Team of experts

Job summary

Ayesa Digital is seeking a BI Data Engineer to join its international data team, supporting a leading European institution in digital transformation. You will design, build, and maintain modern data platforms, EDW, Data Lake, and BI solutions to enable data-driven decision making.

You'll work with Azure services, Python, SQL, and Power BI to deliver scalable pipelines, dashboards, and data models. The role requires strong English communication and EU security clearance eligibility, in a

Qualifications

• Degree in Computer Science, Information Technology, Engineering, Data Science, or a related field.
• At least 5 years of professional experience with Python for data engineering.
• At least 2 years of experience with SQL and relational database technologies.
• At least 2 years with Azure Synapse Analytics and Azure Data Factory.
• Proficiency in Microsoft Power BI and BI solutions.
• Strong knowledge of Azure data services and data warehouse concepts.

Responsibilities

• Design, develop, and maintain ETL/ELT processes on Azure and Python.
• Build and optimize EDW, Data Lake, and Lakehouse for analytics.
• Translate business requirements into scalable technical solutions.
• Create data models including star and snowflake schemas.
• Develop Power BI reports, semantic models, KPIs, and self-service analytics.
• Collaborate with cross-functional teams in an agile environment.

Skills

Python for data engineering

SQL

Azure Synapse Analytics

Azure Data Factory

Power BI

Data warehouse design

Data modelling

Git & DevOps

Agile delivery

English communication

Education

Bachelor's degree in CS/IT/Engineering

Tools

Git

Azure DevOps

Power Query

DAX

Azure Synapse

Job description

Every professional in our company is vital to us. Thanks to their talent, we continue to expand; today, we are a global team of over 11,000 people working toward a common goal.

We are looking for a BI Data Engineer to join a dynamic data team supporting a leading European institution in its digital transformation journey. The successful candidate will contribute to the design, development, and maintenance of modern data platforms, data warehouses, and Business Intelligence solutions that support analytical reporting and decision-making across complex environmental and climate-related domains.

Working within an international and multicultural environment, you will play a key role in building scalable data pipelines, optimizing data architectures, enhancing reporting capabilities, and enabling data-driven insights through Microsoft Azure and Power BI technologies.

What you'll do

• Design, develop, and maintain scalable ETL/ELT processes and data orchestration workflows using Microsoft Azure services, Python, and SQL.
• Build and enhance Enterprise Data Warehouse (EDW), Data Lake, and Lakehouse solutions to support advanced analytics and reporting.
• Gather and analyze business requirements, transforming functional needs into robust technical solutions.
• Design conceptual, logical, and physical data models, including dimensional models and star/snowflake schemas.
• Develop and maintain Business Intelligence solutions using Microsoft Power BI, including dashboards, semantic models, KPIs, and self-service reporting capabilities.
• Optimize database performance through query tuning, indexing, partitioning, and storage optimization strategies.
• Implement data quality, monitoring, and observability frameworks to ensure trusted and reliable data assets.
• Define and execute testing activities, including data validation, regression testing, and CI/CD-integrated pipeline testing.
• Produce and maintain technical documentation, including data dictionaries, lineage documentation, design specifications, and operational runbooks.
• Support deployments, configuration management, and version control processes using Git and Azure DevOps.
• Perform ad hoc data analysis and reporting activities on complex datasets.
• Collaborate with technical teams, stakeholders, and external partners in an agile delivery environment.
• Contribute to continuous improvement initiatives and the adoption of innovative data and AI-driven capabilities.

What we're looking for

• Degree in Computer Science, Information Technology, Engineering, Data Science, or a related field.
• At least 5 years of professional experience with Python for data engineering and data processing.
• At least 2 years of experience working with SQL and relational database technologies.
• At least 2 years of hands-on experience with Azure Synapse Analytics and Azure Data Factory.
• At least 2 years of experience with Microsoft Power BI and Business Intelligence solutions.
• At least 2 years of experience in data engineering, data management, analytics, and ETL/ELT development.
• Strong knowledge of Azure cloud data services, including Azure Synapse, Azure Data Factory, Azure Data Lake Storage Gen2, and Microsoft Fabric.
• Solid understanding of data warehouse architecture, dimensional modelling, and modern data platform concepts.
• Experience with Power Query, DAX, semantic models, and self-service BI environments.
• Knowledge of modern Data Lake/Lakehouse architectures and data quality best practices.
• Experience with Git, Azure DevOps, and Agile delivery methodologies.
• Strong analytical and problem-solving skills with a high level of attention to detail.
• Ability to work effectively both independently and within multicultural and multidisciplinary teams.
• Excellent communication skills in English (minimum B2 level).
• EU security clearance eligibility is required.
• Microsoft Azure Data Engineer, Power BI Data Analyst, Fabric Analytics Engineer, or equivalent certifications will be considered an asset.

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.