04 sep
|
ALTIA
|
Alicante (Alacant)
04 sep
ALTIA
Alicante (Alacant)
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.
📌 BI Data Engineer (Alicante (Alacant))
🏢 ALTIA
📍 Alicante (Alacant)