Azure Solutions Consultant

Calgary, AB
Hybrid
Posted Oct 9, 2026
1 position

$95,000–$130,000 / year

Opens an external site

Employment type: Full-time
Experience level: Mid-level · 4+ years
Minimum education: Professional degree
Posting language: English
Working hours: 40 hours per week
Office presence: 2 days per week
Seniority: Mid-Senior level

Job summary

Design and deliver Azure-based data platforms, including end-to-end ELT pipelines, lakehouses, governed analytics, data models, and CI/CD workflows. Lead client discovery and technical discussions, troubleshoot and optimize solutions, document architectures, and support knowledge transfer.

Job details

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 Experience Required Qualifications 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.

What you’ll do

Requirements

Requires 4+ years of experience in data engineering, cloud engineering, or BI development, including 2+ years hands-on with Azure data services and delivery of at least three end-to-end data platform implementations. Candidates should have advanced SQL, intermediate Python, experience with client or business stakeholders, and strong communication and problem-solving skills; relevant Microsoft or Databricks certifications are preferred.