Job Details

Sr. Data Architect

Censis Technologies, a global leader in surgical instrument tracking and asset management solutions, is seeking a highly experienced and innovative Sr. 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.

In addition to data architecture, the role will be responsible for building and leading an enterprise architecture function, ensuring technology alignment with business strategy and innovation objectives.

Enterprise Architecture Leadership

• Define and maintain enterprise architecture strategy aligning business objectives with technology capabilities, ensuring scalability, reliability, security, and compliance.
• Lead, mentor, and scale a team of solution and enterprise architects, fostering a high-performance culture rooted in architectural excellence, innovation, and collaboration.
• Lead architecture governance and standards, establishing frameworks, best practices, and review designs and processes across applications, data, interfaces, and infrastructure domains.
• Drive cross-functional alignment by collaborating with business, IT, and engineering leaders to ensure technology roadmaps support organizational priorities and innovation.
• Build the Enterprise Architecture team, fostering strong architectural excellence, knowledge sharing, and continuous improvement across the enterprise.
• Evaluate emerging technologies and guide strategic investments in data platforms, AI tools, interfaces and automation to enhance healthcare efficiency and outcomes.
• Build relationships with partners such as Microsoft, AWS and Service delivery partners to execute on the enterprise architecture vision and strategy.

Architecture & Design

• Design and implement scalable BI and data architecture using Data Lake or Lakehouse paradigms, including medallion architecture.
• Architect and optimize ELT/ETL pipelines using SQL Server, Dataflows, and data 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, Data Lakes, and Data Warehouses in Azure or AWS.
• Manage Power BI dashboards with advanced DAX and real-time data integration.
• Implement data governance, security, and compliance best practices.
• 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.

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: 12+ years in data architecture, with at least 35 years in an enterprise or solution architecture leadership capacity.
• Leadership: Proven experience building and leading cross-functional enterprise architecture teams and influencing enterprise-wide technology direction.
• Expertise in semantic data modelling and data engineering skills.
• Experience in architecture frameworks, best practices, designs and processes across applications, data, interfaces, and infrastructure domains.
• Strong experience with data platforms such as Snowflake, Databricks, Microsoft Fabric, or Azure Data Gateway, Azure Synapse.
• BI Tools: Working Knowledge in Power BI and integration with Microsoft Fabric is a plus.
• Data Integration: Experience with interfaces, API designs and 3rd party systems integration using tools such as Boomi, Azure API Management, and other middleware platforms.
• Data Engineering: Proficient in designing ELT/ETL processes using SQL Server, columnar data format such as Delta or Parquet and Fabric Pipelines.
• Architecture: Strong understanding of medallion architecture, data virtualization principles, cloud-based data management, and analytics technologies.
• AI: Working knowledge of AI tools to accelerate development is a plus, such as Github Copilot, Cursor AI, Claude or similar.
• Programming: Expertise with Python, T-SQL, Spark or other scripting languages for data transformation.
• Experience in programming languages such as C#, .NET platform, Node.js, Vue.js will be preferable.
• Methodologies: Agile/Scrum project delivery experience.
• Communication: Exceptional communication, strategic thinking, and stakeholder management skills; ability to bridge technical and business domains effectively.

Certifications: Certifications in Azure, Power BI, Microsoft Fabric and other Data or Enterprise architecture platforms are a plus.

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