Data Engineer

The Organization  

LGM is a national leader in providing warranty, finance and insurance services to the Canadian automotive industry. LGM brings innovation, quality, service and profitability to its dealer partners through a full suite of products and services distributed in a cutting-edge, ethical and transparent manner. Since 1998, LGM has been successfully supplying quality products backed by leading training and now supports over 1,200 Canadian franchised new car dealerships. Dealer partnerships are complimented with the strong backing and support of their automotive manufacturing brands, which include BMW/MINI, Kia, Mazda, Volvo, Jaguar/Land Rover Range Rover, Mitsubishi Motors, Polestar and Motorrad. 

Key Responsibilities:

• Develop and maintain data pipelines for daily ETL processes, data collection and ingestion from external sources, and optimal data flow between different LGM systems and environments, in Azure cloud and on premisses.
• Design, test and implement Data Marts and Data Warehouse using standard dimensional modeling techniques.
• SQL development in MS SQL Server, including advanced tuning of queries, data structure design, troubleshooting of production issues, and providing technical assistance regarding problems and technical questions.
• Define, develop, and maintain data presentation and visualization, including reports written in SSRS and Power BI
• Manipulate, store and extract information from non structured data sets.
• Participate in corporate data governance, providing foundational data consistency and assisting with business analysis.
• Be highly responsive to critical production issues providing timely and effective solutions.
• Participate in code reviews both as a reviewer and as a reviewee, in a respectful way that facilitates skill building for all team members.
• Engage in all aspects of the Agile process, proactively contributing to improvements in the processes to minimize rework/waste and increase quality and velocity.
• Keep abreast of software industry best practices, processes, and technologies. Actively encourage their adoption within the Sprint Team and LGM.

Core Competencies:

• Communication – Able to clearly and articulately present information in both spoken and written word.
• Collaboration – Develops positive relationships with others to build consensus, morale and commitment to goals and objectives.
• Innovation – Displays the ability to think outside of the box to develop creative and new solutions that meets current and future needs.
• Flexibility – Easily adapts to changing environment and resources.
• Productivity – Strives to consistently achieve excellence in all tasks and goals.
• Accountability – Takes personal ownership and responsibility for the quality and timeliness of work commitments and decisions.

Required Skills:

• Experience with Data Warehouse theory, design, and ETL development
• Advanced TSQL skills including query tuning, database internals, and data structure design
• Ability to create and maintain reports with SSRS and Power BI
• Azure components and concepts (Data Factory, Data Lakes, Data Bricks, etc)
• Exceptional communication skills including verbal, documentation, and presentation.
• Ability to think creatively.
• Nice to have:
  • TDWI certification
  • SSIS package creation and maintenance
  • Powershell scripting
  • Python and/or R and Machine Learning
  • MDX / DAX / Tabular modeling

Education:

• Post-secondary education in Computer Science or related discipline

Experience:

• 3+ years development and maintenance of Data Warehouses and ETL processes

What We Offer  

• A competitive compensation package, including a comprehensive health benefits plan, Group RRSP, performance bonus, health and wellness benefits, and education sponsorship.  
• Four paid days annually to "give back" to the community, along with your birthday off.  
• A vehicle rebate program of up to $400 per month.  
• Hybrid work model.
• The compensation range for this position is $105,00 - 125,000.