Data Engineer

InSync Systems; Regina; On-site; CAD 80,000 - 110,000; Full time

Job summary

InSync Systems is seeking a Data Engineer for a 21-month contract in Regina, Saskatchewan. The ideal candidate will design and maintain ELT pipelines, support evolving data needs, and drive process improvements. Successful applicants will need at least 5 years' experience in data management principles and relevant technical expertise.

Qualifications

• Minimum 5 years in modern data management principles.
• Expert proficiency in SQL Server.
• Advanced Python skills for ETL processes.

Responsibilities

• Design, build, and maintain ELT pipelines and data solutions.
• Work with stakeholders to support data infrastructure needs.
• Drive internal process improvements and automation.

Skills

SQL Server

Data Modeling

ETL

Python

Data Governance

Education

Degree or Diploma in Computer Science, Engineering, Data Sciences

Tools

Databricks

Azure Data Factory

Azure Data Lake

Git

Job description

We are looking for a Data Engineer for a 21-month contract position, with possible extensions in Regina, Saskatchewan. Must be legally entitled to work in Canada.

This position is 100% onsite, Monday to Friday. 8 hours a day, 40 hours a week. It is NOT a remote role. Candidate must be able to attend an in-person interview, if shortlisted.

Role Description

We are seeking a Data Engineer to design, build, and maintain robust ELT pipelines and scalable data solutions in collaboration with Enterprise Analytics and business stakeholders. This role involves assembling complex datasets, driving internal process improvements, and championing enterprise information capabilities to enhance data governance, integration, and analytics. The ideal candidate will support evolving data infrastructure needs while enabling high-performance analytics through automation, optimization, and emerging technologies.

Responsibilities

• Work closely with the Enterprise Analytics team to create and maintain ELT processes
• Assemble large, complex datasets that meet functional / non-functional business requirements
• Consulting DT&S and Business leaders on data and information management practices and governance
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and other technologies
• Work with stakeholders including the Executive, to assist with data-related technical issues and support their data infrastructure needs.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our business.
• Work with data and analytics experts to strive for greater functionality in our data systems.
• Championing efforts to improve business performance through enterprise information capabilities, such as master data management (MDM), metadata management, analytics, content management, data integration, and related data management or data infrastructure
• Provide insight into the changing database integration, storage and utilization requirements for the company and offer suggestions for solutions
• Monitor and understand Information Management trends and emerging technologies.

Required Skills and Experience

• MUST have a minimum of 5 years of recent (in last 7 years) in modern data management principles such as, but not limited to ETL, practical data design, architecture, management, modelling, quality, and analytics experience.
• Degree or Diploma in Computer Science, Engineering, Data Sciences, or similar discipline
• 5+ years’ recent experience in ETL, data design, data architecture, data management, and data modeling
• Relevant job experience in North America
• 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.
• 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)

Please note that while all applications are appreciated, only candidates selected for interview will be contacted.

InSync Systems Inc. is a privately-owned boutique Canadian Resourcing and Consulting Services Company that works closely with a range of corporate clients across multiple industries to bring them solutions that effectively address their business needs.