Talent.com
Data Engineer
Data EngineerLGM Financial Services Inc. • Vancouver, CA
No longer accepting applications
Data Engineer

Data Engineer

LGM Financial Services Inc. • Vancouver, CA
30+ days ago
Job type
  • Full-time
Job description

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

What You Bring
  • 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

Why This Role Is Exciting
  • 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



Required Skills


Required Experience
Create a job alert for this search

Data Engineer • Vancouver, CA

Similar jobs

Senior Data Engineer, Analytics Platform — Scale ELT Pipelines

DiagramVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Data Engineer

Wave HQVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Azure Data Engineer: Fabric Pipelines & Data Models

Symbiotic GroupVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Senior Data Engineer

VantageVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Staff Data Engineer

CloudbedsVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Senior Data Engineer — AI-Driven Data Platform

ClickUpVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Remote Data Engineer — Backend & Data Pipelines Specialist

ZeuzVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

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

 • Promoted

Data Engineer

BorrowellVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Data Engineer Specializing in Cloud Solutions

Electronic ArtsVancouver
Full-time

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

 • Promoted

Data Engineer (Google Cloud)

Stackticsburnaby, bc, ca
Permanent

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

 • Promoted • New!

Data Engineer

WysdomVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Senior Data Engineer: Data Lake & Hybrid Cloud Lead

Fraser HealthSurrey, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Senior Data Platform Engineer

SamsaraVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Senior Data Engineer (Analytics Focus)

TapMangoVancouver, Metro Vancouver Regional District, CA
Full-time

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

 • Promoted

Senior Data Engineer

Spring FinancialVancouver, Metro Vancouver Regional District, CA
Permanent

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

 • Promoted

Lead Data Engineer - Medallion Architecture (Remote)

CorityVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

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

 • Promoted

Azure Databricks Engineer

Tredence Inc.delta, bc, ca
Full-time

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

 • Promoted

Sr AWS DBT Engineer - Mastech Digital

Mastech Digitaldelta, bc, ca
Full-time

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