Technical Skills:
Expert proficiency with SQL Server (on-premises), including stored procedures, and SSIS package-level deployment.
Proven experience designing, creating, and maintaining robust data pipelines and ETL processes.
Skilled in monitoring and troubleshooting database issues to ensure compliance with policies and regulations.
Advanced Python skills applied to developing ETL processes following software development best practices (including automated testing and code reviews).
Proficient in leveraging big data technologies, including PySpark and SparkSQL for large-scale data processing.
Hands-on experience with cloud-based platforms such as Databricks, Azure Data Factory, and Azure Data Lake.
Knowledgeable in implementing Lakehouse architectures using Delta format and optimization strategies.
Experience working with external third-party APIs as ETL sources, including Microsoft Graph APIs to integrate and automate tasks across Microsoft services.
Familiar with CI/CD processes and tools—including Databricks asset bundles (DABs) for managing workflows—and proficient with version control systems (e.g., Git) for ETL deployments.
Data Management & Communication:
Understanding of data management principles as outlined by DAMA/DMBoK
Ability to provide insights on evolving database integration, storage, and utilization needs
Overseeing integration from legacy/on-premises systems to new solutions
Clear communication of technical information and the ability to train/support staff
Knowledge of data privacy and confidentiality regulations (e.g., PIPEDA)
Bachelors’ degree or technical Diploma in Computer Science / Engineering, Data Sciences or a related discipline, or 5 years related work experience
Minimum of 5 years of experience within the last 7 years working with modern data management principles
Must be able to work and be located full-time on site at client’s head office in Regina, SK; Monday to Friday, 8 am to 5 pm.
Must be able to attend an in-person interview
* The salary benchmark is based on the target salaries of market leaders in their relevant sectors. It is intended to serve as a guide to help Premium Members assess open positions and to help in salary negotiations. The salary benchmark is not provided directly by the company, which could be significantly higher or lower.