Data Engineer - Lahal Casino Management
Lahal Management LP Coquitlam, British Columbia, Canada · CA$95K–CA$115K/yr
Entertainment Providers · 1,001-5,000 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
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
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
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
-
Data Engineer
Ford Motor Company Dearborn, Michigan, United States · $85K–$143K/yr
-
Senior Data Engineer
MANTECH Raleigh, North Carolina, United States
- Senior Data Engineer
-
Principal Snowflake Data Engineer - Contract (Manchester)
Insight Investment Manchester, England, United Kingdom
-
Data Engineer
K Health New York, New York, United States · $150K–$175K/yr
-
[8GT] Senior Data Engineer
Software Mind San José, Costa Rica