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.
Skills Required
Python, Spark, T-sql, Azure, Power Bi, snowflake , Databricks