- 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.
