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 robust 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

📌 Senior Consultant - Data & Solution Architect (Fabric) (Ontario)
🏢 Keyrus
📍 Ontario