Find The RightJob.

Data Platform Architect (Microsoft Fabric)

Data Platform Architect (Microsoft Fabric)

**Experience: 10+ years overall, with 2–3 years hands-on experience in Microsoft Fabric (project experience required)
**Role Type: Contractor
**Location: Pune

## Role Overview
We are looking for an experienced Data Platform Architect to design and implement a scalable, end-to-end data platform using **Microsoft Fabric**. The role spans architecture, data engineering, modelling, analytics enablement, and integration with advanced data practices such as Medallion Architecture and AI/ML readiness.

## Key Responsibilities
### 1) Architecture & Design

Define end-to-end architecture for a unified data platform using Microsoft Fabric.
Design scalable, secure, and high-performance solutions.
Establish integration strategies across enterprise systems (ERP, CRM, SaaS).
Enforce data governance, security, and compliance standards.
Implement Medallion Architecture (Bronze, Silver, Gold layers) for structured data transformation and quality.

### 2) Data Engineering & Integration

Build data pipelines using Data Factory and Dataflow Gen2.
Develop ETL/ELT processes (incremental and full loads).
Integrate and transform data into Lakehouse/Data Warehouse.
Architect pipelines supporting both batch and real-time processing.
Apply DataOps practices and CI/CD for pipeline automation.

### 3) Data Modelling

Design star and snowflake schemas.
Define data standards, naming conventions, and best practices.
Ensure data quality, consistency, and integrity.
Apply dimensional (Kimball) and Lakehouse modelling techniques.

### 4) Analytics & Semantic Layer

Develop semantic models (Power BI datasets).
Optimize models for reporting and analytics.
Support basic reporting and visualization needs.
Enable self-service BI through well-structured semantic layers.

### 5) Performance Optimization

Tune pipelines, storage, and query performance.
Apply partitioning, indexing, and cost optimization strategies.
Handle large-scale datasets (billions of records) efficiently.

### 6) Collaboration & Leadership

Translate business requirements into technical solutions.
Guide data engineers and BI developers.
Align architecture, engineering, and analytics teams.
Mentor teams and enforce best practices, coding standards, and design patterns.

### 7) Advanced Capabilities

Establish metadata management, lineage tracking, and cataloging frameworks.
Provide architectural guidance for AI/ML integration (feature stores, model pipelines).
Ensure compliance with regulatory standards (GDPR, HIPAA, etc.).

## Required Skills

10+ years in data/solution architecture.
2–3 years of hands-on Microsoft Fabric experience (must have delivered Fabric projects).
Expertise in Lakehouse, Data Warehouse, Data Factory, Dataflow Gen2.
Strong SQL and ETL/ELT development skills.
Data modelling expertise (star/snowflake schemas, Data Vault, Medallion).
Experience with large-scale data and performance tuning.
Knowledge of Power BI (datasets, relationships, basic reporting).
Understanding of data governance, security, and quality.
Strong knowledge of Spark/PySpark for distributed data processing.
Experience with CI/CD and DataOps in data engineering.

## Good to Have