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 ConsiderationsWorking onsite five days per week to support strong collaboration, relationship-building, and high-visibility partnership with operational teams. T
Total RewardsWe 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.
