Job Description

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 (https://www.censis.com/), 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.

Fortive Corporation Overview

Fortive's essential technology makes the world stronger, safer, and smarter. We accelerate transformation across a broad range of applications including environmental, health and safety compliance, industrial condition monitoring, next-generation product design, and healthcare safety solutions.


We are a global industrial technology innovator with a startup spirit. Our forward-looking companies lead the way in software-powered workflow solutions, data-driven intelligence, AI-powered automation, and other disruptive technologies. We're a force for progress, working alongside our customers and partners to solve challenges on a global scale, from workplace safety in the most demanding conditions to groundbreaking sustainability solutions.


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.


At Fortive, we believe in you. We believe in your potential--your ability to learn, grow, and make a difference.


At Fortive, we believe in us. We believe in the power of people working together to solve problems no one could solve alone.


At Fortive, we believe in growth. We're honest about what's working and what isn't, and we never stop improving and innovating.


Fortive: For you, for us, for growth.

About Censis

Censis, the first company to engineer a surgical asset management system that tracks down to the instrument and patient levels, has continually set the standards for the sterile processing industry.From the beginning, Censis has recognized the vital connection between perioperative innovation and efficiency, unparalleled customer care and improved operational performance. By continuing to invest in technology, ease of integration, education and support, Censis provides solutions that empower hospitals and healthcare providers to stay compliant and ahead of healthcare's rapidly changing environment. With Censis, you're positioned to start ahead and stay ahead, no matter what the future holds.


We Are an Equal Opportunity Employer. Fortive Corporation and all Fortive Companies are proud to be equal opportunity employers. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law. Fortive and all Fortive Companies are also committed to providing reasonable accommodations for applicants with disabilities. Individuals who need a reasonable accommodation because of a disability for any part of the employment application process, please contact us at applyassistance@fortive.com.

Bonus or Equity

This position is also eligible for bonus as part of the total compensation package.


Censis, the first company to engineer a surgical asset management system that tracks down to the instrument and patient levels, has continually set the standards for the sterile processing industry.From the beginning, Censis has recognized the vital connection between perioperative innovation and efficiency, unparalleled customer care and improved operational performance. By continuing to invest in technology, ease of integration, education and support, Censis provides solutions that empower hospitals and healthcare providers to stay compliant and ahead of healthcare's rapidly changing environment. With Censis, you're positioned to start ahead and stay ahead, no matter what the future holds.
We Are an Equal Opportunity Employer. Fortive Corporation and all Fortive Companies are proud to be equal opportunity employers. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law. Fortive and all Fortive Companies are also committed to providing reasonable accommodations for applicants with disabilities. Individuals who need a reasonable accommodation because of a disability for any part of the employment application process, please contact us at applyassistance@fortive.com.


NoneThis position is also eligible for bonus as part of the total compensation package.