Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Ampera Technologies

Power BI & Microsoft Fabric Consultant - Contract Position

Posted Updated

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

Skills:- PowerBI

Skills

Apply

See also