BI Data Engineer

Altia; Alicante; Presencial; EUR 60.000 - 90.000; Jornada completa

Descripción de la vacante

Altia, a European IT consultancy, is seeking a BI Data Engineer to join our European team, focusing on data warehouses, data lakes, and cloud analytics for major projects.

You will design and implement EDWs and data lakehouse architectures, and data pipelines, collaborating with multi-cultural teams on international projects. Strong SQL and ETL/ELT, plus BI tool experience (Power BI, Tableau, Qlik), are required, with fluency in English.

Formación

• Knowledge of EDW design, dimensional modelling, and star/snowflake schemas.
• Experience with data lake/lakehouse patterns (Delta Lake, Apache Iceberg).
• Strong relational database skills for data warehousing.
• Knowledge of non-relational databases (MongoDB, Cassandra, Hadoop HBase).
• Proficiency in SQL.
• Experience with BI tools (Power BI, Tableau, Qlik).
• ETL/ELT tools experience (Informatica, Talend, dbt, Azure Data Factory).
• Modeling tools (ERwin, SAP PowerDesigner, ArchiMate).
• OLAP tech (SSAS, Essbase) and data mining tools (SAS Enterprise Miner, RapidMiner).
• CDC and near real-time ingestion (Kafka, Debezium, GoldenGate).
• Cloud BI architectures (Azure Synapse, Snowflake, AWS Redshift).
• Data governance/catalogs (Collibra, Alation, Azure Purview).
• Data observability (data freshness, lineage, anomaly detection).

Responsabilidades

• Create and maintain EDWs and Data Lakes/Data Lakehouses.
• Design modern BI architectures for cloud, on-premises, and hybrid environments with security compliance.
• Gather and analyse business requirements for data pipelines, storage, and reporting solutions.
• Design and implement modern ETL/ELT processes and orchestration with schema evolution.
• Implement data virtualization layers for unified access while optimizing performance and security.

Conocimientos

High level of English

Herramientas

Power BI

Tableau

Qlik

Informatica

Talend

dbt

Azure Data Factory

ERwin

SAP PowerDesigner

ArchiMate

SSAS

Essbase

Kafka

Debezium

GoldenGate

Azure Synapse

Snowflake

AWS Redshift

Collibra

Alation

Azure Purview

Delta Lake

Apache Iceberg

MongoDB

Cassandra

Hadoop HBase

SQL

Descripción del empleo

Do you want to start a new professional challenge? Check out our new opportunity!

We are looking to incorporate a BI Data Engineer to our team.

About us

We are an IT Consultant Group that provides services and creates digital solutions to improve the lives of citizens across Europe. Check out our website: www.altia.es/en

Our project and team

This is your opportunity to start working on international projects with a highly qualified team and applying the latest technologies.

You will join our European team, specifically the one involved in several projects for a significant European Agency.

Minimum Requirements

Required Knowledge

• 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.
• High level of English

Main Responsibilities

• 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

Skills:

• Ability to apply rigour and consistency in BI development practices.
• Ability to work in multi-cultural environment.
• Ability to participate in multilingual meetings.
• Ability to understand, speak and write English, optionally French as an additional asset.

This job offer has been drafted with impartiality and non-discrimination on the basis of gender, race, ideology or any other grounds in mind. In particular, it complies with current regulations on gender equality between women and men (Royal Decree-Law 6/2019)