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

3Pillar Group

NewBe an early applicant

Lead, Business Intelligence (PowerBI/ Microsoft Fabric) REQ_188

Posted Updated

Description

3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin America, and Asia, we work with the most ambitious companies in financial services, healthcare, media, and technology — helping them move faster, modernize boldly, and compete on their own terms. Our HelixAI platform and Helix Pods delivery model put our engineers at the center of real agentic transformation — doing work that is open, portable, and built to last. We are building the future of enterprise AI.

Lead, Data Engineering - Power BI & Microsoft Fabric

👋 Greetings, future tech savant:

Embark on an exciting journey into the realm of software development with 3Pillar! We extend an invitation for you to join our team and gear up for a thrilling adventure. At 3Pillar, our focus is on crafting cutting-edge technologies that revolutionize industries. As a Software Engineer, you'll play a vital role in our dynamic team, contributing to exciting projects that redefine urban living, establish new media channels for enterprise companies, or drive innovation in healthcare. This opportunity goes beyond code – it's about creating epic solutions that leave a lasting impression in the market. If your passion for programming fuels your drive to make a real-world impact, consider this your pass to the captivating world of Product Development! 🚀💻


Key Responsibilities

  • Assess Current State & Deliver Roadmap: Conduct a comprehensive discovery phase (first ~30 days) to inventory 700+ Power BI and paginated (RDL) reports, data sources, semantic models, and dual tenants, delivering a phased target-state architecture plan.

  • Design Target Medallion Architecture: Define and implement a scalable Microsoft Fabric medallion (Bronze/Silver/Gold) architecture with shared, certified semantic models to replace fragmented, one-off report models.

  • Build Hands-On Solutions: Develop and execute pipelines, dataflows, semantic models, scripts, and migrations directly—this is a deeply hands-on engineering and architecture role.

  • Decouple Reports from Application Databases: Refactor and extract embedded queries from Power BI and paginated (RDL) reports onto shared models so application schema changes no longer disrupt reporting.

  • Implement Multi-Tenant Row-Level Security (RLS): Architect and enforce robust RLS within shared data models so standardized reports securely serve multiple external clients in a customer-facing application.

  • Lead Tenant Consolidation: Plan and execute the seamless migration and consolidation of data, data sources, workspaces, and 700+ reports from two separate tenants into a single unified environment.

  • Establish Data Governance & Enablement: Implement workspace strategies, access controls, endorsement/certification processes, and lineage tracking, empowering report builders to focus on visuals and storytelling using curated datasets.

  • Engage Stakeholders & Collaborate: Lead discovery and alignment meetings across technical leads, client sponsors, and diverse business practices to gather requirements, communicate changes, and drive user adoption.

Minimum Qualifications

  • Senior-Level Power BI Expertise: Proven experience in enterprise Power BI architecture, dimensional data modeling (star schema, shared semantic models), and advanced DAX.

  • Hands-On Microsoft Fabric Data Engineering: Demonstrated proficiency building Lakehouse/Warehouse environments, pipelines, dataflows, and medallion (Bronze/Silver/Gold) architectures.

  • Row-Level Security (RLS) Mastery: Proven track record implementing dynamic RLS for multi-tenant or external-client reporting environments.

  • Large-Scale Tenant & Workspace Migration: Experience planning and executing Power BI tenant or workspace consolidations involving hundreds of reports.

  • Paginated Reports & SQL Proficiency: Strong SQL skills paired with experience developing and refactoring paginated reports (RDL / Power BI Report Builder) onto shared semantic models.

  • Power BI Governance: Deep understanding of workspace architecture, access control, dataset certification, data lineage, and usage monitoring.

  • Autonomous Delivery & Communication: Track record of both designing and executing complex data platforms independently, with clear communication across technical and non-technical stakeholders.

  • Proficiency in the English Language: Strong verbal and written communication skills to lead cross-functional meetings and collaborate with North American client stakeholders.

What this role will help with

  • Building and maintaining Gold-layer reporting data in Fabric (Bronze/Silver/Gold).

  • Setting up row-level security (RLS) in Power BI semantic models based on UserId.

  • Moving interactive and paginated (RDL) reports off report-specific filters and onto the shared secured models.

  • Making sure changes to user access reach Fabric quickly, without waiting for the nightly data load.

Nice to have: Power BI Embedded (embed tokens with effective identity), DAX, and Fabric/medallion architecture.

Additional Experience Desired

  • Microsoft Certifications: Fabric Analytics Engineer (DP-600), Fabric Data Engineer (DP-700), or Power BI Data Analyst (PL-300).

  • Application Embedding: Experience with Power BI Embedded and integrating analytics into customer-facing applications.

  • DevOps & CI/CD for BI: Familiarity with Microsoft Fabric Git integration, deployment pipelines, and automated CI/CD workflows for Power BI.

  • Identity & Tenant Administration: Knowledge of Microsoft Entra ID (Azure AD) tenant administration.

  • Consulting Background: Prior consulting experience working with engineering or field-operations organizations.

What is it like working for 3Pillar Global?

At 3Pillar, we offer a world of opportunity:

  • Imagine a flexible work environment – whether it's the office, your home, or a blend of both. From interviews to onboarding, we embody a remote-first approach.

  • You will be part of a global team, learning from top talent around the world and across cultures, speaking English everyday. Our global workforce enables our team to leverage global resources to accomplish our work in efficient and effective teams.

  • We’re big on your well-being – as a company, we spend a whole trimester in our annual cycle focused on wellbeing. Whether it is taking advantage of fitness offerings, mental health plans (country-dependent), or simply leveraging generous time off, we want all of our team members operating at their best.

  • Our professional services model enables us to accelerate career growth and development opportunities - across projects, offerings, and industries.

  • We are an equal opportunity employer. It goes without saying that we live by values like Intrinsic Dignity and Open Collaboration to create cutting-edge technology AND reinforce our commitment to diversity - globally and locally.

Join us and be a part of a global tech community! 🌍💼 Check out our Linkedin site and Careers page to learn more about what it’s like to be part of our #oneteam!


Skills

Apply

See also