Data Engineer - Lahal Casino Management

Petroglyph Development Group; Coquitlam; On-site; CAD 95,000 - 135,000; Full time

Benefits offered by this job

Extended health benefits

Paid wellness days

RRSP matching 4%

Three weeks vacation

Job summary

Petroglyph Development Group in Canada is seeking a data engineer to lead the design and maintenance of data pipelines and a data warehouse with strict data accuracy.

You will build ELT pipelines using Python and SQL Server Integration Services, optimize data models, and ensure data quality through validation and monitoring.

The role requires 2+ years in data engineering, experience with Azure or similar cloud and data warehousing platforms; strong collaboration with stakeholders is essential.

Qualifications

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

Responsibilities

• Develop and maintain a data warehouse and data pipelines.
• Build, test, deploy and maintain ELT pipelines using Python and SSIS.
• Proficiency in Python and SQL to develop ETL pipelines.
• Design data models and optimize the data warehouse for scalability and cost-effectiveness.
• Maintain data warehouse and data infrastructure with tools like Git and Terraform.
• Ensure data quality and integrity through validation and monitoring.
• Develop CI/CD integration for data pipelines.
• Review code and promote best practices.
• Contribute to documentation and data catalogs.
• Engage with stakeholders to map data needs and requirements.

Skills

Python

SQL

ELT pipelines

Data warehousing

Git

Terraform

CI/CD

Azure

Education

Bachelors or equivalent

Tools

Azure

SQL Server

Databricks

BigQuery

Terraform

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.