Data Engineer - Contractor

LGS, an IBM Company; Mississauga; Hybrid; CAD 100,000 - 120,000; Full time

Benefits offered by this job

Group insurance bundle

Retirement savings plan with employer’s contribution

Access to IBM shares at discounted rates

Annual vacations and additional days off

Job summary

An innovative technology firm in Mississauga is seeking a Senior Data Engineer to design and build scalable data pipelines within Microsoft Fabric. This role contributes to major digital transformation projects, ensuring data products are AI-ready and governed. The ideal candidate has over 10 years of experience, strong skills in various data engineering tools, and a proven track record in building production-grade data solutions. Join a diverse team that values professional growth and innovation in a hybrid work environment.

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 and ERP systems.
• Experience with real-time data integration.
• Proven track record of building and maintaining production-grade data pipelines at scale.

Responsibilities

• Design, build, and maintain efficient ETL/ELT pipelines in Microsoft Fabric.
• Engineer standardized data products focused on quality and reusability.
• Implement automation patterns that accelerate data product creation.
• Develop semantic models and data warehouse structures for analytics.
• Ensure compliance with data governance and quality standards.
• Optimize pipelines for performance and reliability in production.
• Stay current with features in Microsoft Fabric and data engineering practices.

Skills

Microsoft Fabric

Data Factory

Power BI

Data Lakehouse architectures

Advanced SQL

Python

Java

C#

KQL

PowerShell scripting

Job description

At LGS, we strive to provide a workplace that values your professional growth. Our company culture fosters diversity and inclusivity, and we welcome talents from both local and international backgrounds.

As a team member, you will play a crucial role in driving major projects that propel our clients’ businesses forward and improve people’s lives. You will be at the heart of collaborative large-scale digital transformation projects in both the public and private sectors.

The IBM Client Innovation Centre Quebec (CIC), at LGS, employs professionals who collaborate on projects within technology practices, offering local and remote services. Our employees, regardless of their level of experience, are paired with a coach to support their professional growth. As part of IBM’s global network, we have offices in Montreal and Quebec City.

Benefits of Joining Our Team

• Learn every day: access IBM's intellectual capital and trainings on a diverse range of cutting‑edge technologies.
• For your well‑being: a group insurance bundle including telemedicine, a retirement savings plan with employer’s contribution, access to IBM shares at discounted rates, and a wellness package!
• To enjoy quality time: annual vacations, additional company days off and special life events leaves!
• To have fun with your colleagues: an active community and a social committee with regular activities to keep us all connected!

Location

Multiple locations including many in Quebec as well as in Mississauga, Ont. We are somewhat flexible on location.

Start Date

January 2026

Length of Term

6 months with many possibilities to renew

Work Schedule

40 hours a week

Work Mode

Hybrid (3 days onsite mandatory)

The client is seeking a Senior Data Engineer to design, build, and optimize scalable data pipelines and data products within our Microsoft Fabric ecosystem. This role will ensure data products are standardized, governed, and AI‑ready, serving as the backbone of the client’s 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.

Requirements and 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 and ERP systems.
• Experience with real‑time data integration.
• Advanced SQL, Python, Java, C#, KQL, PowerShell script 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.

Be yourself at LGS

LGS is committed to considering all qualified applicants without regard to ethnicity, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, neurodiversity, age, veteran status or other characteristics.

If you are not a Canadian permanent resident or citizen, please consult with your talent acquisition consultant as this role may require the use of technologies that are regulated by export sanctions.