Enterprise Architect

• 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.

• 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

Ability to interface effectively with users, technical staff and (senior) management blueprints;

• Languages: Good knowledge of written/spoken English (working language). Knowledge of French is an asset.

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 & STANDARDS:

• Microsoft Certified: Azure Data Engineer Associate (DP-203) - required.

• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) - a plus.

EDUCATION:

A Master's Degree.

If you want to join a dynamic company where technological challenges will be found in your day to day we are waiting for you in the great VASS team.

А global digital transformation company with a team of more than 4,900 global players in 26 countries - in Europe, America and Asia, working together to put organizations at the forefront of innovation by bringing together talent, knowledge and technology., 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.