We are looking for a Data Architect to design and execute our transition from an on-premises Oracle Data Warehouse to a modern Microsoft Fabric environment. The Data Architect will be the technical authority responsible for 1) understanding AS-IS and TO-BE data landscape of the organization, build and evolve the enterprise conceptual and logical data models and 2) translating legacy PL/SQL logic and relational schemas into a high-performance Delta Lake Medallion Architecture. DESCRIPTION OF TASKS 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 3rd party). Strategic guidance : Contribute to the organizational data strategy, including standards of data quality, the flow of data within the organization, and security of data. 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 pattern. Proven expertise in designing data models of different levels of complexity and detail: from conceptual data model down to logical and physical data model, from enterprise data models to solution-specific data models 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 blueprints; Ability to interface effectively with users, technical staff and (senior) management Languages : Good knowledge of written/spoken English (working language). Knowledge of French is an asset 3. SPECIFIC EXPERTISE 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 Microsoft Certified: Azure Data Engineer Associate (DP-203) – required.