Microsoft Fabric Architect

• Design and implement scalable BI and data architecture using Microsoft Fabric and Lakehouse paradigms, including medallion architecture.
• Architect and optimize ELT/ETL pipelines using SQL Server, Dataflows, and Fabric Pipelines.
• Integrate on-premises data sources using On-prem Data Gateway (ODG) with cloud-based solutions.
• Develop a robust semantic layer and underlying data model to bridge technical data and business language, applying data virtualization principles.
• Design and optimize semantic models that represent data in a way that enhances understanding and usability for analytics.

Development & Implementation

• Build and manage data pipelines, Lakehouses, and Data Warehouses in Microsoft Fabric.
• Manage Power BI dashboards with advanced DAX and real-time data integration.
• Implement data governance, security, and compliance best practices using Microsoft Purview or Fabric-native tools.
• Utilize AI-driven development and delivery to enhance solution effectiveness and efficiency.
• Define data quality checks, transformations, and cleansing rules, and work with data engineers to implement them within the semantic layer.
• Strong T-SQL knowledge, materialize View, Indexing, Column store, Dimensional Data Modelling

Leadership & Collaboration

• Collaborate with business stakeholders to translate requirements into technical solutions and intuitive business language.
• Lead and mentor a team of BI developers, data engineers, analysts, and collaborate with data architects.
• Drive adoption of Microsoft Fabric, modern BI practices, and semantic modelling methodologies across the organization.

Monitoring & Optimization

• Monitor and optimize data pipeline performance and troubleshoot issues.
• Ensure data quality, lineage, and availability across all reporting layers.
• Maintain comprehensive documentation of architecture, data models, workflows, and semantic layer details.

Required Skills & Qualifications

• Experience: 11+ years in Data & Analytics with at least 1 year in Microsoft Fabric and 4-6 years in semantic data modelling.
• BI Tools: Working Knowledge in Power BI and integration with Fabric.
• Data Integration: Experience with On-prem Data Gateway (ODG) and hybrid data environments.
• Data Engineering: Proficient in designing ELT/ETL processes using SQL Server and Fabric Pipelines.
• Architecture: Strong understanding of medallion architecture, data virtualization principles, cloud-based data management, and analytics technologies.
• Programming: Expertise with Python, Spark, T-SQL, or other scripting languages for data transformation.
• Methodologies: Agile/Scrum project delivery experience.
• Communication: Strong verbal and written communication skills with the ability to convey complex technical data in simple business language.

Additional Skills:

• Experience with other data platforms such as Snowflake, Databricks, Azure Data Gateway, Azure Synapse is a plus.
• Certifications: Microsoft certifications in Azure, Power BI, or Fabric are a plus.
• We are a diverse team 17,000 strong, united by a dynamic, inclusive culture and energized by limitless learning and growth. We use the proven Fortive Business System (FBS) to accelerate our positive impact.