Azure Solutions Consultant

Consulting Department

Location

Calgary, AB (Hybrid - 2 days/week)

Employment Type

Full-Time

Back to Careers

Role Overview

As an Azure Solutions Consultant, you'll design and implement modern data platforms on Azure for enterprise clients. You'll build end-to-end data pipelines, implement lakehouses, and create governed analytics solutions using Azure Data Factory, Databricks, Synapse, and Microsoft Fabric. This is a hands-on technical role with client-facing responsibilities.

Key Responsibilities

Solution Delivery (65%)

  • •Design and implement Azure data architectures (Data Lake, Synapse, Fabric, Databricks)
  • •Build production-grade ELT pipelines using Azure Data Factory and Databricks
  • •Implement medallion architecture (Bronze/Silver/Gold layers) with Delta Lake
  • •Design and optimize data models (star schema, dimensional modeling)
  • •Configure security, access controls, and data governance (Azure Purview)
  • •Implement CI/CD pipelines for data workflows using Azure DevOps
  • •Troubleshoot performance issues and optimize pipeline/query performance
  • •Create technical documentation (architecture diagrams, runbooks, data dictionaries)
  • •Provide knowledge transfer to client teams

Client Engagement (25%)

  • •Participate in discovery workshops to understand requirements
  • •Present technical solutions and recommendations to stakeholders
  • •Collaborate with client data teams, architects, and business users
  • •Manage client expectations and communicate project status
  • •Support sales team with technical scoping and estimation
  • •Gather feedback and iterate on solutions

Professional Development (10%)

  • •Stay current with Azure updates and new service releases
  • •Pursue Microsoft certifications (Azure Data Engineer, Solutions Architect)
  • •Contribute to internal knowledge sharing (demos, documentation)
  • •Mentor junior consultants
  • •Participate in community events and conferences

Required Qualifications

Experience

  • 4+ years in data engineering, cloud engineering, or BI development
  • 2+ years hands-on experience with Azure data services
  • Delivered 3+ end-to-end data platform implementations
  • Experience with both on-premises and cloud data technologies
  • Track record of working directly with clients or business stakeholders

Technical Skills

Azure Data Services:

Data Factory, Data Lake Gen2, Synapse Analytics, Databricks

Programming:

SQL (advanced), Python (intermediate), Scala (nice to have)

Data Orchestration:

ADF pipelines, Databricks workflows, Azure Functions

Data Modeling:

Dimensional modeling, star schema, slowly changing dimensions

Version Control:

Git, Azure Repos, GitHub

CI/CD:

Azure DevOps, GitHub Actions, deployment pipelines

Power BI:

Basic to intermediate (connecting to data sources, simple reports)

Infrastructure as Code:

ARM templates, Terraform, or Bicep (nice to have)

Soft Skills

  • Strong communication skills (technical and non-technical audiences)
  • Problem-solving mindset and troubleshooting abilities
  • Self-directed and able to manage multiple priorities
  • Comfortable with ambiguity and changing requirements
  • Team player with collaborative approach
  • Eagerness to learn and adapt to new technologies

Preferred Qualifications

  • ✓Microsoft Certified: Azure Data Engineer Associate (DP-203)
  • ✓Microsoft Certified: Azure Solutions Architect Expert
  • ✓Databricks Certified Data Engineer Associate
  • ✓Experience with Microsoft Fabric (OneLake, Data Factory, Synapse)
  • ✓Knowledge of data governance tools (Azure Purview, Collibra)
  • ✓Familiarity with streaming data (Event Hubs, Stream Analytics, Kafka)
  • ✓Previous consulting or professional services experience
  • ✓Domain expertise in Energy, Finance, or Public Sector

What We Offer

Compensation & Benefits

  • •Competitive salary: $95K-$130K based on experience
  • •Annual performance bonus (10-15% of salary)
  • •RRSP matching (4% of salary)
  • •Comprehensive health, dental, and vision benefits
  • •Professional development budget ($3,500/year)
  • •Certification exam fees and training covered

Work Environment

  • •Hybrid: 2 days/week in Calgary office, 3 days remote
  • •Flexible hours (core hours 10am-3pm MT)
  • •Latest MacBook Pro or Surface Laptop
  • •Home office setup allowance ($1,500)
  • •Downtown Calgary office with collaborative spaces

Growth & Development

  • •Work on diverse projects across industries
  • •Mentorship from senior architects and principals
  • •Clear career progression (Consultant → Senior Consultant → Architect)
  • •Opportunity to specialize (Databricks, Fabric, AI/ML)
  • •Exposure to pre-sales and client management
  • •Internal training on new Azure services and best practices

Culture

  • •Collaborative, low-ego team environment
  • •Direct impact on client success
  • •Knowledge-sharing culture (lunch-and-learns, demos)
  • •Supportive of work-life balance
  • •Small company - your voice matters

Interview Process

1

Phone Screen (30 min)

HR and technical lead

2

Technical Interview (90 min)

Azure architecture and pipeline design questions

3

Coding Challenge (take-home, 2-3 hours)

Build a simple ELT pipeline

4

Client Scenario (45 min)

Present solution to mock client problem

5

Team Fit (30 min)

Meet with team members

Timeline:2-3 weeks from application to offer

Ready to Build Modern Data Platforms?

Join our team and work on cutting-edge Azure solutions for enterprise clients.