Senior Microsoft Fabric Data Engineer

KalSoft is currently looking for a Senior Microsoft Fabric Data Engineer to come and join our team.
The ideal candidate will be based in Canada and bring minimum8 years of overall data engineering experience with strong hands-on expertise in Microsoft Fabric Azure data services and modern analytics tools. This role will focus on developing scalable data pipelines integrating complex data sources optimizing data models and enabling high-quality analytics and reporting solutions.

Responsibilities:

Data Engineering & Architecture

• Design and implement end-to-end data solutions using Microsoft Fabric Azure Data Factory Synapse Data Engineering and related cloud services

• Architect and optimize data ingestion transformation and storage processes for enterprise analytics

• Develop robust data models semantic layers and curated datasets for Power BI and Fabric workloads

Data Integration & Processing

• Integrate data from Azure Data Lake SQL Server APIs SaaS systems and on-premise sources

• Build reusable ETL/ELT pipelines and automated dataflows

• Ensure data accuracy and consistency through validation cleansing and governance standards

Analytics & Reporting Enablement

• Prepare optimized datasets for Power BI reporting and self-service analytics

• Develop advanced DAX models measures and KPIs in collaboration with analytics teams

• Support business stakeholders by translating requirements into scalable technical data solutions

Performance Optimization & Operations

• Monitor and tune pipeline performance capacity usage and refresh cycles

• Troubleshoot data failures performance bottlenecks and reliability issues

• Implement best practices for data security access control and compliance within Microsoft Cloud environments

Documentation & Collaboration

• Prepare architecture documentation data dictionaries and operational runbooks

• Work closely with data analysts business teams and technical stakeholders on high-impact data initiatives

• Provide mentorship knowledge transfer and guidance on data engineering best practices

Skills & Experience Required:

• Canadian residents may apply only

• Min 8 years of experience in data engineering data platform development or cloud data architecture

• Hands-on experience with Microsoft Fabric Azure Data Factory Synapse Dataflows and Azure SQL

• Strong SQL skills and hands-on ETL/ELT development experience

• Experience preparing Power BI datasets semantic models and optimized data structures

• Solid understanding of data governance security and compliance within Microsoft 365/Azure ecosystems

• Experience integrating data from diverse cloud and on-premise sources

At least one of the following Microsoft certifications is required:

• Microsoft Certified: Fabric Data Engineer Associate

• Microsoft Certified: Fabric Analytics Engineer Associate

• Microsoft Certified: Data Analyst Associate

• Microsoft Certified: Azure Database Administrator Associate

• Microsoft Certified: Azure Data Scientist Associate

• Microsoft Certified: Azure AI Engineer Associate

Soft Skills:

• Strong analytical and problem-solving skills

• Excellent communication and stakeholder engagement abilities

• Ability to work independently and collaborate effectively across teams

About KalSoft

Founded in 1999 KalSoft is a multi-award-winning trusted technology partner in business innovation delivering impactful business results to clients throughout digital modernisation and evolution. As a Microsoft Solutions Partner and a Solutions Integrator (SI) KalSoft has a well-established international presence in seven countries and maintains a network of front offices and local business operations serving North America Asia Africa and the Middle East to help meet the needs of our customers and partners.