Power BI and Microsoft Fabric Consultant at Ampera | Torre

Power BI and Microsoft Fabric Consultant

Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time

Legal agreement: Employment

Base compensation
INR10 - 25/hour
Unpaid - Unpaid

+ Health insurance

Negotiable
location_on
Remote (for India residents)
Posted 2 months ago

Responsibilities


Job Details: - Title: Power BI and Microsoft Fabric. - Experience: 5+ years. - Location: Remote. - Work type: Remote. - Notice Period: Immediate. - Work Day: Mon to Fri. 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. Power BI & Fabric Enablement: - Conduct structured training sessions and workshops on Power BI (Pro + Fabric-integrated experiences). - Conduct structured training sessions and workshops on Microsoft Fabric (Lakehouse, Warehouse, Dataflows Gen2, Pipelines, etc.). - Build foundational understanding of end-to-end analytics workflows in Fabric. - Build foundational understanding of integration between Power BI and Fabric workloads. - Build foundational understanding of Data Lake (Snowflake). Governance & Security Framework: - Design and implement Power BI & Fabric governance model, including workspace strategy (Dev/Test/Prod separation). - Design and implement Power BI & Fabric governance model, including naming conventions and standards. - Design and implement Power BI & Fabric governance model, including content lifecycle management. - Establish security architecture including role-based access control (RBAC). - Establish security architecture including Row-Level Security (RLS) / Object-Level Security (OLS). - Establish security architecture including data access patterns across Fabric and Power BI. - Define data sharing and access control processes. Administration & Platform Setup: - Configure and optimize Power BI tenant settings. - Configure and optimize Fabric capacity (capacity planning, workload management). - Configure and optimize monitoring and usage metrics. - Set up deployment pipelines. - Set up CI/CD best practices (where applicable). - Set up audit logs and governance controls. Best Practices & Standards: - Define and document development standards (data modeling, DAX, report design). - Define and document performance optimization guidelines. - Define and document dataset/reusable semantic model strategy. - Establish certification and promotion workflows for datasets and reports. Hands-On Implementation: - Work alongside the team to build or refactor key dashboards/reports using best practices. - Work alongside the team to set up Fabric artifacts (Lakehouse/Warehouse/Pipelines). - Ensure real use cases are implemented, not just theoretical training. Knowledge Transfer & Self-Sufficiency: - Provide playbooks, SOPs, and governance documentation. - Provide recorded sessions and training materials. - Mentor team members through office hours / Q&A sessions. - Mentor team members through code and architecture reviews. - Ensure the team can independently manage Fabric capacity. - Ensure the team can independently govern Power BI environment. - Ensure the team can independently 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. - Strong expertise in Fabric capacity management. - Strong expertise in security models (RLS, RBAC, data access controls). - Experience setting up enterprise BI governance frameworks. - Proven track record of training and mentoring teams. Required Skills & Experience (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 architecture.