BI Data Engineer

🚀 #WEAREALTIA

ALTIA is a multidisciplinary team focused on delivering advanced data-driven solutions that generate measurable impact and enable smarter decision-making. Working across international environments, we combine analytics, artificial intelligence, and business expertise to transform data into strategic value. Our mission is to help organizations evolve through innovation, scalable data platforms, and high-quality analytical solutions, fostering continuous learning, collaboration, and technological excellence.

We are looking for a Senior BI Data Engineer with extensive, high-level expertise in enterprise data warehousing, Oracle databases, ETL/ELT integration pipelines, and reporting ecosystems to join our team in supporting the evolution, maintenance, and architecture of large-scale European Commission data platforms and enterprise reporting systems (such as eGrants EDW).

The role involves designing, building, and optimizing modern Business Intelligence architectures across cloud, on-premises, and hybrid environments. The specialist will lead the end-to-end design and implementation of complex ETL/ELT data pipelines, dimensional models, and physical schemas (partitioning, indexing, storage strategies). Additionally, the candidate will focus on governing the BI semantic layer, building enterprise dashboards and self-service capabilities, implementing automated data quality/testing frameworks, and ensuring cost and query performance optimization across large-scale data platforms.

In close collaboration with project leads, business analysts, and cross-functional technical teams, the specialist will translate complex business needs into secure, scalable data engineering solutions. The position requires deep hands-on expertise with Oracle (including PL/SQL), SAP Business Objects (universe design and administration), SAS Data Integration, and SAP Data Services, alongside strong alignment with GDPR and data governance standards.

⭐ WHAT WE HAVE FOR YOU?

🚩 Remote work model (far-site delivery with occasional presence in Brussels up to 5 days per quarter).

⏰ Flexible working hours.

📈 Long-term stable position with executive-level professional growth opportunities.

🚀 Continuous learning and upskilling in cutting-edge BI architectures, lakehouse patterns, and cloud analytics.

💪 Integration into an experienced, highly skilled, and collaborative international team.

💣 Participation in high-impact international digital and ICT projects.

💙 Inclusive and innovation-driven work environment.

REQUIREMENTS:

Educational level & Experience:

• EQF Level 7 (Master's degree or 5 years of higher education).
• Minimum 15 years of professional IT experience.
• Minimum 12 years of hands-on Oracle experience applied to enterprise data warehouse environments.
• Minimum 8 years of practical experience with SAP Business Objects (including universe design and administration).
• Minimum 5 years of practical experience with SAS 9.4 Data Integration.
• Minimum 3 years of practical experience with SAP Data Services.
• Proven track record supported by concrete examples of projects, deliverables, and measurable results clearly detailed in the CV.

Languages:

• Minimum B2 level in English or French (spoken and written).

TECHNICAL & FUNCTIONAL EXPERIENCE:

• Data Warehousing & Architecture: Enterprise Data Warehousing (EDW) design, dimensional modeling (star/snowflake schemas), data lakehouses, physical database schema optimization, indexing, partitioning, and storage/cost management.
• Databases & Querying: Advanced SQL and PL/SQL development within large-scale Oracle environments.
• ETL/ELT & Orchestration: Data integration workflow design, schema evolution, data contracts, and ETL execution using SAS 9.4 Data Integration, SAP Data Services, and modern pipeline engines.
• Reporting & Semantic Layer: SAP Business Objects universe design and admin, Power BI, Tableau, Qlik, metrics catalog governance, row-level security, and self-service BI enablement.
• Data Quality & Governance: Data quality frameworks, health monitoring, automated pipeline testing (CI/CD integration), data lineage, runbooks, GDPR compliance, and access security.

TECHNOLOGIES & SKILLS:

• Databases: Oracle, PL/SQL, relational EDW.
• BI & Reporting: SAP Business Objects (Universe Design & Admin), Power BI, Tableau, Qlik.
• ETL & Integration: SAS 9.4 Data Integration, SAP Data Services, Informatica, DataStage, Talend, dbt, Azure Data Factory.
• Modeling & Design: Logical and physical data modeling.
• Soft Skills: High rigor in BI development practices, strong communication skills in multicultural/multilingual environments, results-oriented mindset, and ability to work autonomously and in teams.

NICE TO HAVE:

• Experience with Enterprise Architect for logical and physical data modeling.
• Knowledge of Data Lake / Lakehouse design patterns (e.g., Delta Lake, Apache Iceberg).
• Familiarity with cloud BI/DW architectures (e.g., Azure Synapse, Snowflake, AWS Redshift).

This job offer has been drafted taking into account impartiality and non-discrimination based on gender, race, ideology, or any other reason, in accordance with applicable equality regulations.