Senior Consultant - Data & Solution Architect

Keyrus Canada • Montreal, QC

104d • CA$115,000 - CA$130,000 • Hybrid

About The Position

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.

Requirements

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

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.

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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed