Data Engineer

Overview 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 Data Engineer Key Responsibilities Develop, optimize, and operate resilient data pipelines for ingestion, replication/CDC, and transformation across cloud and on‑prem sources using Microsoft Fabric and/or Azure data services to meet defined SLAs (batch and near real‑time). Implement modern lakehouse/warehouse patterns using Medallion architecture including data quality checks, lineage/metadata, and standardized reusable data products. Design, test, and implement dimensional data models (star schemas, conformed dimensions, fact tables, aggregates) to support enterprise reporting, self‑service analytics, and governed metric definitions.

SQL engineering and performance optimization across relational platforms (e.g., SQL Server, Azure SQL, Fabric Warehouse SQL), including query tuning, troubleshooting production issues, and improving data structures for reliability and scale. Enable analytics and reporting by publishing curated datasets and semantic models, supporting Power BI development best practices (performance, incremental refresh patterns, RLS/OLS, reusable measures) and contributing to migration away from legacy reporting (e.g., SSRS) where applicable. Ingest and curate semi‑structured and unstructured data (JSON, APIs, logs, files), managing schema evolution, validation, and scalable storage formats.

Collaborate on enterprise data governance: data definitions, data contracts, documentation, cataloging, and stewardship practices to ensure consistency and trusted data across domains. Be highly responsive to critical production issues, providing timely and effective solutions. Participate in code reviews as both reviewer and reviewee, fostering skill building for all team members.

Engage in all aspects of the Agile process, proactively contributing to improvements in the processes to minimize rework and increase quality and velocity. Keep abreast of software industry best practices, processes, and technologies. Core Competencies Communication – Clearly and articulately present information in both spoken and written word.

Collaboration – Build positive relationships, consensus, morale and commitment to goals. Innovation – Think outside the box to develop creative and new solutions that meet current and future needs. Flexibility – Easily adapt to changing environment and resources.

Productivity – Consistently achieve excellence in all tasks and goals. Accountability – Take personal ownership and responsibility for the quality and timeliness of work. Required Skills Strong experience in data engineering, ETL/ELT, and data warehousing, including dimensional modeling and delivering curated data marts/data products.

Advanced T‑SQL (Transact‑SQL) skills for development, troubleshooting, and maintenance of legacy ETL processes and data pipelines. Experience with Microsoft cloud data platforms, preference for Microsoft Fabric and/or Azure services such as OneLake, Lakehouse/Warehouse, Data Pipelines, Dataflows Gen2, Notebooks/Spark, Mirroring. Experience enabling Power BI at scale, including semantic model fundamentals (measures, relationships, performance patterns) and governance practices; SSRS experience and creative thinking.

Education Post‑secondary education in Computer Science or related discipline. Experience 3+ years development and maintenance of data warehouses and ETL processes. Why LGM Compensation Range: $100,000–$118,000 per year base plus Corporate Variable Pay.

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, birthday off each year.

Vehicle rebate program: up to $400 per month. #J-18808-Ljbffr