Azure Solutions Consultant

Role overview

Solution delivery

• Design Azure data architectures using Data Lake, Synapse, Fabric, and Databricks; build production ELT pipelines.
• Implement medallion architecture with Delta Lake; design and optimize star-schema and dimensional data models.
• Configure security, access controls, and governance; implement CI/CD for data workflows.
• Troubleshoot and optimize pipeline and query performance; create architecture diagrams, runbooks, and data dictionaries.
• Provide client-team knowledge transfer.

Client engagement and development

• Run discovery workshops, present technical recommendations, collaborate with client teams, manage expectations, and communicate project status.
• Support sales scoping and estimation; gather feedback and iterate on solutions.
• Stay current with Azure services, pursue certifications, share knowledge, mentor junior consultants, and participate in community events.

Required experience

• At least 4 years in data engineering, cloud engineering, or BI development and 2 years hands-on with Azure data services.
• Delivered at least 3 end-to-end data platform implementations; experience with on-premises and cloud technologies.
• Direct client or business-stakeholder experience.

Technical skills

• Azure Data Factory, Data Lake Gen2, Synapse Analytics, Databricks, Azure Functions, and Databricks workflows.
• Advanced SQL, intermediate Python, data modeling, Git, Azure Repos or GitHub, Azure DevOps, and CI/CD.
• Basic-to-intermediate Power BI; Scala is nice to have.
• ARM templates, Terraform, or Bicep are nice to have.

Preferred qualifications

• Preferred certifications include Microsoft Azure Data Engineer Associate (DP-203), Microsoft Azure Solutions Architect Expert, and Databricks Certified Data Engineer Associate.
• Preferred experience includes Microsoft Fabric, governance tools such as Azure Purview or Collibra, streaming tools such as Event Hubs, Stream Analytics, or Kafka, and consulting services.
• Energy, finance, or public-sector expertise is preferred.
• Strong communication, troubleshooting, self-direction, prioritization, adaptability, and teamwork are expected.

Compensation and benefits

• Salary is CAD 95,000–130,000 based on experience, with an annual performance bonus of 10–15% of salary.
• Benefits include RRSP matching, health, dental and vision coverage, a professional-development budget, and covered certification fees and training.

Work environment

• Hybrid schedule: 2 days per week in the Calgary office and 3 days remote.
• Flexible hours with core hours from 10 a.m. to 3 p.m. Mountain Time; home-office allowance and equipment are provided.

Interview process