BI Platform Architect (Microsoft Fabric) — End-to-End Data & Governance

The Leadership Agency Inc.; New York, Northern (NY, KY); Hybrid; USD 140,000 - 150,000; Full time

Benefits offered by this job

Pension after qualifying period

Summer Fridays

Hybrid work after initial period

Job summary

The Leadership Agency Inc. seeks a BI Data Architect to own the Microsoft Fabric platform for a flagship New York City cultural institution. This brand‑new seat designs what comes next, handling ingestion, lakehouse design, governance and the Power BI layer used by business users.

You’ll design and manage Fabric pipelines, implement Bronze/Silver/Gold, mentor a small BI team, and work with the CIO on the data roadmap. Not remote; on-site first 3 months, then hybrid.

Qualifications

• 5–10 years in data architecture, data engineering or BI engineering.
• Hands-on Microsoft Fabric experience with end-to-end pipelines and lakehouses.
• Strong knowledge of Bronze/Silver/Gold medallion architecture and governance.
• Proficiency in T-SQL, Python and the Azure data stack; excellent communication.

Responsibilities

• Design and manage pipelines and lakehouses in Fabric across Bronze/Silver/Gold layers.
• Build out data governance standards, documentation, quality monitoring and security.
• Partner with analysts to translate architecture into trusted dashboards.
• Mentor the BI team and drive organization-wide data self-service adoption.

Skills

Microsoft Fabric

Pipelines & Dataflows

Lakehouse design

Power BI

Medallion architecture

T-SQL

Azure data stack

Python

Data governance & security

Communication

Tools

Azure Data Factory

Data Lake Storage

Notebooks

Power BI (enterprise)

Job description

The Leadership Agency Inc. seeks a BI Data Architect to own the Microsoft Fabric platform for a flagship New York City cultural institution. This brand‑new seat designs what comes next, handling ingestion, lakehouse design, governance and the Power BI layer used by business users.

You’ll design and manage Fabric pipelines, implement Bronze/Silver/Gold, mentor a small BI team, and work with the CIO on the data roadmap. Not remote; on-site first 3 months, then hybrid.