Description
Senior Consultant Data & Solution Architect (Microsoft Fabric)
Role Details
Location:<br/><br/>Hybrid – Toronto or Montreal, Canada (2 days per week at the office)<br/><br/>Contract:<br/><br/>Permanent, Full-time<br/><br/>What Youll Architect<br/><br/>Collaborate with client stakeholders to translate business objectives into scalable target‑state data architectures and strategic roadmaps<br/><br/>Architect end‑to‑end data platforms, lakehouses, and pipelines using Microsoft Fabric and complementary cloud technologies such as Databricks, Snowflake, and Azure Data Services<br/><br/>Design and govern medallion lakehouse architectures (Bronze, Silver, Gold) that prioritize scalability, governance, performance, and data quality<br/><br/>Architect parameterized ingestion frameworks supporting batch and near real‑time integrations across databases, APIs, files, streaming platforms, and hybrid environments<br/><br/>Optimize pipeline and query performance through Spark tuning, partitioning strategies, shortcuts, and incremental loading techniques<br/><br/>Design and optimize semantic models, including star schemas, DirectLake and Import strategies, DAX optimization, relationships, and aggregations<br/><br/>Define and implement CI/CD strategies that enable reliable, automated, and scalable deployments across multiple environments<br/><br/>Establish and promote Fabric architecture standards, reusable frameworks, and engineering best practices across engagements<br/><br/>Provide technical leadership and mentorship to Data Engineers, Analysts, and multidisciplinary delivery teams while ensuring architectural alignment<br/><br/>Continuously evaluate emerging technologies and recommend innovative approaches that strengthen client data ecosystems and business capabilities<br/><br/>WHO YOU ARE<br/><br/>You see data architecture as the foundation that enables intelligent organizations rather than simply supporting analytics<br/><br/>You naturally connect business strategy with scalable cloud and data engineering solutions<br/><br/>You are comfortable leading executive conversations while maintaining deep technical credibility with engineering teams<br/><br/>You enjoy designing reusable architectures that balance performance, governance, flexibility, and cost optimization<br/><br/>You mentor others through collaboration and technical leadership rather than authority alone<br/><br/>You thrive in consulting environments where every client challenge requires structured thinking and pragmatic innovation<br/><br/>You continuously explore new technologies and translate emerging capabilities into practical business value<br/><br/>QUALIFICATIONS & CERTIFICATIONS<br/><br/>Bachelors degree in Computer Science, Information Technology, Engineering, or a related field<br/><br/>7+ years of experience in Data Engineering, Cloud Data Platforms, or Modern Data Architecture roles<br/><br/>Minimum 2 years of experience serving as a Data Architect or Technical Lead delivering end‑to‑end solutions<br/><br/>Microsoft Fabric, Azure, Databricks, Snowflake, or cloud architecture certifications are considered an asset<br/><br/>TECHNICAL SKILLS<br/><br/>Deep hands‑on expertise with Microsoft Fabric, including medallion lakehouse architectures, ingestion frameworks, semantic models, and performance optimization<br/><br/>Strong experience with at least one additional modern data platform such as Databricks, Snowflake, or Azure Data Factory<br/><br/>Advanced understanding of data warehouse, lakehouse, and cloud‑native architecture patterns<br/><br/>Experience designing hybrid data integration strategies across on‑premises and cloud environments<br/><br/>Expertise optimizing Spark workloads, partitioning strategies, incremental loading, and scalable data pipelines<br/><br/>Experience designing semantic models using star schema principles, DirectLake, Import strategies, DAX optimization, and aggregations<br/><br/>Experience implementing CI/CD pipelines and deployment automation for enterprise data platforms<br/><br/>Proven ability to present, defend, and guide architectural decisions with senior client stakeholders<br/><br/>Experience working within Agile and Scrum delivery environments<br/><br/>NICE‑TO‑HAVE<br/><br/>Experience leading enterprise‑scale Microsoft Fabric adoption initiatives<br/><br/>Knowledge of Data Governance, Data Quality, and Master Data Management frameworks<br/><br/>Experience with Infrastructure as Code, DevOps, or DataOps methodologies<br/><br/>Exposure to Artificial Intelligence, advanced analytics, or modern cloud‑native data ecosystems<br/><br/>WHAT MAKES YOU SUCCESSFUL<br/><br/>Exceptional communication skills, with the ability to translate complex architectures into clear business conversations<br/><br/>Comfortable facilitating workshops, architecture reviews, and executive presentations<br/><br/>Able to balance technical excellence with business priorities, scalability, and long‑term value creation<br/><br/>Brings a consultative mindset that enables constructive challenge and trusted client partnerships<br/><br/>Demonstrates strong technical leadership while mentoring multidisciplinary delivery teams<br/><br/>Builds credibility through structured thinking, collaboration, and a consistent focus on measurable outcomes<br/><br/>WHAT WE OFFER AT KEYRUS<br/><br/>A stimulating environment where you will be able to surpass yourself and discover new horizons<br/><br/>A strong culture of innovation and entrepreneurship<br/><br/>Opportunities to celebrate success through team activities, social events, and special celebrations<br/><br/>Comprehensive group insurance for you and your family<br/><br/>RRSP and DPSP participation plans<br/><br/>Monthly Wellness Allowance<br/><br/>Telecommunication reimbursement<br/><br/>4 weeks of paid vacation<br/><br/>Language courses (French & English)<br/><br/>Access to continuous learning through certifications, conferences, training programs, and industry events<br/><br/>Base Compensation:<br/><br/>The expected base compensation for this position ranges from $115,000 to $130,000 CAD, depending on experience, skills, location, and internal equity. This salary range is provided as a guideline and may be adjusted for the selected candidate.<br/><br/>#J-18808-Ljbffr
