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.
