Sign up to continueApply now
3Pillar Global· Spotted 2d ago

Business Intelligence REQ_188

Location
US
Work mode
Hybrid

Posted Nov 18, 2026Last confirmed open Nov 18, 2026

Sponsorship not stated

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

Company

Back to jobs