Data Engineer

Vantix Systems Inc.; Regina; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading technology company seeks a skilled data professional to manage and optimize data pipelines and processes. This full-time position in Regina requires expertise in SQL Server, Python, and big data technologies, along with a strong foundation in data management principles. Ideal candidates will have the ability to oversee legacy system integrations and communicate technical information effectively.

Qualifications

• Bachelors’ degree or technical Diploma in Computer Science / Engineering, Data Sciences or related discipline.
• Minimum of 5 years' experience working with data management principles.

Responsibilities

• Designing, creating, and maintaining data pipelines and ETL processes.
• Monitoring and troubleshooting database issues.

Skills

SQL Server

Python

Data Pipelines

ETL Processes

PySpark

Azure Data Factory

Git

Data Privacy

Education

Bachelors’ degree in Computer Science / Engineering or related discipline

5 years of related work experience

Job description

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