Senior Consultant - Data & Solution Architect

Keyrus Group; Montreal (administrative region); Hybrid; CAD 115,000 - 130,000; Full time

Benefits offered by this job

Group insurance

RRSP/DPSP plans

Wellness allowance

Telecom reimbursement

Paid vacation

Language courses

Learning opportunities

Job summary

Keyrus Group in Montreal, Canada seeks a Senior Consultant - Data & Solution Architect to design data ecosystems and implement Azure-based platforms, guiding delivery teams to build scalable cloud data solutions.

You will translate business objectives into target architectures, optimize lakehouses and pipelines, mentor engineers, and promote best practices in CI/CD, security, and governance across client projects.

Qualifications

• 7+ years of experience in Data Engineering, Cloud Data Platforms, or Modern Data Architecture roles.
• Deep hands-on expertise with Microsoft Fabric or complementary cloud technologies, including medallion lakehouse architectures, ingestion frameworks, semantic models, and performance optimization.
• Advanced understanding of data warehouse, lakehouse, and cloud-native architecture patterns.
• Experience designing solutions using Azure Integration Services, including Logic Apps, Azure Functions, Service Bus, and/or API Management.
• Strong understanding of enterprise integration patterns across APIs, messaging, event-driven architectures, and cloud services.
• 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 and cloud platforms.

Responsibilities

• 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 or 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.
• Design broader Azure integration architectures connecting data platforms, enterprise applications, APIs, and cloud services using Azure Integration Services such as Logic Apps, Azure Functions, Service Bus, and API Management.
• Define scalable and secure integration patterns across the Azure ecosystem, including API-based, messaging, and event-driven architectures.
• 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.
• 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 and cloud ecosystems and business capabilities.

Skills

Data Engineering

Cloud Data Platforms

Azure Cloud

Medallion Lakehouse

CI/CD

Semantic Models

Spark Optimization

Data Architecture

Tools

Microsoft Fabric

Databricks

Snowflake

Azure Data Services

Logic Apps

Azure Functions

Service Bus

API Management

Job description

Why Keyrus, Why Now!

Keyrusis an international group of2,800 consultantsand experts across28 countries, built on a single conviction:AI does not transform businesses. Architected intelligence does.For more than 30 years, we have been building the data foundations that make intelligent systems work — designing the Operating System of the intelligent enterprise, where intelligence is embedded into the core of business processes to create sustainable value:we operationalise intelligence.

AI does not replace humans. It repositions us to a place no system can follow: understanding, deciding, designing, and creating. At Keyrus, you will not just develop skills—you will develop judgment. Your expertise sharpens with every architecture you design, every platform you modernize, and every client challenge you solve.

Over time, you grow into one of the rarest professionals of the intelligence era: someone who bridges data, cloud, AI, and business decision-making at scale. This is not a role you fill. It is a discipline you master and a story you help write to becomea Keyrus Architect of Intelligence.

Technology amplifies.Keyrus culture differentiates.Industrial discipline connects the two.

Role Details

Location: Hyrbid - Montreal, Canada (2 days per week at the office)

Contract: Permanent, Full-time

WHAT YOU'LL ARCHITECT:

As a Senior Consultant - Data & Solution Architect, you will architect modern data ecosystems that enable organizations to transform raw information into scalable intelligence. Combining deep engineering expertise with broader Azure cloud and solution architecture capabilities, 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 or 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.

• Design broader Azure integration architectures connecting data platforms, enterprise applications, APIs, and cloud services using Azure Integration Services such as Logic Apps, Azure Functions, Service Bus, and API Management.

• Define scalable and secure integration patterns across the Azure ecosystem, including API-based, messaging, and event-driven architectures.

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

• 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 and cloud 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 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:

Technical Skills

• 7+ years of experience in Data Engineering, Cloud Data Platforms, or Modern Data Architecture roles.

• Deep hands-on expertise with Microsoft Fabric or complementary cloud technologies, including medallion lakehouse architectures, ingestion frameworks, semantic models, and performance optimization.

• Advanced understanding of data warehouse, lakehouse, and cloud-native architecture patterns.

• Experience designing solutions using Azure Integration Services, including Logic Apps, Azure Functions, Service Bus, and/or API Management.

• Strong understanding of enterprise integration patterns across APIs, messaging, event-driven architectures, and cloud services.

• 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 and cloud platforms.

Nice-to-haves

• Experience with enterprise platforms such as Workday, Dynamics 365, Business Central, Microsoft Graph, Salesforce, or SAP.

• Exposure to AI, modern data architectures, microservices, or cloud-native application design.

• Microsoft Azure or related architecture certifications.

What Makes You Successful

• You combine technical depth with a consulting mindset, moving comfortably between business conversations and technical design.

• You understand how data, applications, APIs, and cloud services work together within a broader enterprise ecosystem.

• You bring a pragmatic approach to architecture, balancing scalability, security, maintainability, cost, and business value.

• You communicate clearly, challenge constructively, and provide technical leadership to multidisciplinary teams.

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.

ABOUT KEYRUS

At Keyrus, we help organizations move from experimental AI to industrialized AI, from isolated agents to orchestrated systems, and from insight to execution. This is the discipline we call being anArchitect of Intelligence. Designing the Operating System of the intelligent enterprise, where intelligence is embedded into the core of business processes to create sustainable value:we operationalize intelligence.

Powered by our proprietaryHuman Orchestrated Model™ (HOM), we architect reliable:

• Intelligence Foundations

• Human in Command governance

• Performance Steering

To create intelligent environments where technology amplifies human capabilities and performance compounds over time.

With 30+ years of expertise and 2,800 employees across 28 countries, we help organizations go beyond transformation: to build adaptive, resilient, and continuously improving intelligent organizations.

AI does not transform businesses. Architected intelligence does.

Keyrus is listed on Euronext Growth Paris. (ALKEY - ISIN Code: FR0004029411 - Reuters: KEYR.PA - Bloomberg: ALKEY: FP).

For more information: www.keyrus.com