Data Engineer

The Organization

LGM is a national leader in providing warranty, finance and insurance services to the Canadian automotive industry. Since 1998, LGM has partnered with leading automotive manufacturers and dealerships across Canada to deliver award-winning F&I solutions. Dealer partnerships are complemented with the strong backing and support of their automotive manufacturing brands, which include BMW/MINI, Kia, Mazda, Volvo, Jaguar/Land Rover, Mitsubishi Motors, Polestar and Motorrad.  

The Job

The Data Engineer will play a key role in modernizing and scaling LGM’s data platform using Microsoft Fabric and Azure within our Business Intelligence team.

Key Responsibilities

This role provides an opportunity to actively shape how data engineering is practiced at LGM:

• Designing and operating resilient data pipelines (batch and near real-time) across cloud and on-premises systems

• Implementing modern Lakehouse and warehouse patterns using Medallion architecture

• Building scalable dimensional models that support enterprise reporting and self-service analytics

• Optimizing SQL performance across relational platforms including SQL Server, Azure SQL, and Fabric Warehouse

• Publishing curated datasets and semantic models to enable high-performing Power BI reporting

• Supporting migration from legacy reporting solutions and promoting analytics best practices

• Partnering with business and technology teams to ensure data is trusted, governed, and secure

• Troubleshooting and resolving production issues with strong ownership and responsiveness

• 3+ years of experience building and maintaining data warehouses and ETL/ELT pipelines

• Strong SQL skills including performance tuning and optimization

• Experience with Microsoft Fabric and/or Azure data services such as OneLake, Lakehouse/Warehouse, Data Pipelines, Dataflows Gen2, and Notebooks/Spark

• Experience designing dimensional models including star schemas, conformed dimensions, and fact tables

• Familiarity with Power BI semantic modeling and governance best practices

• Strong problem-solving skills and a focus on building scalable, maintainable solutions

• Experience migrating from legacy reporting environments such as SSRS is considered an asset

• Opportunity to work with modern Microsoft data architecture

• Ability to build reusable data products rather than one-off pipelines

• Influence on data governance and enterprise data standards

• Collaboration with a growing and forward-looking data team

• Direct impact on business insight and performance

Compensation Range: 

$100,000-$118,000 per year base plus Corporate Variable Pay (LGM's variable bonus pay program).

Why LGM

• Hybrid work model (2 days in the office)

• Comprehensive compensation package including:

  • Extended health benefits plan

  • Group RRSP

  • Performance bonus

  • Health & wellness benefits

  • Education sponsorship

• Work-life balance perks:

  • Four paid days annually to “give back” to the community

  • Your birthday off — every year

• Vehicle rebate program: Up to $400 per month