Senior Consultant - Data & Solution Architect (Fabric)

Senior Consultant Data & Solution Architect (Microsoft Fabric)

Role Details

Location: Hybrid – Toronto or Montreal, Canada (2 days per week at the office)

Contract: Permanent, Full-time

What You'll Architect

• Collaborate with client stakeholders to translate business objectives into scalable target‑state data architectures and strategic roadmaps
• Architect end‑to‑end data platforms, lakehouses, and pipelines using Microsoft Fabric and complementary cloud technologies such as Databricks, Snowflake, and Azure Data Services
• Design and govern medallion lakehouse architectures (Bronze, Silver, Gold) that prioritize scalability, governance, performance, and data quality
• Architect parameterized ingestion frameworks supporting batch and near real‑time integrations across databases, APIs, files, streaming platforms, and hybrid environments
• Optimize pipeline and query performance through Spark tuning, partitioning strategies, shortcuts, and incremental loading techniques
• Design and optimize semantic models, including star schemas, DirectLake and Import strategies, DAX optimization, relationships, and aggregations
• Define and implement CI/CD strategies that enable reliable, automated, and scalable deployments across multiple environments
• Establish and promote Fabric architecture standards, reusable frameworks, and engineering best practices across engagements
• Provide technical leadership and mentorship to Data Engineers, Analysts, and multidisciplinary delivery teams while ensuring architectural alignment
• Continuously evaluate emerging technologies and recommend innovative approaches that strengthen client data ecosystems and business capabilities

WHO YOU ARE

• You see data architecture as the foundation that enables intelligent organizations rather than simply supporting analytics
• You naturally connect business strategy with scalable cloud and data engineering solutions
• You are comfortable leading executive conversations while maintaining deep technical credibility with engineering teams
• You enjoy designing reusable architectures that balance performance, governance, flexibility, and cost optimization
• You mentor others through collaboration and technical leadership rather than authority alone
• You thrive in consulting environments where every client challenge requires structured thinking and pragmatic innovation
• You continuously explore new technologies and translate emerging capabilities into practical business value

QUALIFICATIONS & CERTIFICATIONS

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field
• 7+ years of experience in Data Engineering, Cloud Data Platforms, or Modern Data Architecture roles
• Minimum 2 years of experience serving as a Data Architect or Technical Lead delivering end‑to‑end solutions
• Microsoft Fabric, Azure, Databricks, Snowflake, or cloud architecture certifications are considered an asset

TECHNICAL SKILLS

• Deep hands‑on expertise with Microsoft Fabric, including medallion lakehouse architectures, ingestion frameworks, semantic models, and performance optimization
• Strong experience with at least one additional modern data platform such as Databricks, Snowflake, or Azure Data Factory
• Advanced understanding of data warehouse, lakehouse, and cloud‑native architecture patterns
• Experience designing hybrid data integration strategies across on‑premises and cloud environments
• Expertise optimizing Spark workloads, partitioning strategies, incremental loading, and scalable data pipelines
• Experience designing semantic models using star schema principles, DirectLake, Import strategies, DAX optimization, and aggregations
• Experience implementing CI/CD pipelines and deployment automation for enterprise data platforms
• Proven ability to present, defend, and guide architectural decisions with senior client stakeholders
• Experience working within Agile and Scrum delivery environments

NICE‑TO‑HAVE

• Experience leading enterprise‑scale Microsoft Fabric adoption initiatives
• Knowledge of Data Governance, Data Quality, and Master Data Management frameworks
• Experience with Infrastructure as Code, DevOps, or DataOps methodologies
• Exposure to Artificial Intelligence, advanced analytics, or modern cloud‑native data ecosystems

WHAT MAKES YOU SUCCESSFUL

• Exceptional communication skills, with the ability to translate complex architectures into clear business conversations
• Comfortable facilitating workshops, architecture reviews, and executive presentations
• Able to balance technical excellence with business priorities, scalability, and long‑term value creation
• Brings a consultative mindset that enables constructive challenge and trusted client partnerships
• Demonstrates strong technical leadership while mentoring multidisciplinary delivery teams
• Builds credibility through structured thinking, collaboration, and a consistent focus on measurable outcomes

WHAT WE OFFER AT KEYRUS

• A stimulating environment where you will be able to surpass yourself and discover new horizons
• A strong culture of innovation and entrepreneurship
• Opportunities to celebrate success through team activities, social events, and special celebrations
• Comprehensive group insurance for you and your family
• RRSP and DPSP participation plans
• Monthly Wellness Allowance
• Telecommunication reimbursement
• 4 weeks of paid vacation
• Language courses (French & English)
• Access to continuous learning through certifications, conferences, training programs, and industry events

Base Compensation: 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.

#J-18808-Ljbffr