Azure Solutions Consultant
- Calgary, AB, Canada
Competitive salary: $95K-$130K based on experience · Full-time
Applications open in a new tab.
Job details
- Pay
- Competitive salary: $95K-$130K based on experience
- Job type
- Full-time
- Apply by
- Experience
- 2+ years hands-on experience with Azure data services
- Posting language
- English
- Posted
Original job description
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%)
Required Qualifications
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
Compensation & Benefits
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.
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
- 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
- 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
- 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
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
- ✓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
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
- 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
- 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
- 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
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.
More about this job
Responsibilities
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.
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.
Skills
- Azure Data Factory
- Azure Data Lake Gen2
- Azure Synapse Analytics
- Azure Databricks
- Microsoft Fabric
- SQL
- Python
- Data Modeling
- Dimensional Modeling
- Delta Lake
- Azure DevOps
- CI/CD
- Data Governance
- Power BI
- Terraform
- Client Engagement
Benefits
- Annual Performance Bonus
- RRSP Matching
- Health Benefits
- Dental Benefits
- Vision Benefits
- Professional Development Budget
- Certification Exam Fees and Training
- Flexible Hours
- Home Office Setup Allowance
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Consulting
Keywords
- Azure Data Factory
- Azure Data Lake Gen2
- Azure Synapse Analytics
- Azure Databricks
- Microsoft Fabric
- OneLake
- Delta Lake
- Medallion Architecture
- ELT Pipelines
- SQL
- Python
- Scala
- Dimensional Modeling
- Star Schema
- Slowly Changing Dimensions
- Azure DevOps
- GitHub Actions
- CI/CD
- Azure Purview
- Collibra
- Power BI
- Terraform
- ARM Templates
- Bicep
- Event Hubs
- Stream Analytics
- Kafka
- Azure Data Engineer Associate
- Databricks Certified Data Engineer Associate