Microsoft Fabric Architect

Job Title: BI Data Architect Microsoft Fabric Power BI & Semantic Data Modeling

Location: Bangalore (Hybrid 2 to 3 days/week in office)

Experience: 11 Years (Minimum 2 years in Microsoft Fabric)

Company: Censis

About Censis India

Censis Technologies ( a global leader in surgical instrument tracking and asset management solutions. At the forefront of healthcare innovation Censis India plays a critical role in building data-driven platforms that empower hospitals and healthcare providers to improve operational efficiency compliance and patient safety. Our teams work on cutting-edge technologies including Microsoft Fabric Azure and advanced BI tools to deliver scalable secure and intelligent solutions that transform healthcare data into actionable insights.

Role Overview

Censis India is seeking a highly experienced and innovative BI Data Architect to lead the design and implementation of modern data solutions using Microsoft Fabric Lakehouse architecture Power BI semantic data modelling and medallion architecture. The ideal candidate will have a strong foundation in data architecture SQL Server data pipelines on-premises data integration using ODG (On-prem Data Gateway) and semantic layer development. This role demands a strategic thinker with hands-on expertise in building scalable secure and high-performance BI ecosystems leveraging AI-driven development and delivery.

Key Responsibilities

Architecture & Design

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