Senior Data Architect- Delta Lakehouse

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.