Solution Architect Microsoft Fabric and Power BI

innovantes IT; Chandigarh; On-site; INR 2,400,000 - 4,200,000; Full time

Job summary

innovantes IT is seeking a senior data and analytics architecture professional to own platform design and client relationships on the technical side as our Fabric and AI offerings grow. You will guide architecture decisions and oversee end-to-end Fabric solutions in collaboration with BI developers.

You will lead discovery workshops, engage with clients through architecture and design sessions, and help migrate BI environments to Fabric while shaping adoption of AI capabilities.

Qualifications

• 9+ years in data and analytics with strong Power BI architecture experience.
• Hands-on experience designing and delivering at least one or two Microsoft Fabric implementations.
• Solid understanding of Fabric components: OneLake, Lakehouse, Warehouse, Data Factory, Direct Lake, and capacity management.
• Experience with data governance, security, and CI/CD practices (deployment pipelines, Git integration).
• Awareness of Copilot in Fabric and Power BI, and AI-ready data/semantic models.
• Strong client-facing skills: confident leading workshops, presenting architectures, and handling stakeholder questions.

Responsibilities

• Lead discovery workshops with clients to understand goals and translate them into Fabric architectures and roadmaps.
• Lead client engagements, including assessments, architecture and design sessions, pilots, and production rollouts.
• Advise clients on migrating and modernizing Power BI, Azure Synapse, and Azure Data Factory environments to Fabric and guide Power BI Premium to Fabric transitions.
• Design end-to-end Fabric solutions covering OneLake, Lakehouse and Warehouse, data pipelines, semantic models, and Power BI.
• Define architecture standards, best practices, and design patterns; produce architecture decision records and technical docs.
• Plan and administer Fabric capacity, sizing, cost estimation, and performance monitoring; implement governance and security controls.
• Mentor developers and stay current with the Fabric roadmap.

Skills

Fabric architecture

Power BI architecture

Client-facing

Architecture design

CI/CD practices

Data governance

Security controls

OneLake

Lakehouse

Power BI Premium

AI readiness

Stakeholder management

Tools

OneLake

Lakehouse

Warehouse

Data Factory

Direct Lake

Job description

About the Role

This is a client-facing architecture role. You will own the platform design and the client relationship on the technical side, while our BI developers handle hands-on build work such as DAX, reports, and pipelines. You'll work closely with clients from first discussion through delivery, and help shape how we grow our Fabric and AI offerings.

Key Responsibilities

Client Engagement & Advisory

• Lead discovery workshops with clients to understand business goals and translate them into Microsoft Fabric architectures and roadmaps.
• Lead a range of client engagements, including assessments, architecture and design sessions, proofs of concept, pilots, optimization engagements, and production rollouts.
• Advise clients on migrating and modernizing existing Power BI, Azure Synapse, and Azure Data Factory environments to Microsoft Fabric.
• Guide clients on Power BI Premium to Fabric transitions.
• Advise clients on AI capabilities in Fabric, such as Copilot and Fabric data agents, and help identify practical use cases with realistic expectations.
• Support pre-sales activities, including solution design, effort estimation, proposals, and client presentations.

Architecture & Design

• Design end-to-end Fabric solutions covering OneLake, Lakehouse and Warehouse, data pipelines, semantic models, and Power BI.
• Make key architecture decisions, including the right storage mode for each scenario (Import, DirectQuery, or Direct Lake) and the right data layering approach.
• Identify risks and dependencies early, and agree practical paths to production with client stakeholders.

Standards, Governance & Capacity

• Define architecture standards, best practices, and design patterns for the delivery team, and review their work for quality.
• Produce clear architecture decision records, technical documentation, and reusable delivery assets that improve consistency across projects.
• Plan and administer Fabric capacity, including sizing, cost estimation, performance monitoring, and optimization.
• Set up governance, security, and access controls, including workspace strategy, row-level security, sensitivity labels, and Microsoft Purview integration.

Team & Practice Growth

• Mentor developers and guide them on design decisions.
• Stay current with the Fabric roadmap and share knowledge with the internal team.

Required Skills and Experience

• 9+ years in data and analytics, with strong Power BI architecture experience (data modeling, semantic model design, performance, and enterprise deployment).
• Hands-on experience designing and delivering at least one or two Microsoft Fabric implementations.
• Solid understanding of Fabric components: OneLake, Lakehouse, Warehouse, Data Factory, Direct Lake, and capacity management.
• Experience with data governance, security, and CI/CD practices (deployment pipelines, Git integration).
• Awareness of Copilot in Fabric and Power BI, and what it takes to make data and semantic models AI-ready.
• Strong client-facing skills: confident leading workshops, presenting architectures, and handling stakeholder questions.
• Ability to review technical work and guide developers.
• Excellent written and verbal communication in English.

Good to Have

• Microsoft certifications such as DP-600, DP-700, PL-300, or Azure Solutions Architect Expert.
• Experience migrating Power BI, Azure Synapse, or Azure Data Factory platforms to Fabric.
• Experience with Azure data services (Azure Data Factory, Synapse, Databricks, Azure AI Foundry).
• Prior experience in a consulting firm or Microsoft partner organization.
• Pre-sales or solutioning experience, including proposals and estimations.