Power BI & Microsoft Fabric Consultant - Contract Position

Airveda Technologies Pvt Ltd.; Bengaluru; On-site; INR 1,000,000 - 1,300,000; Full time

Job summary

Airveda Technologies Pvt Ltd. is seeking a Power BI & Microsoft Fabric Consultant to enhance our BI team’s capabilities. This hands-on role focuses on training, establishing governance frameworks, and ensuring the platform's independence post-engagement.

The ideal candidate should have over 5 years of experience in Power BI development, strong expertise in Microsoft Fabric, and a proven record in mentoring teams.

Qualifications

• 5+ years of experience in Power BI development and administration.
• Hands-on experience with Microsoft Fabric (end-to-end).
• Experience setting up enterprise BI governance frameworks.

Responsibilities

• Conduct training sessions and workshops on Power BI and Microsoft Fabric.
• Design and implement governance models for Power BI & Fabric.
• Configure and optimize Power BI tenant settings and Fabric capacity.
• Document development standards and best practices.

Skills

Power BI development and administration

Microsoft Fabric experience

Power BI governance

Security models (RLS, RBAC)

Training and mentoring teams

Enterprise BI governance frameworks

Tools

Snowflake

Azure

Job description

Role Overview

We are seeking an experienced Power BI & Microsoft Fabric Consultant to partner with our BI team for a short-term engagement focused on capability building, governance setup, and platform enablement.

The primary objective of this role is to upskill the team and establish a robust, scalable foundation for Power BI and Microsoft Fabric—covering security, governance, administration, and best practices—so that the team can independently manage and scale the platform post-engagement.

This is a hands‑on + coaching role, not just advisory.

Key Responsibilities

1. Power BI & Fabric Enablement

• Conduct structured training sessions and workshops on:
• Power BI (Pro + Fabric-integrated experiences)
• Microsoft Fabric (Lakehouse, Warehouse, Dataflows Gen2, Pipelines, etc.)
• Build foundational understanding of:
• End‑to‑end analytics workflows in Fabric
• Integration between Power BI and Fabric workloads
• Data Lake will be Snowflake

2. Governance & Security Framework

• Design and implement Power BI & Fabric governance model, including:
• Workspace strategy (Dev/Test/Prod separation)
• Naming conventions and standards
• Content lifecycle management
• Establish security architecture:
• Role‑based access control (RBAC)
• Row‑Level Security (RLS) / Object‑Level Security (OLS)
• Data access patterns across Fabric and Power BI
• Define data sharing and access control processes

3. Administration & Platform Setup

• Configure and optimize:
• Power BI tenant settings
• Fabric capacity (capacity planning, workload management)
• Monitoring and usage metrics
• Set up:
• Deployment pipelines
• CI/CD best practices (where applicable)
• Audit logs and governance controls

4. Best Practices & Standards

• Define and document:
• Development standards (data modeling, DAX, report design)
• Performance optimization guidelines
• Dataset/reusable semantic model strategy
• Establish certification and promotion workflows for datasets and reports

5. Hands‑On Implementation

• Work alongside the team to:
• Build or refactor key dashboards/reports using best practices
• Set up Fabric artifacts (Lakehouse/Warehouse/Pipelines)
• Ensure real use cases are implemented, not just theoretical training

6. Knowledge Transfer & Self‑Sufficiency

• Provide:
• Playbooks, SOPs, and governance documentation
• Recorded sessions and training materials
• Mentor team members through:
• Office hours / Q&A sessions
• Code and architecture reviews
• Ensure the team can independently:
• Manage Fabric capacity
• Govern Power BI environment
• Implement secure and scalable solutions

Expected Outcomes (End of Engagement)

• Fully defined and implemented Power BI & Fabric governance framework
• Configured and optimized Fabric capacity + Power BI tenant
• Established security and access control processes
• Documented standards, playbooks, and operating model
• BI team capable of independent development, administration, and governance

Required Skills & Experience

Must‑Have

• 5+ years of experience in Power BI development and administration
• Hands‑on experience with Microsoft Fabric (end‑to‑end)
• Strong expertise in:
• Power BI governance and tenant administration
• Fabric capacity management
• Security models (RLS, RBAC, data access controls)
• Experience setting up enterprise BI governance frameworks
• Proven track record of training and mentoring teams

Good‑to‑Have

• Experience with data platforms (Snowflake, Azure, etc.)
• Knowledge of CI/CD for Power BI (DevOps integration)
• Familiarity with data catalog and lineage tools (e.g., Atlan, Alation)
• Understanding of modern data architecture patterns