Azure Solutions Consultant

Azure Solutions Consultant is a hybrid full-time role at Ripotek Technologies Inc. in Calgary, AB, Canada, posted 9 Oct 2026.

Role OverviewAs 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 ResponsibilitiesSolution Delivery (65%)Design and implement Azure data architectures (Data Lake, Synapse, Fabric, Databricks)Build production-grade ELT pipelines using Azure Data Factory and DatabricksImplement medallion architecture (Bronze/Silver/Gold layers) with Delta LakeDesign 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 DevOpsTroubleshoot performance issues and optimize pipeline/query performanceCreate technical documentation (architecture diagrams, runbooks, data dictionaries)Provide knowledge transfer to client teamsClient Engagement (25%)Participate in discovery workshops to understand requirementsPresent technical solutions and recommendations to stakeholdersCollaborate with client data teams, architects, and business usersManage client expectations and communicate project statusSupport sales team with technical scoping and estimationGather feedback and iterate on solutionsProfessional Development (10%)Stay current with Azure updates and new service releasesPursue Microsoft certifications (Azure Data Engineer, Solutions Architect)Contribute to internal knowledge sharing (demos, documentation)Mentor junior consultantsParticipate in community events and conferencesExperienceRequired 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 stakeholdersTechnical SkillsAzure Data ServicesData Factory, Data Lake Gen2, Synapse Analytics, DatabricksProgrammingSQL (advanced), Python (intermediate), Scala (nice to have)Data OrchestrationADF pipelines, Databricks workflows, Azure FunctionsData ModelingDimensional modeling, star schema, slowly changing dimensionsVersion ControlGit, Azure Repos, GitHubCi/CdAzure DevOps, GitHub Actions, deployment pipelinesPower BIBasic to intermediate (connecting to data sources, simple reports)Infrastructure As CodeARM 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 technologiesPreferred 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 SectorWhat We OfferCompensation & BenefitsCompetitive salary: $95K-$130K based on experienceAnnual performance bonus (10-15% of salary)RRSP matching (4% of salary)Comprehensive health, dental, and vision benefitsProfessional development budget ($3,500/year)Certification exam fees and training coveredWork EnvironmentHybrid: 2 days/week in Calgary office, 3 days remoteFlexible hours (core hours 10am-3pm MT)Latest MacBook Pro or Surface LaptopHome office setup allowance ($1,500)Downtown Calgary office with collaborative spacesGrowth & DevelopmentWork on diverse projects across industriesMentorship from senior architects and principalsClear career progression (Consultant → Senior Consultant → Architect)Opportunity to specialize (Databricks, Fabric, AI/ML)Exposure to pre-sales and client managementInternal training on new Azure services and best practicesCultureCollaborative, low-ego team environmentDirect impact on client successKnowledge-sharing culture (lunch-and-learns, demos)Supportive of work-life balanceSmall company - your voice mattersInterview Process1Phone Screen (30 min)HR and technical lead2Technical Interview (90 min)Azure architecture and pipeline design questions3Coding Challenge (take-home, 2-3 hours)Build a simple ELT pipeline4Client Scenario (45 min)Present solution to mock client problem5Team Fit (30 min)Meet with team membersTimeline:2-3 weeks from application to offerReady to Build Modern Data Platforms?Join our team and work on cutting-edge Azure solutions for enterprise clients. Show more Show less