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 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.

• 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 One Lake, 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

• 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