Data Platform Architect (Microsoft Fabric)

Data Platform Architect (Microsoft Fabric)1

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
- Broader Azure ecosystem (ADF, Synapse, ADLS).
- Python / Spark / PySpark advanced use cases.
- ERP/CRM integrations.
- Power BI performance optimization.
- Familiarity with open table formats (Delta Lake, Parquet).
- Awareness of integrating ML workflows with Fabric.

## Success Criteria
- Scalable and well-architected Fabric platform.
- Reliable and efficient data pipelines (batch + real-time).
- High-quality, structured data models with Medallion layering.
- Seamless data integration across enterprise systems.
- AI/ML-ready datasets and workflows.
- Fast and optimized reporting with self-service BI enablement.

Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.