Lead MS Fabric Administrator

TriCom Technical Services, Inc.; Pittsburgh (Allegheny County); Remote; USD 140,000 - 170,000; Full time

Job summary

TriCom Technical Services, Inc. seeks a Lead Fabric Administrator to serve as the senior technical lead for Microsoft Fabric governance, security, and adoption across enterprise analytics in a remote, permanent role.

You will collaborate with data engineers, BI teams, architects, and business stakeholders to maintain a secure, efficient platform and drive adoption with enterprise-wide data and analytics objectives.

Qualifications

• Bachelor's degree or equivalent professional experience in a technical field.
• Proficient in SQL for monitoring, tuning, and diagnostics of Fabric workloads.
• Strong knowledge of Fabric components and Power BI administration.
• Experience with RLS/OLS in Fabric/Power BI semantic models and security patterns.
• Experience with Entra ID service principals, app registrations, and secret management.
• Familiarity with CI/CD deployment of Fabric artifacts via pipelines and automation.

Responsibilities

• Administer Fabric tenant settings, workspaces, domains, and platform configurations.
• Manage domain delegation and data product boundaries in line with data mesh principles.
• Oversee capacity provisioning, monitoring, and cost optimization.
• Configure security controls including RBAC, workspace permissions, and conditional access.
• Manage data gateways, VNet gateways, and secure hybrid connectivity.
• Develop and maintain administration runbooks and operational docs.

Skills

Advanced SQL

Fabric administration

CI/CD pipelines

Azure DevOps

Power BI administration

VNet data gateways

Education

Bachelor's degree in Computer Science or related field

Tools

GitHub Actions

PowerShell

Python scripting

REST API

Job description

Lead Fabric Administrator

Summary

Our client is seeking a Fabric Administrator to serve as the Sr. technical Lead for Microsoft Fabric, responsible for governance, security, and adoption across enterprise analytics. This role will collaborate with Data Engineers, BI teams, architects, and business stakeholders to maintain a secure, efficient, and compliant platform. Responsibilities span governance and data classification, identity and security frameworks, capacity management, gateway and connectivity administration, and CI/CD deployment across development, test, and production environments. The Lead Fabric Administrator will drive operational excellence, resiliency, and platform adoption while supporting enterprise-wide data and analytics objectives in a professional-services setting.

Responsibilities

• Administer Fabric tenant settings, workspace structures, Fabric Domains, and platform configurations across capacities, ensuring alignment with established governance standards.
• Manage domain-level delegation and data product boundaries across business units in line with data mesh principles.
• Manage capacity provisioning, performance monitoring, utilization analysis, and cost optimization.
• Oversee capacity throttling, smoothing, and interactive versus background operations; make pause, resume, and scale decisions on F-SKU capacities using the Fabric capacity metrics App.
• Configure and maintain security controls including role-based access, workspace permissions, sharing settings, and conditional access aligned with enterprise Requirements
• Administer and validate row-level security (RLS) and object-level security (OLS) at the semantic model layer including role membership models, security-table design, and deployment-time integrity checks (for example: guarding against REST or automated deployments stripping role members).
• Manage Microsoft Entra ID service principals and app registrations including tenant settings that gate service principal access to Fabric and Power BI APIs, permission scoping, and credential and secret rotation.
• Administer on-premises data gateways and VNet data gateways, including gateway cluster configuration, Private Link and managed private endpoints, and secure hybrid connectivity to on-premises and Cloud data sources.
• Administer Microsoft Purview integrations with Fabric, including sensitivity labels, data loss prevention policies, and information protection controls aligned to approved governance standards.
• Configure, maintain, and support CI/CD deployment processes for Fabric artifacts across development, test, and production environments using Azure DevOps or GitHub Actions, alongside native Fabric deployment Pipelines and workspace Git integration.
• Configure and maintain the Admin monitoring workspace and tenant-wide dashboards to monitor adoption, usage, and performance effectively.
• Own backup, disaster recovery, and data resiliency for the platform, including OneLake resiliency considerations and documented, tested recovery procedures for production.
• Support incident, change, and release management including ITSM/ServiceNow workflows, incident response, SLA ownership, participation in scheduled release Windows, and enforcement of formal promotion and change gates.
• Provide cost allocation, chargeback, and showback reporting for shared capacity consumed across business units.
• Develop and maintain administration runbooks, operational procedures, and supporting documentation.
• Assist with implementation and adoption of enterprise governance and security standards.
• Partner with data engineers, BI teams, business analysts, and business leaders to gather requirements, recommend enhancements, and provide Fabric administration expertise.
• Participate in evaluating and testing AI capabilities within Fabric and Purview and recommend compliant feature implementation in data workflows.
• Monitor AI governance requirements, vendor guidelines, and data retention policies associated with AI services, and support execution of organizational AI governance and compliance measures.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field; OR equivalent professional experience.
• Advanced SQL knowledge for query monitoring, performance-tuning, and diagnostic analysis of Fabric workloads, using medallion Architecture or Lakehouse designs.
• Advanced knowledge of Fabric capacity provisioning, workload oversight, OneLake storage, licensing strategy, cost efficiency techniques, and Power BI administration.
• Advanced expertise across Fabric platform components including Data Factory, Dataflow Gen2, Notebooks, Lakehouse, warehouse, Power BI models, and Real-Time analytics.
• Demonstrated experience administering RLS and OLS in Power BI/Fabric semantic models, including membership-based security patterns and validation of security integrity through deployment.
• Demonstrated experience managing Entra ID service principals and app registrations for Fabric and Power BI automation, including API access configuration and secret management.
• Demonstrated experience administering on-premises and VNet data gateways and secure connectivity (Private Link, managed private endpoints) in hybrid environments.
• At least five years of practical experience with Microsoft Azure services, including storage, identity management, DevOps, and networking.
• Demonstrated implementation experience integrating Microsoft Purview with Fabric, covering sensitivity labels, DLP policies, audit logging, and enterprise data governance frameworks.
• Demonstrated experience deploying Fabric artifacts across environments using CI/CD pipelines, Fabric deployment Pipelines, PowerShell, the Fabric REST API, and Python-based automation.
• At least two years of hands‑on production experience with Microsoft Fabric since its general availability (November 2023), complemented by prior Power BI Premium and/or Azure Synapse analytics experience.
• Experience with backup, disaster recovery, and business continuity for Cloud analytics platforms.
• Experience with multi-tier administration models, role delegation, and scaling platform access controls, while mentoring technical team members and solving complex problems.
• Exceptional communication and documentation skills, and the ability to translate intricate technical concepts into concise runbooks and training resources.
• Availability to participate in scheduled release Windows and provide support during production events when required.
• Ability to travel as needed, up to 5%, to company locations, supplier facilities, or industry events.

Preferred

• Experience supporting analytics platforms in a regulated or professional‑services environment (e.g., legal) including data residency, retention, and legal-hold requirements.
• Familiarity with data mesh and medallion Architecture governance at enterprise scale.
• Experience with ServiceNow‑based data product onboarding and IT service management workflows.

This is a Remote, Permanent opportunity with our Pittsburgh, PA client. H1-B Visa sponsorship is not available for this position. No third-parties, please.