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 recent 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) (Toronto)
🏢 Keyrus
📍 Toronto