Azure Solutions Consultant

• Mentor junior consultants

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 optimise data models (star schema, dimensional modelling)
• Configure security, access controls, and data governance (Azure Purview)
• Implement CI/CD pipelines for data workflows using Azure DevOps
• Troubleshoot performance issues and optimise 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

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 modelling, 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 to Senior Consultant to 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