Business Intelligence REQ_188
- Location
- US
- Work mode
- Hybrid
Posted Nov 18, 2026Last confirmed open Nov 18, 2026
About this role
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!
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!
Prefer to apply directly?
Apply on 3Pillar Global