Information Technology - BI Data Architect

Purpose

As a key member of the Data Analytics and Reporting team, the Data Architect will lead the design, implementation, and optimization of an enterprise data platform built on the Microsoft Fabric ecosystem. This role is responsible for translating business and analytical requirements into scalable, secure, and high-performance data architectures that enable advanced analytics, AI-driven insights, and enterprise reporting. The ideal candidate will possess deep expertise in Microsoft Fabric, modern cloud data engineering, and advanced analytics technologies.

They will drive the evolution of Lakehouse, warehouse, and semantic models while enabling AI and machine learning workloads through trusted, governed, and high-quality data assets. This role partners closely with data engineers, analytics developers, data scientists, and business stakeholders to ensure the organization's data platform supports predictive analytics, automation, and intelligent decision‑making.

Lead the architecture, design, and governance of the Microsoft Fabric environment, including Lakehouse, Data Warehouse, One Lake, and Semantic Models.

Design and maintain scalable data models optimized for BI, advanced analytics, and AI workloads.

Architect end‑to‑end data pipelines using Fabric Data Factory, notebooks, and streaming capabilities.

Implement and optimize data ingestion, transformation, and orchestration processes for structured and unstructured data.

Enable advanced analytics, machine learning, and AI initiatives through well‑designed data foundations and feature stores.

Ensure quality, consistency and security of database design, and ability to meet enterprise requirements in alignment with DBA, Enterprise Architect, and Integration teams.

Establish best practices for data modeling, performance tuning, security, and cost optimization within Fabric.

Develop and maintain enterprise metadata, lineage, and data cataloging using Microsoft Purview and Fabric governance tools.

Collaborate with data science teams to support model training, deployment, and monitoring.

Review and govern ETL/ELT processes, notebooks, and transformation logic.

Ensure compliance with data security, privacy, and regulatory requirements.

Lead architectural reviews and approve platform changes to ensure stability and integrity.

Translate complex business and analytical needs into technical architecture and implementation plans.

Mentor and guide data engineers, BI developers, and analytics professionals.

Support real‑time and near‑real‑time analytics use cases.

Drive adoption of AI‑powered analytics, Copilot, and intelligent reporting capabilities.

Continuously evaluate emerging data, analytics, and AI technologies and recommend improvements.

Strong hands‑on experience with Microsoft Fabric (Lakehouse, Warehouse, Data Factory, Notebooks, Semantic Models). Advanced proficiency in Azure data services and cloud‑native architecture. Expertise in modern data modeling (dimensional, data vault, Lakehouse, feature engineering). Experience supporting machine learning, AI, and advanced analytics pipelines. Proficiency in SQL, PySpark, and Python for analytics and data engineering. Knowledge of MLOps, data versioning, and model lifecycle management.

Experience with data governance, lineage, and cataloging platforms. Strong understanding of data security, identity management, and compliance in cloud environments. Experience integrating external AI/ML platforms and APIs.

Strategic thinker with ability to align data architecture with business and AI initiatives. Strong communication skills for technical and executive audiences. Proven ability to lead cross‑functional data and analytics projects. Analytical and problem‑solving mindset. Ability to manage multiple priorities in a fast‑paced, innovation‑driven environment. Collaborative leadership style and mentoring capability. Innovative mindset with strong interest in emerging AI technologies.

Bachelor's degree in Computer Science, Data Science, Information Systems, or related field (or…