BI Data Engineer

Altia; Alicante; Presencial; EUR 45.000 - 65.000; Jornada completa

Descripción de la vacante

Altia is seeking a BI Data Engineer to join our European team working on international projects. You will design and implement Enterprise Data Warehouses and Data Lakes, leveraging cloud BI architectures to deliver scalable analytics across platforms and teams.

You will collaborate on complex data pipelines, ensuring data quality, governance, and observability. Strong SQL, BI tooling, and cloud data technologies are required, with excellent English communication.

Formación

• Experience in enterprise data warehouse design and architecture.
• Strong knowledge of data lake/lakehouse patterns for analytics.
• Proficient in SQL and relational databases for data warehousing.
• Experience with NoSQL for unstructured data handling.
• Hands-on with BI tools for dashboards and analytics.
• Experience with ETL/ELT tools and data pipelines.
• Familiarity with data governance and cataloguing practices.
• Understanding of data observability concepts and metrics.
• Proficiency in cloud BI architectures for cloud/hybrid setups.
• Fluent English; multilingual ability is a plus.

Responsabilidades

• Create and maintain Enterprise Data Warehouses and data lakes.
• Design BI architectures for cloud, on-prem, and hybrid environments.
• Gather and analyse business requirements for data pipelines and reporting.
• Design and implement ETL/ELT processes and orchestrations.
• Implement data virtualization to unify diverse data sources.

Conocimientos

EDW design

Dimensional modelling

SQL

Data lake/ lakehouse

BI tooling

ETL/ELT

Data governance

Data observability

Cloud BI architectures

English

Herramientas

Delta Lake

Apache Iceberg

Informatica

Talend

dbt

Azure Data Factory

Power BI

Tableau

Qlik

Kafka

Debezium

Snowflake

Azure Synapse

AWS Redshift

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)