BI Data Engineer – ETL / Data Warehouse / Lakehouse

For one of our clients, we are looking for a BI Data Engineer who will be responsible for designing and developing ETL/ELT processes, data warehouses, Data Lakehouse architecture, and BI solutions. This is a role combining Data Engineering, Business Intelligence, Data Warehousing, and Data Governance. You will work on both the data layer and pipelines, as well as reporting solutions, data quality, lineage, and security. Data Governance & Security - As part of the role, you will also be responsible for: managing the BI semantic layer – KPIs, metrics catalog, naming conventions, row-level security, managing access and data security in accordance with GDPR and internal data protection policies, enforcing data lineage and data stewardship principles, maintaining technical documentation, including data dictionaries, lineage, design specifications, and runbooks.

Daily tasks

• managing the BI semantic layer – KPIs, metrics catalog, naming conventions, row-level security,
• managing access and data security in accordance with GDPR and internal data protection policies,
• enforcing data lineage and data stewardship principles,
• maintaining technical documentation, including data dictionaries, lineage, design specifications, and runbooks.
• Designing and implementing end-to-end ETL/ELT processes and orchestration workflows.
• Implementing data contracts and managing data schema evolution.
• Designing and maintaining Enterprise Data Warehouses, Data Lakes, and Data Lakehouses.
• Building and developing Business Intelligence solutions.
• Implementing data quality mechanisms and data health monitoring.
• Working with data observability, including data lineage and freshness, and defining and monitoring SLA/SLO.
• Optimizing costs and performance of BI platforms and data warehouses through, among others: partitioning, caching, clustering, query optimisation, resource scaling.
• Gathering and analyzing business requirements regarding pipelines, storage, and reporting.
• Supporting self-service BI by preparing curated datasets, certified reports, and providing user support and training.
• Designing modern BI architectures for cloud, on-premises, and hybrid environments.
• Implementing data virtualisation layers, providing unified access to heterogeneous data sources.
• Designing and developing reporting and analytical applications – dashboards, KPIs, and self-service BI tools.
• Designing data models, including dimensional models, according to business requirements.
• Designing and optimizing physical database schemas through indexing, partitioning, and appropriate storage strategies.
• Performance analysis, query tuning, and resource optimization, in accordance with the direction set by the Technical/Solution Architect.
• Designing and performing tests for BI solutions, including: data validation, regression testing, contract testing, automated pipelines.

Requirements

Education: Master's degree + min. 5 years of professional experience, or Bachelor's degree + min. 7 years of experience, or secondary education + min. 12 years of experience. Practical experience in designing and implementing ETL/ELT processes. Experience in dimensional modelling and data warehouse design. Experience with Data Lakehouse architecture. Experience in the area of data governance and data lineage. Knowledge of GDPR requirements in the context of data platforms and reporting. Very good knowledge of English – min. B2. Ability to work with both technical teams and business stakeholders. Analytical, organized, and detail-oriented approach to work. Nice to have Microsoft Data Analyst Associate Azure Data Engineer Associate Amazon Certified Data Analytics – Specialty

Must have: Degree, ETL, Data Lake, GDPR

Nice to have: Data analytics