Senior Data Engineers (x2) - Microsoft Fabric

Software International; Montreal; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A leading software consulting firm is seeking two Senior Data Engineers to design and optimize data pipelines within Microsoft Fabric. The ideal candidates will have over 10 years of experience and strong expertise in data integration and analytics. This hybrid role requires collaboration with business teams to deliver production-ready data solutions. Competitive hourly rates and an appealing work environment are offered for this contract position based in either Montreal or Mississauga.

Qualifications

• 10+ years of experience as a Data Engineer, BI Engineer, or similar role.
• Strong expertise in Microsoft Fabric and data architectures.
• Advanced skills in SQL, Python, Java, and C#.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines in Microsoft Fabric.
• Engineer standardized data products focused on quality and reusability.
• Collaborate on automation patterns to enhance data product creation.

Skills

Microsoft Fabric

Data Factory

Power BI

Data Lakehouse architectures

SQL

Python

Java

C#

KQL

PowerShell scripts

Job description

About the job Senior Data Engineers (x2) - Microsoft Fabric

Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid‑sized organizations in Canada/US and Europe.

We currently have an long‑term contract role as a Senior Data Engineers (x2) - Microsoft Fabric with our global SAP consulting client, working at a large CPG client's locations either in Montreal or Mississauga. This is a hybrid role with some weekly in‑office visits (2 days onsite).

Type: Contract

Duration: 6 months to start + 6 month extensions

Rate: C2C - open based on overall experience (target range is about $60-90/hr)

Language Requirements: English (French is a nice to have)

Location: Hybrid - Montreal or Mississauga

Role Summary

Our consulting client is seeking 2Senior Data Engineers to design, build, and optimize scalable data pipelines and data products within our Microsoft Fabric and SAP BW ecosystem. This role will ensure data products are standardized, governed, and AI‑ready, serving as the backbone of clients' Data Product Foundation. The Senior Data Engineer will collaborate with architects, automation leads, and business teams to deliver high‑quality, production‑ready data solutions.

Key Responsibilities

• Pipeline Development: Design, build, and maintain efficient, reusable, and scalable ETL/ELT pipelines in Microsoft Fabric, integrating data from SAP BW and other enterprise sources.
• Data Product Engineering: Engineer standardized data products with strong focus on quality, discoverability, and reusability.
• Automation Collaboration: Implement automation patterns and frameworks that accelerate data product creation.
• Data Modeling: Develop and optimize semantic models, star schemas, and data warehouse structures to support reporting and analytics.
• Governance & Quality: Ensure compliance with data governance, lineage, and quality standards; implement observability and monitoring for pipelines.
• Performance Optimization: Troubleshoot and optimize pipelines, ensuring high performance and reliability in production environments.
• Continuous Improvement: Stay current with new features in Microsoft Fabric, SAP integration methods, and modern data engineering practices.

Qualifications

• 10+ years of experience as a Data Engineer, BI Engineer, or similar role.
• Strong expertise in Microsoft Fabric, Data Factory, Power BI, and Data Lakehouse architectures.
• Experience integrating and transforming data from SAP BW and ERP systems.
• Experience with real‑time data integration.
• Advanced SQL, Python, Java, C#, KQL, PowerShell scripts skills for data engineering and automation.
• Proven track record of building and maintaining production‑grade data pipelines at scale.
• Familiarity with data governance, lineage, observability, and DataOps for data.
• Strong collaboration skills, with ability to work across technical and business teams.
• Experience in performance tuning and optimization of large‑scale data systems.