Lead Microsoft Fabric & Power BI Architect

Ravh-IT; India; Remote; INR 600,000 - 1,000,000; Full time

Job summary

Ravh-IT is seeking a Lead Microsoft Fabric & Power BI Architect to design, implement, and modernize enterprise-scale analytics, data, and reporting platforms. The role focuses on Microsoft Fabric, Power BI, Azure services, and comprehensive BI modernization.

The candidate will lead architecture, governance, and hands-on implementation across Fabric Lakehouse, OneLake, and large-scale data ecosystems with enterprise stakeholders.

Qualifications

• Extensive experience architecting enterprise BI using Microsoft Fabric and Power BI.
• Hands-on with Azure Synapse, Azure SQL, Data Factory and ETL/ELT architectures.
• Experience migrating legacy BI tools (Tableau, OBIEE, SSRS) to modern Fabric/Power BI.

Responsibilities

• Design and architect enterprise BI solutions with Microsoft Fabric, Power BI, Azure Synapse, Azure SQL and Azure Data Factory.
• Develop scalable semantic models, enterprise reporting frameworks and dashboards.
• Lead migration and modernization of legacy BI platforms to Fabric/Power BI.
• Design enterprise Star and Snowflake schemas for analytics.
• Define architecture standards and reusable BI capabilities.

Skills

Microsoft Fabric

Power BI

Fabric OneLake & Lakehouse

SSIS / SSRS

SQL / DAX / MDX

Star Schema

Snowflake Schema

Power BI Governance

Security

Performance Optimization

Tableau

OBIEE

Tools

Tableau

OBIEE

Job description

Lead Microsoft Fabric & Power BI Architect

Work Location: Remote

Shift: Night Shift — 09:00 PM to 01:00 AM IST

Employment Type: Contract / Full-Time

Job Summary

We are seeking an experienced Lead Microsoft Fabric & Power BI Architect to design, implement, and modernize enterprise-scale analytics, data, and reporting platforms. The ideal candidate will have strong expertise in Microsoft Fabric, Power BI, Azure Data Services, ETL/ELT architecture, data modeling, and enterprise BI modernization.

The candidate will lead the architecture and transformation of legacy BI environments into scalable, secure, and high-performance Microsoft Fabric and Power BI solutions. This role requires strong technical leadership, solution architecture, stakeholder management, and hands‑on experience with enterprise data platforms.

Key Responsibilities

• Design and architect enterprise BI and analytics solutions using Microsoft Fabric, Power BI, Azure Synapse, Azure SQL, and Azure Data Factory.
• Develop scalable semantic models, enterprise reporting frameworks, dashboards, and governed analytics platforms.
• Lead migration and modernization of legacy BI platforms including Tableau, OBIEE, SSRS, and on‑premises reporting environments.
• Design enterprise Star Schema and Snowflake Schema data models.
• Define architecture standards, best practices, and reusable BI capabilities.

Microsoft Fabric & Data Engineering

• Architect Microsoft Fabric Lakehouse and OneLake solutions using Medallion Architecture (Bronze, Silver, and Gold).
• Design and optimize ETL/ELT pipelines using Fabric Data Factory, Azure Data Factory, SSIS, and Azure Synapse.
• Develop scalable data ingestion frameworks for large AMS/CRM and operational databases.
• Implement incremental data loading using CDC, watermarking, partition‑based extraction, and parallel processing.
• Design workload isolation strategies using staging databases, read replicas, and scheduled extraction windows.
• Optimize data pipelines, semantic models, DAX, tabular models, and Power BI reports for enterprise‑scale workloads.

Governance, Security & Performance

• Establish enterprise Power BI governance, security, and administration standards.
• Implement Row‑Level Security (RLS), Role‑Based Access Control (RBAC), and secure data access frameworks.
• Configure and manage Power BI Enterprise Gateways and hybrid cloud integrations.
• Implement monitoring, auditing, error handling, retry mechanisms, and operational support processes.
• Ensure analytics platforms meet requirements for performance, scalability, availability, security, and compliance.

Leadership & Stakeholder Management

• Lead and mentor BI developers, data engineers, and analytics consultants.
• Partner with business stakeholders, DBAs, enterprise architects, and leadership teams to define analytics roadmaps.
• Conduct technical workshops, architecture reviews, solution presentations, and design sessions.
• Provide technical guidance, estimation, planning, and governance throughout project delivery.
• Support Agile delivery and drive continuous improvement across BI and analytics initiatives.

Required Skills

• Microsoft Fabric
• Power BI
• Fabric OneLake & Lakehouse
• SSIS / SSRS
• SQL / DAX / MDX
• Star & Snowflake Schema
• Power BI Governance & Security
• Performance Optimization
• Data Governance
• Experience with Tableau / OBIEE migration and modernization

Preferred Qualifications

• Microsoft Certified: Fabric Data Engineer Associate (DP-600)
• Experience in Banking, Financial Services, Healthcare, or other enterprise environments
• Experience supporting enterprise BI platforms with thousands of users
• Strong communication, leadership, problem‑solving, and stakeholder management skills

Work Schedule

Remote Position | Night Shift: 09:00 PM – 01:00 AM IST

Candidates must be comfortable working during the specified night‑shift hours and collaborating with distributed/global teams.