Microsoft Fabric Data Engineer - Data Modeling

Job Description : Microsoft Fabric Data Engineer

Key Skills : Data Modelling, Microsoft Fabric Notebook, Fabric Pipeline, Lakehouse, Warehouse, OneLake

Role Overview :

We are looking for a skilled Microsoft Fabric Data Engineer with strong expertise in data modelling and hands-on experience with Microsoft Fabric. The ideal candidate will be responsible for designing scalable data models, developing data pipelines, and building efficient Lakehouse and Warehouse solutions to support enterprise analytics and reporting.

Key Responsibilities :

- Design, develop, and maintain robust data models for analytical and reporting requirements.

- Build and optimize data processing solutions using Microsoft Fabric Notebooks.

- Develop, orchestrate, monitor, and troubleshoot Microsoft Fabric Data Pipelines.

- Design and implement Lakehouse solutions for structured and semi-structured data processing.

- Develop and maintain Fabric Warehouse solutions for analytical workloads.

- Apply OneLake concepts, including unified data storage, data organization, and data access across the Microsoft Fabric ecosystem.

- Optimize data ingestion, transformation, query performance, and storage efficiency.

- Implement data quality checks, validation rules, and data consistency measures.

- Collaborate with data analysts, BI developers, architects, and business stakeholders to translate requirements into scalable data solutions.

- Follow best practices for data security, governance, performance, and maintainability.

Mandatory Skills :

- Data Modelling : Strong knowledge of conceptual, logical, and physical data modelling; dimensional modelling; star and snowflake schemas; facts and dimensions; and slowly changing dimensions (SCD).

- Microsoft Fabric Notebook : Hands-on experience developing data transformation and processing solutions using notebooks, preferably with PySpark and SQL.

- Fabric Pipeline : Experience building and managing data ingestion, orchestration, scheduling, and dependency workflows.

- Lakehouse : Understanding of Lakehouse architecture, Delta tables, data ingestion, and transformation patterns.

- Warehouse : Experience designing analytical warehouse structures and implementing efficient SQL-based data solutions.

- OneLake Concepts : Understanding of OneLake architecture, data organization, shortcuts, and data sharing across Fabric workloads.

Preferred Skills :

- Experience with SQL and Python/PySpark.

- Familiarity with medallion architecture (Bronze, Silver, Gold).

- Understanding of ETL/ELT design patterns and incremental data loading.

- Knowledge of data governance, security, and performance optimization.

- Exposure to Power BI and enterprise analytics environments.

Experience and Qualifications :

- Relevant hands-on experience in data engineering and Microsoft Fabric.

- Strong practical experience in data modelling and analytical data architecture.

- Experience delivering production-ready data solutions in a cloud-based environment.

- Microsoft Fabric or relevant Azure data certifications are an advantage.

Success Criteria :

- Deliver scalable and maintainable data models.

- Build reliable and efficient Fabric pipelines and notebooks.

- Implement effective Lakehouse and Warehouse solutions.

- Apply OneLake capabilities to support unified data access and reuse.

- Ensure data quality, performance, and reliability across data workflows.

Skills

Data Engineering, Microsoft Fabric, PySpark, SQL, Python, ETL, DataLake, Data Warehousing, Data Modeling