Senior Solution Designer

Position: Senior Solution Designer

Location: Remote

Duration: 12 months

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
• Data Engineering
• Real-Time Analytics
• Semantic Models
• Fabric Security & Governance
• Data Integration and Orchestration

Azure Synapse Analytics

Deep expertise in:

• Dedicated SQL Pools
• Serverless SQL
• Apache Spark Pools
• Synapse Pipelines
• Performance Optimization
• Data Warehouse Design

Additional Technologies

• Azure Data Lake Storage Gen2 (ADLS)
• Azure Data Factory (ADF)
• 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 Data Engineer Associate
• Microsoft Certified: Azure Solutions Architect Expert
• TOGAF or equivalent architecture certification (preferred)

Key Competencies

• Enterprise Solution Architecture
• Customer and Stakeholder Management
• Strategic Consulting
• Technical Leadership
• Architecture Governance
• Problem Solving and Decision Making
• Executive Communication
• Cross-functional Collaboration