Senior Consultant - Data & Solution Architect (Fabric)
About The Position
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
Requirements
- 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
- 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
- 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
Nice To Haves
- Microsoft Fabric, Azure, Databricks, Snowflake, or cloud architecture certifications are considered an asset
- 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
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 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
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
