Data Engineer

Job Title: Data Engineer
Job ID: 81101
Location: Regina, Saskatchewan

Overview:
Our client in Regina, SK is looking for a Data Engineer for an initial 21 month contract till March 31, 2027, reference SX7182, with the option for additional renewals. This is an onsite role and the successful candidate(s) must be currently residing in the Regina area or be willing to relocate to the area for the duration of the contract.


What you will be doing:

• 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.

What you must have:

• Candidate must have a Bachelors’ degree or technical Diploma in Computer Science / Engineering, Data Sciences or a related discipline, or 5 years related work experience

• Candidate must have a minimum of 5 years’ experience within the last 7 years working with modern data management principles

• Candidate must be able to work and be located full-time on site in Regina, SK; Monday to Friday, 8 am to 5 pm.

• Candidate must be able to attend an in-person interview, if shortlisted

• 5+ years’ recent experience in ETL, data design, data architecture, data management, and data modeling

• Relevant job experience in North America

Core Technical Skills

• SQL Server & SSIS: Expert proficiency with SQL Server (on-premises), including stored procedures, and SSIS package-level deployment.

• Data Pipelines: Proven experience designing, creating, and maintaining robust data pipelines and ETL processes.

• Monitoring: Skilled in monitoring and troubleshooting database issues to ensure compliance with policies and regulations

• Python for ETL: Advanced Python skills applied to developing ETL processes following software development best practices (including automated testing and code reviews).

• Big Data Tools: Proficient in leveraging big data technologies, including PySpark and SparkSQL for large-scale data processing.

• Cloud Expertise: Hands-on experience with cloud-based platforms such as Databricks, Azure Data Factory, and Azure Data Lake.

• Lakehouse Architecture: Knowledgeable in implementing lakehouse architectures using Delta format and optimization strategies.

• API Integration: Experience working with external third-party APIs as ETL sources, including Microsoft Graph APIs to integrate and automate tasks across Microsoft services.

• Automation & Deployment: 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)

The above experience should be clearly detailed within submitted resume.


For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com