Senior Consultant - Data & Solution Architect (Fabric)

Keyrus Canada

• $115K — $130K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field
  • 7+ years in Data Engineering, Cloud Data Platforms, or Modern Data Architecture roles
  • 2+ years as a Data Architect or Technical Lead delivering end-to-end solutions
  • Familiarity with Microsoft Fabric, Azure, Databricks, Snowflake, or related cloud architecture certifications is a plus
  • Hands-on expertise with modern data ecosystem components, including ingestion frameworks and performance optimization

Responsibilities

  • Collaborate with stakeholders to design scalable target-state data architectures
  • Architect end-to-end data platforms and lakehouses using Microsoft Fabric and cloud tech
  • Design medallion lakehouse architectures prioritizing scalability and data quality
  • Create ingestion frameworks for batch and real-time integration across various environments
  • Optimize pipeline performance through advanced Spark and loading techniques
  • Define CI/CD strategies for reliable and automated deployments
  • Mentor delivery teams while ensuring architectural alignment

Benefits

  • Stimulating work environment with opportunities for personal growth
  • Culture that fosters innovation and entrepreneurship
  • Team activities and social events to celebrate achievements
  • Comprehensive group insurance for you and family
  • RRSP and DPSP participation options
  • Monthly wellness allowance and telecommunication reimbursement
  • Four weeks of paid vacation
  • Language courses available in French and English
  • Access to continuous learning opportunities and industry events
Full Job Description
Role Details

📍 Location: Hyrbid - Toronto or Montreal, Canada (2 days per week at the office)
đź’Ľ Contract: Permanent, Full-time

WHAT YOU'LL ARCHITECT:

As a Senior Consultant Data & Solution Architect (Microsoft Fabric), you will architect modern data ecosystems that enable organizations to transform raw information into scalable intelligence. Combining deep engineering expertise with consulting leadership, you will define target-state architectures, guide delivery teams, and help clients build cloud-native data platforms designed for long-term business impact.
  • 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

WHAT YOU BRING:

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-haves
  • 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

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.

Department Operations Locations Montréal, Toronto Remote status Hybrid

Similar Jobs

More Jobs at Keyrus Canada

More Information Technology Jobs

Find similar Senior Consultant - Data & Solution Architect (Fabric) jobs: