Job description

Job Title: Microsoft Fabric Solutions Architect • *Location:** - Boston, MA • *Reports To:** VP of Enterprise Architecture --- • *Position Overview** Tier4 Group is seeking an accomplished **Microsoft Fabric Solutions Architect** to lead the design, implementation, and modernization of enterprise-scale analytics platforms. In this senior consulting role, you will serve as a trusted advisor to clients, architecting end-to-end data solutions within the **Microsoft Fabric** ecosystem and driving digital transformation initiatives that deliver measurable business impact. You will guide clients through strategic data modernization—envisioning Lakehouse architectures, implementing medallion-layered data models, and orchestrating large-scale data migrations. This role requires both deep technical expertise and the ability to engage executives and technical teams in shaping data strategies that align with business objectives. --- • *Key Responsibilities** • **Lead enterprise data modernization initiatives** leveraging Microsoft Fabric’s unified analytics platform across Data Engineering, Data Science, and BI domains. • **Architect and design Lakehouse and medallion architectures** (Bronze, Silver, Gold layers) using Fabric’s Delta tables to support scalable, high-performance, and governed data ecosystems. • **Define and implement data orchestration strategies** using Fabric Data Pipelines and Notebooks (PySpark), modernizing legacy ETL frameworks such as SSIS. • **Oversee large-scale data migrations**, including full end-to-end transitions (e.g., 22TB Redshift warehouse migrations) into Microsoft Fabric, ensuring continuity, integrity, and performance optimization. • **Leverage Fabric’s table mirroring and integrated Data Warehouse capabilities** to unify disparate data sources, enabling near real-time analytics and reporting. • **Collaborate directly with client executives, architects, and engineering teams** to translate business requirements into scalable, sustainable data architectures. • **Establish and evangelize best practices** for data modeling, governance, lineage, and performance tuning within Microsoft Fabric. • Support pre-sales activities by leading client workshops, developing architecture blueprints, and creating proofs of concept that demonstrate Fabric’s value. • Mentor junior consultants and engineers, fostering technical excellence across engagements. --- • *Qualifications** • 7+ years of experience in **data architecture, engineering, or BI modernization**, with at least 2+ years hands-on in **Microsoft Fabric**. • Proven experience architecting and implementing **Lakehouse** and **medallion architecture** frameworks using Delta tables. • Strong proficiency in **PySpark**, **Data Pipelines**, **Fabric Notebooks**, and **Fabric Data Warehouse**. • Demonstrated success in **migrating large-scale data platforms** (e.g., Amazon Redshift, Azure Synapse, SQL Server) into Microsoft Fabric. • Deep understanding of **ETL/ELT design**, **data modeling**, **metadata management**, and **data governance**. • Exceptional communication and consulting skills, with the ability to influence senior stakeholders and translate technical solutions into business outcomes. • Experience working in a **consulting or client-facing architecture** capacity. --- • *Preferred Skills** • Microsoft certifications: **Azure Data Engineer Associate**, **Fabric Analytics Engineer Associate**, or **Azure Solutions Architect Expert**. • Experience integrating **Power BI** and Fabric-based semantic models. • Familiarity with **CI/CD pipelines**, **Git**, and **DevOps practices** for Fabric deployments. • Thought leadership experience (e.g., presenting at conferences, publishing blogs, or contributing to data architecture communities).

Requirements