Senior Solution Designer

Futran Solutions; Canada; On-site; CAD 140,000 - 190,000; Full time

Job summary

Futran Solutions in Canada is seeking a highly experienced Senior Solution Designer to join our Data & Analytics practice. You will design and deliver enterprise-scale analytics solutions using Microsoft Fabric and Azure Synapse, while leading architecture workshops and coordinating with client business and technology teams.

The role emphasizes consulting, strong communication, and stakeholder engagement, with responsibility for data modernization initiatives and enterprise data platforms.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• 10+ years of experience in Data, Analytics, BI, or Cloud Data Platforms.
• 5+ years in Solution Design, Architecture, or Technical Leadership roles.
• Experience with enterprise clients and senior stakeholders.
• Authorized to work in Canada or the United States.

Responsibilities

• Lead end-to-end solution design for enterprise data and analytics programs.
• Collaborate with client stakeholders to define solution strategies and roadmaps.
• Design scalable data platforms using Microsoft Fabric and Azure Synapse Analytics.
• Facilitate architecture workshops and requirement discovery sessions.
• Translate business requirements into technical designs and implementation plans.
• Provide technical leadership across data engineering, analytics, and reporting.
• Establish best practices for data architecture, governance, security, scalability, and performance.
• Support data modernization and cloud transformation programs.
• Review and guide engineering teams through deployment phases.
• Ensure solutions align with standards, regulatory requirements, and objectives.

Skills

Microsoft Fabric

Azure Synapse Analytics

Data & Analytics Architecture

Stakeholder Engagement

Cloud Data Platforms

Education

Bachelor's degree in Computer Science/Engineering

Tools

Power BI

SQL Server

Azure DevOps

CI/CD

ETL/ELT Frameworks

Data Governance

Job description

We need someone who is technical and consultative in Microsoft Azure technologies. Emphasis on Fabric and Synapse along with Open Lake, Lakehouse, AI Foundry.

The need will be for someone with at least 10+ years of experience with hands-on full stack Microsoft Azure architect who has graduated in terms of experience into providing technical consultancy with very good communications skills. The person should have familiarity with Azure stack including: ADLS 2.0, ADF/ETL tools, understand pipelines, understand how code and models are deployed on Azure and Kubernetes, and be able to develop prototypes.

Position Summary

Seeking a highly experienced Senior Solution Designer based in Canada to join our Data & Analytics practice. The ideal candidate will possess deep expertise in Microsoft Fabric, Azure Synapse Analytics, and modern cloud data platforms, with a proven track record of designing and delivering enterprise-scale analytics solutions.

This is a client-facing role requiring strong consulting, solution design, and stakeholder engagement capabilities. The successful candidate will partner closely with client business and technology teams, providing architecture leadership and helping deliver strategic data modernization initiatives.

Key Responsibilities

• Lead end-to-end solution design for enterprise data and analytics programs.
• Collaborate with client stakeholders, architects, product owners, and engineering teams to define solution strategies and roadmaps.
• Design scalable and secure data platforms using Microsoft Fabric and Azure Synapse Analytics.
• Facilitate architecture workshops, requirement discovery sessions, and solution reviews.
• Translate business requirements into technical designs and implementation plans.
• Provide technical leadership across data engineering, analytics, and reporting initiatives.
• Establish best practices for data architecture, governance, security, scalability, and performance.
• Support enterprise data modernization and cloud transformation programs.
• Review and guide engineering teams throughout implementation and deployment phases.
• Ensure solutions align with enterprise standards, regulatory requirements, and operational objectives.

Required Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• 10+ years of experience in Data, Analytics, Business Intelligence, or Cloud Data Platforms.
• 5+ years in Solution Design, Solution Architecture, or Technical Leadership roles.
• Experience working directly with enterprise clients and senior stakeholders.
• Must be authorized to work in Canada or the United States.

Technical Expertise

Microsoft Fabric

Strong hands-on experience with:

• Fabric Lakehouse
• Data Factory
• Real-Time Analytics
• Semantic Models
• Fabric Security & Governance
• Data Integration and Orchestration

Deep expertise in:

• Dedicated SQL Pools
• Serverless SQL
• Performance Optimization
• Data Warehouse Design

Additional Technologies

• Power BI
• SQL Server
• Data Modeling
• ETL/ELT Frameworks
• Azure DevOps and CI/CD
• Data Governance and Security Frameworks

Preferred Experience

• Enterprise-scale Data Warehouse and Lakehouse implementations.
• Data platform migration and modernization initiatives.
• Multi-cloud or hybrid analytics environments.
• Experience in regulated industries such as Financial Services, Healthcare, Insurance, Retail, or Public Sector.
• Experience mentoring architects, designers, and engineering teams.
• Strong executive-level communication and presentation skills.

Preferred Certifications

• Microsoft Certified: Fabric Analytics Engineer Associate
• Microsoft Certified: Azure Solutions Architect Expert
• TOGAF or equivalent architecture certification (preferred)