Total compensation:CAD $140,000 - $175,000
Role OverviewThe
Data Architect(Azure Data Architect or Data Platform Architect) designs and leads the build-out of scalable,
AI-readydata solutions using
Microsoft Fabricand the
Azure data ecosystem. This role connects business goals to data architecture, ensuring platforms are secure, performant, and optimized for analytics and AI use cases.
You will define how data flows from
raw ingestion (bronze)through
transformation (silver)to
curated, analytics-ready models (gold). You will collaborate with engineering and business peers to design data environments that enable analytics, automation, and AI-driven insight.
Key Responsibilities- Architect Microsoft Fabric environments:Design end-to-end data architectures, defining ingestion, transformation, and curation patterns that support analytics and AI workloads.
- Design and manage data lake architectures:Ensure efficient replication, synchronization, and data flow across Fabric workspaces and multi-zone environments.
- Framework alignment:Ensure all data architectures align withMicrosoft's Cloud Adoption Framework (CAF)and theAzure Well-Architected Frameworkto maintain consistency, scalability, and governance across solutions.
- Define business-aligned data models:Partner with stakeholders to understand reporting, analytics, and AI needs and design scalable, flexible data models.
- AI readiness:Define structures, metadata, and access patterns that make data discoverable and usable for AI workloads such as retrieval-augmented generation (RAG), intelligent search, and summarization.
- Data governance and security:Collaborate with peers to implement encryption at rest and in transit, role-based access controls (RBAC), and data masking that meet enterprise and client expectations for data integrity and privacy.
- Performance and cost optimization:Guide architecture decisions related to Fabric SKUs, OneLake storage, and data refresh strategies for efficient scale and cost.
- Collaboration and mentorship:Work closely withData Engineersto translate architecture into delivery, promote data quality, and ensure design consistency.
- Documentation and enablement:Produce reference architectures, blueprints, and reusable standards that accelerate future projects and maintain governance consistency.
Skills and Qualifications- 7 or more years of experience indata architecture,data engineering, ordata platform design, with at least 2 years in theMicrosoft Azure data ecosystem.
- Proven experience withMicrosoft Fabric,Azure Data Factory,Synapse, andPower BI.
- Strong understanding ofdata lakehouse design,ELT/ETLpatterns, andschema evolution.
- Proficiency inSQLand working knowledge ofPythonfor automation or validation tasks.
- Familiarity withdata governanceand metadata management tools such asMicrosoft Purview.
- Practical understanding ofdata security,RBAC,encryption, andprivacy best practices.
- Excellent communication and collaboration skills with the ability to work across disciplines.
- Strategic thinker comfortable inAI-ready, iterative, and client-focused environments.
Tools and TechnologiesMicrosoft Fabric, Azure Data Factory, Synapse, Power BI, Azure SQL, Databricks, Data Lake Storage, Microsoft Purview, Python, SQL, Git, Terraform or Bicep, Azure Monitor.
Nice to Have- Experience applyingMicrosoft's Cloud Adoption Framework (CAF)and theAzure Well-Architected Frameworkto ensure scalability and governance consistency.
- Experience enablingAI and semantic capabilities, including metadata enrichment, retrieval-augmented generation (RAG), and knowledge graph design.
- Exposure todata product thinking,domain-driven design, ordata meshprinciples.
- Familiarity withvector databases,semantic search, andembedding pipelines.
