Senior Microsoft Data Engineer

Iteration Insights; Calgary; On-site; CAD 140,000 - 150,000; Full time

Job summary

A technology consulting firm in Calgary is seeking a Senior Microsoft Data Engineer to design and optimize cloud-based data solutions. The ideal candidate will have over 5 years of experience in data engineering, strong skills in Python and SQL, and proficiency in Microsoft Fabric and Azure Synapse. This full-time position requires collaboration with cross-functional teams to drive analytics adoption.

Benefits

Impactful, high-visibility projects

Continuous learning and career growth

Collaboration with data experts

Qualifications

• 5+ years of experience in data engineering, with a focus on cloud-based solutions.
• Proficiency in Microsoft Fabric, and Azure Synapse.
• Strong SQL and Python skills for data transformation and analysis.
• Excellent communication skills with the ability to present technical concepts to non-technical audiences.

Responsibilities

• Develop and optimize data pipelines using Microsoft Fabric and Azure Synapse.
• Design scalable architectures for structured and unstructured data.
• Implement ETL / ELT processes, ensuring data quality, integrity, and security.
• Collaborate with business stakeholders to translate requirements into technical solutions.
• Build dashboards and reports using Power BI to enable data-driven decision-making.

Skills

Python programming

SQL

Data warehousing

Data modeling

ETL/ELT processes

Microsoft Fabric

Azure Synapse

Tools

Power BI

Azure SQL Database

REST APIs

Job description

We are hiring for a specific client role that is 100% on-site in downtown Calgary.

About Iteration Insights

At Iteration Insights, we empower businesses with data, providing the tools, knowledge, and support needed to make informed, data-driven decisions. We value lifelong learning, collaboration, and first-class service, fostering a culture of innovation and thought leadership.

The Role

As a Senior Microsoft Data Engineer, you will design, develop, and optimize modern cloud-based data solutions, transforming raw data into actionable insights. Working closely with cross-functional teams and clients, you will build scalable architectures, automate data pipelines, and drive enterprise-wide analytics adoption.

Key Responsibilities

• Develop and optimize data pipelines using Microsoft Fabric, and Azure Synapse
• Design scalable architectures for structured and unstructured data.
• Implement ETL / ELT processes, ensuring data quality, integrity, and security.
• Collaborate with business stakeholders to translate requirements into technical solutions.
• Build dashboards and reports using Power BI to enable data-driven decision-making.
• Stay current with industry trends and emerging data technologies.

General Qualifications for Iteration Insights

5+ years of experience in data engineering, with a focus on cloud-based solutions.

Proficiency in Microsoft Fabric, and Azure Synapse

Strong SQL and Python skills for data transformation and analysis.

Hands-on experience with data integration, modeling, and visualization.

Experience with Modern Data Warehouse, Data Lakehouse, Data Fabric, and / or Data Mesh.

Familiar with Kimball design.

Excellent communication skills with the ability to present technical concepts to non-technical audiences.

Must have

Good experience with Python programming language

Data warehousing and modeling experience

ETL / ELT process

Experience with writing complex SQL queries

Experience with REST APIs

Highly desired

PowerBI Models and reports

Report Builder

PowerQuery

Dax and M Languages

Some experience with R programming language

Experience designing cloud-based solutions in Azure by creating Azure SQL database, setting up Elastic pool jobs and design tabular models in Azure analysis services

Nice to have

Power Apps

Power Automate

Why Join Us?

Work on impactful, high-visibility projects with leading organizations.

Be part of a culture that values continuous learning and career growth.

Collaborate with a team of data experts dedicated to driving business transformation.

Interested? Apply today and help shape the future of data-driven decision-making!

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

Industries

IT Services and IT Consulting

Referrals increase your chances of interviewing at Iteration Insights by 2x

Get notified about new Senior Data Engineer jobs in Calgary, Alberta, Canada .

Calgary, Alberta, Canada CA$140,000.00-CA$150,000.00 7 hours ago

Senior Software & AI Engineer, Digital Business Platforms, Web Experience Group

Python and Kubernetes Software Engineer - Data, AI / ML & Analytics

Senior Software Engineer - Digital Workplace

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

J-18808-Ljbffr