What are the responsibilities and job description for the Microsoft Fabric Architect & Administrator position at TechSpace Solutions Inc.?
Job Title: Microsoft Fabric Architect & Administrator
Location: Blue Bell, PA 19422 (Onsite)
Duration: 6-12 Months
Must Have Skills:
- Experience: 10 years in Data Architecture or Engineering, with at least 1-2 years of hands-on experience in Microsoft Fabric (or deep expertise in Power BI Azure Synapse/Databricks).
- Technical Mastery: Proficient in PySpark/Notebooks, T-SQL, and DAX.
- Data Strategy: Proven track record of designing "OneLake" architectures that break down departmental data silos.
Role Overview:
- We are seeking a visionary Microsoft Fabric Architect & Administrator to lead our transition into a unified, AI-ready data ecosystem. In this role, you will be the primary owner of our Microsoft Fabric tenant responsible for both the high-level architectural design of our OneLake data estate and the rigorous governance, security, and capacity management required to keep it running efficiently.
- The ideal candidate bridges the gap between deep technical data engineering (Spark, SQL, Delta Lake) and strategic platform administration.
Key Responsibilities:
Administration & Governance:
- Tenant Management: Configure and audit tenant settings, ensuring feature parity and security compliance across the organization.
- Capacity Optimization: Monitor Fabric Capacity (F-SKUs) usage via the Capacity Metrics app; implement scaling strategies to balance performance and cost.
- Security: Enforce fine-grained access control (RBAC), Row-Level Security (RLS), and Object-Level Security (OLS) across the Fabric ecosystem.
- Purview Integration: Manage data discovery and lineage through Microsoft Purview to ensure data democratization remains compliant, design and enforce labels to ensure protection across Fabric.
- Governance : Configure DLP policies to prevent unauthorized sharing or leakage of sensitive data from Lakehouses and Semantic Models.
- Logging, Alerting & Capacity Management: Integrate Fabric with Azure Log Analytics for long-term auditing and trend analysis , proactive monitoring and manage throttling and smoothing events; identify "noisy neighbor" workloads and implement scaling or staggering strategies to ensure performance.
- Power BI: Establishing standards and conduct training for non-IT data access PowerBI users in support of our data governance programs
Architecture & Engineering:
- Design & Implement: Oversight over build out our Medallion Architecture (Bronze, Silver, Gold) using Fabric Lakehouses and Warehouses. Providing best practices to data developers to ensure fabric capacity is not over-consumed and optimized.
- Data Integration: Develop efficient orchestration patterns using Data Factory pipelines and Dataflows Gen2, utilizing Shortcuts to minimize data duplication. Design, implement and manage all connectivity to the MS Fabric including data load sources from SaaS providers Performance Tuning: Optimize semantic models for DirectLake mode to provide near-real-time reporting without the overhead of traditional Import modes.
- CI/CD & DevOps: Establish deployment pipelines using Git integration to manage lifecycle transitions between Dev, Test, and Production.
Required Qualifications:
- Experience: 10 years in Data Architecture or Engineering, with at least 1-2 years of hands-on experience in Microsoft Fabric (or deep expertise in Power BI Azure Synapse/Databricks).
- Technical Mastery: Proficient in PySpark/Notebooks, T-SQL, and DAX.
- Data Strategy: Proven track record of designing "OneLake" architectures that break down departmental data silos.
- Certifications: (Preferred) DP-600: Microsoft Fabric Analytics Engineer Associate or AZ-305: Azure Solutions Architect Expert.