Location: VASS BRUXELLES
Role: Enterprise Architect
VASS BeNeLux, in partnership with the European Commission, is currently seeking an Expert Enterprise Architect to work from the European Commission.
Responsibilities
Legacy system analysis: Audit existing on‑premises Oracle schemas, stored procedures, and Snowflake models to identify business logic and data dependencies.
Migration strategy & roadmap: Design a phased transition plan from Oracle to Fabric, ensuring data parity, minimal business downtime, and a clear cut‑over strategy.
Medallion architecture design: Architect the three‑tier (Bronze, Silver, Gold) structure within Microsoft Fabric, ensuring data is optimized for both raw storage and business intelligence.
ETL/ELT orchestration: Design ingestion pipelines using Data Factory and Fabric Notebooks to move data from on‑prem Oracle to OneLake.
Performance optimization: Implement advanced Fabric features such as V-Order, partitioning, and Liquid Clustering to ensure optimal query performance.
Governance & security: Establish data security protocols, access controls (RLS/OLS), and metadata management using governance tools (Microsoft Purview, Microsoft Fabric and third‑party).
Strategic guidance: Contribute to the organizational data strategy, including standards of data quality, the flow of data within the organization, and data security.
Knowledge and Skills
Data analysis: Proven expertise in identifying critical data elements from business processes, key business intelligence products, and data profiling.
Data warehouse design.
Relational vs. distributed mastery: Ability to bridge the gap between traditional RDBMS (Oracle) and distributed data processing (Spark/Delta Lake).
Advanced data modeling: Expert-level knowledge of Kimball methodologies, Star Schemas, Snowflake modeling, Parquet format, handling Slowly Changing Dimensions (SCD) and Change Data Capture ingestion patterns.
Design of data models at varying levels of complexity and detail, from conceptual to logical/physical and from enterprise to solution‑specific.
SQL & programming: Deep proficiency in Oracle PL/SQL for legacy analysis and Spark SQL/Python (PySpark) for modern transformations.
Communication: Ability to explain complex architectural shifts to stakeholders and translate business requirements into technical solutions; interface effectively with users, technical staff and senior management.
Languages: Good knowledge of written/spoken English; knowledge of French is an asset.
Oracle migration: Proven experience migrating large‑scale Oracle workloads (12c/19c) to cloud environments.
Microsoft Fabric stack: Hands‑on experience with OneLake, Lakehouse/Warehouse items, and the import mode in Power BI.
Delta Lake features: Deep understanding of Delta Lake ACID transactions, time travel, and schema evolution.
Data Lakehouse optimization: Specific expertise in optimizing Spark compute clusters and SQL Analytics endpoints for high‑concurrency reporting.
Certifications & Standards
Microsoft Certified: Azure Data Engineer Associate (DP‑203) – required.
Microsoft Certified: Fabric Analytics Engineer Associate (DP‑600) – a plus.
Education
Master’s Degree required.
At VASS we take action every day to achieve a favourable environment that facilitates and promotes equal opportunities, non‑discrimination, diversity and inclusion of all people. We select our talent based on business needs, skills and merits.
#J-18808-Ljbffr