Data Engineer - Lahal Casino Management

Lahal Management LP; Coquitlam; On-site; CAD 95,000 - 135,000; Full time

Benefits offered by this job

Extended health benefits

RRSP matching (4% not guaranteed)

3 weeks vacation to start

Job summary

Lahal Management LP in Canada is seeking a data engineer to lead the development of complex data pipelines and a data warehouse. You will implement ELT processes, test and deploy pipelines, and ensure data quality and integrity across systems.

The role requires strong Python and SQL (T-SQL) skills, experience with ETL tools, and the ability to collaborate with stakeholders. Onsite work in Metro Vancouver is expected with a focus on scalable, cost-effective data solutions.

Qualifications

• Post-secondary education in a quantitative field or equivalent experience.
• 2 years of experience as software developer, data engineer, cloud engineer, data scientist or equivalent.
• 2 years on data engineering projects and ETL tools.
• 2 years experience with Azure or Microsoft On-Prem environment (preferred).

Responsibilities

• Develop and maintain a data warehouse and multiple data pipelines.
• Build, test, deploy and maintain ELT pipelines with Python and SSIS.
• Develop and maintain ETL pipelines using SQL/T-SQL.
• Design data models and optimize for querying, scalability, and cost.
• Maintain data infrastructure with Git and Terraform.
• Ensure data quality and monitoring across pipelines.
• Lead data pipeline discussions with stakeholders and map requirements.

Skills

Data pipelines

SQL

Python

ETL

CI/CD

Code review

Documentation

Data warehouse

Stakeholder mgmt

Education

Post-secondary education in quantitative field

Tools

Git

Terraform

Azure

SQL Server

Job description

Salary Range: $95,000.00 To $135,000.00 Annually

Position Summary:

Under the direction of the Director, IT systems, this position is responsible for direct development of complex, data pipelines and reporting solutions with extremely low tolerances for data error, also maintaining and ensuring data and application systems operate in accordance with functional design specifications through systematic and defined activities and processes while contributing to a safe and welcoming work environment for all employees. Ensures adherence to all policies and procedures.

Key Accountabilities:

• Able to be a one-person team developing and maintaining a data warehouse alongside multiple data pipelines
• Build, test, deploy and maintain ELT data pipelines, loading data from various sources into SQL Server databases using Python and SQL Server Integration Services
• Proficiency in Python and SQL (preferably Microsoft T-SQL) to develop and maintain ETL pipelines
• Design data models and optimize the data warehouse for efficient querying, scalability and cost-effectiveness.
• Maintain data warehouse and data infrastructure through tools such as git and Terraform as applicable
• Ensures data quality, integrity and completeness through validation, checks and monitoring, using appropriate tools
• Develop CI / CD tools integration / operation to ensure effective monitoring and deployment of data pipelines
• Review code developed by other developers and provide feedback to ensure best practices (e.g. style guidelines, checking code in, accuracy, testability and efficiency)
• Contribute to documentation and data catalogs and adapts documentation based on updates and user feedback
• Participates in, or lead discussions with peers and stakeholders to fully map out data pipeline needs / requirements
• Maintain the highest levels of development practices including technical design, solution development, systems configuration, test documentation/execution, issue identification and resolution, writing clean, modular, and self-sustaining code.
• Lead projects in a multi-stakeholder and dynamic environment to achieve team and project Objectives and Key Results.
• Appropriately protects the confidentiality, security, and integrity of the Association, employees, borrowers, and other stakeholders.
• Ensures compliance with licensing laws, health and safety and other statutory regulations.
• Manages other initiatives as required

Education and Qualification Requirements:

• Post-Secondary education in any quantitative field and/or suitable combination of education and experience.
• 2 years of experience as a software developer, data engineer, cloud engineer, data scientist or equivalent experience
• 2 years of experience working on data engineering projects and using various ETL tools
• 2 years of experience with Azure or a Microsoft On-Prem environment is preferred but not required
• 2 years of experience with any data warehousing platform (e.g. BigQuery, Snowflake, Databricks) is preferred but not required

Work Environment Considerations

Working onsite five days per week to support strong collaboration, relationship‑building, and high‑visibility partnership with operational teams. T

Total Rewards

We offer a comprehensive Total Rewards package designed to support your well‑being, growth, and long‑term success. The successful candidate will receive extended health benefits starting immediately upon hire, paid wellness days, and a Company‑matching RRSP program with up to a 4% match to help you plan for the future. This role also includes three weeks of annual vacation to start, supporting work–life balance in a dynamic casino environment.

Compensation for this position is based on experience and qualifications, with a salary range of $95,000–$135,000. This position is also eligible for a company bonus program tied to overall organizational performance.