Lahal Management LP

Data Engineer - Lahal Casino Management

Lahal Management LP Coquitlam, British Columbia, Canada · CA$95K–CA$115K/yr

Entertainment Providers · 1,001-5,000 employees

3 h ago
data-engineer Mid (2-5 yrs) Full-time Canada
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

Develop, test, deploy, and maintain data pipelines and a data warehouse using Python, SQL Server, and related tools, while ensuring data quality, integrity, security, and efficient querying. Collaborate with stakeholders, review code, maintain documentation and deployment processes, and lead data engineering projects in a dynamic environment.

What they look for

Python SQL Microsoft T-SQL SQL Server Integration Services ETL/ELT Pipelines Data Warehousing Data Modeling Data Quality Validation Git Terraform CI/CD Code Review Technical Documentation Stakeholder Collaboration

Requirements

Requires post-secondary education in a quantitative field or a suitable combination of education and experience, plus at least two years of relevant software, data, cloud, or data science experience and two years working on data engineering projects with ETL tools. Two years of Azure or Microsoft on-premises experience and data warehousing platform experience are preferred but not required.

Benefits

Extended Health Benefits Paid Wellness Days Company-Matching RRSP Program Three Weeks of Annual Vacation Company Bonus Program

Full description

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.

Similar roles