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.
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).
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
Data Engineer • Vancouver, CA
A leading mortgage technology company in Vancouver is seeking a Senior Data Engineer to shape the future of their data infrastructure.You will lead the migration of data pipelines into the Microsof...Show more
At Wave, we help small businesses to thrive so the heart of our communities beats stronger.We work in an environment buzzing with creative energy and inspiration.No matter where you are or how you ...Show more
A leading IT consulting firm is looking for an experienced Azure Data Engineer to build and manage a scalable data integration platform.The successful candidate will work on Microsoft Fabric to des...Show more
Vantage is looking for its next Senior Data Engineer to join our Measurement team.Our Measurement team is focused on enhancing the Insights Explorer feature of our platform, enabling the organizati...Show more
At Cloudbeds, we’re not just building software, we’re transforming hospitality.Our intelligently designed platform powers properties across 150 countries, processing billions in bookings annually.F...Show more
A leading productivity software company in Canada seeks a Senior Data Engineer to shape and scale their modern data platform.This role involves designing reliable data pipelines with AWS and Terraf...Show more
A technology solutions company is seeking a Data Engineer with over 6 years of experience to develop backend systems and data pipelines.This remote role involves building and optimizing data-centri...Show more
At Borrowell, we're on a mission to help Canadians feel confident about their money.We empower individuals to take control of their financial futures by providing the tools and insights needed to u...Show more
Drive data engineering efforts focused on cloud technologies as a Data Engineer.Support marketing analytics by implementing advanced ETL processes that optimize data quality and accessibility.You w...Show more
Stacktics, where we design, create, deploy, maintain and grow industry-leading Cloud Infrastructure, Big Data Analytics and Cloud For Marketing products, solutions and services.Stacktics will rely ...Show more
They say you only get one chance to make a great first impression.At Wysdom we’re here to change that.We exist to help our clients make a great first impression with their customers – over and over...Show more
A regional health authority in Metro Vancouver is seeking a Senior Data Engineer to lead data strategy and manage ETL pipelines.The position requires extensive experience in data engineering, moder...Show more
Get AI-powered advice on this job and more exclusive features.This range is provided by Samsara.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more....Show more
We need someone who can turn millions of messy transactions into clean, fast, "aha moment" analytics for thousands of merchants.You'll build the data pipelines that power dashboards, design the war...Show more
Spring Financial is a Canadian financial technology company focused on making every day financial services simpler, faster, and more accessible.We build technology that helps Canadians build credit...Show more
A leading EHS+ solutions provider in Canada is seeking a Senior Analytics Engineer to own their data platform end-to-end.Responsibilities include leading the architecture of the Medallion data arch...Show more
We are seeking a skilled Azure Databricks Engineer with strong experience in Azure Data Factory (ADF) to design, develop, and maintain scalable data pipelines and analytics solutions on the Azure c...Show more
Design and implement robust dimensional and relational data models.Own transformation and modeling of curated (Silver/Gold) datasets.Collaborate with analysts, product analytics, data scientists, a...Show more
