Senior Solution Designer

SRA Group; Canada; On-site; CAD 110,000 - 160,000; Full time

Job summary

The SRA Group is seeking a Senior Solution Designer in Canada to lead end-to-end data & analytics solutions. You will architect scalable platforms using Microsoft Fabric and Azure Synapse Analytics, while guiding stakeholders and engineering teams through modern cloud transformations.

You will work with enterprise clients, provide architecture leadership, and help deliver strategic data modernization initiatives across regulated industries.

Qualifications

• 10+ years in Data/Analytics/BI or Cloud Data Platforms
• 5+ years in Solution Design, Architecture, or Technical Leadership
• 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, 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 data modernization and cloud transformation programs.
• Review and guide engineering teams throughout implementation and deployment phases.
• Ensure solutions align with enterprise standards and regulatory requirements

Skills

Solution design

Data & analytics

Cloud data platforms

Microsoft Fabric

Azure Synapse Analytics

Stakeholder engagement

Architectural leadership

Education

Bachelor's degree in CS/Engineering/IS

Tools

Power BI

SQL Server

Azure DevOps

CI/CD

Data Modeling

ETL/ELT frameworks

Data governance & security

Job description

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)
• Customer and Stakeholder Management
• Strategic Consulting
• Technical Leadership
• Problem Solving and Decision Making
• Executive Communication
• Cross-functional Collaboration

Artificial Intelligence (AI) maybe used in the hiring process used by SRA Group and/or the end client