Senior Consultant - Data & Solution Architect

Keyrus Canada

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

Qualifications

  • 7+ years of experience in Data Engineering, Cloud Data Platforms, or Modern Data Architecture roles.
  • Hands-on expertise with Microsoft Fabric and complementary cloud technologies.
  • Advanced understanding of data warehouse, lakehouse, and cloud-native architecture patterns.
  • Experience with Azure Integration Services including Logic Apps and Azure Functions.
  • Strong integration knowledge across APIs, messaging, and event-driven architectures.
  • Expertise in optimizing Spark workloads and scalable data pipelines.
  • Experience implementing CI/CD pipelines for enterprise data platforms.

Responsibilities

  • Collaborate with clients to create scalable data architectures.
  • Architect end-to-end data platforms using Microsoft Fabric or similar technologies.
  • Design and govern medallion lakehouse architectures to ensure performance and quality.
  • Create ingestion frameworks for batch and real-time data integrations.
  • Design integration architectures across data platforms and applications.
  • Define scalable integration patterns using the Azure ecosystem.
  • Optimize data pipeline and query performance through various techniques.

Benefits

  • Stimulating environment for professional growth.
  • Strong culture of innovation and entrepreneurship.
  • Team-building activities and social events.
  • Comprehensive group insurance for employees and families.
  • Retirement savings plan participation.
  • Monthly wellness allowance.
  • Telecommunication reimbursement.
  • 4 weeks of paid vacation.
  • Language courses in French and English available.
  • Access to continuous learning opportunities including certifications and training.
Full Job Description
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.

Department Operations Locations Montréal Remote status Hybrid

Similar Jobs

More Jobs at Keyrus Canada

More Information Technology Jobs

Find similar Senior Consultant - Data & Solution Architect jobs: