Data Engineer

TEEMA; Regina; Remote; CAD 100,000 - 130,000; Full time

Job summary

A government client in Regina, SK is seeking several Senior Data Engineers for a 9+ month contract to start, allowing for remote work anywhere in Canada. The role involves designing data infrastructures, developing ETL processes, and mentoring junior analysts to enhance operational efficiency.

Qualifications

• Minimum of five years of experience as a Data Engineer.
• Experience using Informatica software.
• ETL and data pipeline development experience.

Responsibilities

• Design and build data extraction and transformation infrastructures.
• Build analytics tools providing actionable insights.
• Mentor and support junior Data Management resources.

Skills

Problem-solving skills

Data Management

Information management

Cloud platform for data management

Algorithms

Data structures

Education

Bachelor’s degree in Information Technology, Engineering or Computer Science

Tools

Informatica

Oracle

SQL Server

Shell Scripting

Job description

Job Title:Senior Data Engineer
Job ID:80594
Location:Regina,Saskatchewan

Overview:
Our government client in Regina, SK is looking for several Senior Data Engineers for a 9+ month contract to start, with possible extensions, reference #C19003374. This position can be remote located anywhere in Canada.

What you will be doing:

• Design and build the infrastructure required for optimal extracting, transformation, and loading of data from a wide variety of data sources using Informatica, SQL, SSIS, API and other technologies.

• Architect relational and multi-dimensional databases from structured, semi-structured and unstructured data with development techniques including star and snowflake schemas, ETL, Slow Changing Dimensions (SCD), Fact and Cube development in a data management framework in conjunction with the Provincial Data Platform Infrastructure.

• Identify, design and implement internal process improvements: automate manual processes, optimize data delivery, re-design data pipelines for greater scalability.

• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiencies, and other key business performance metrics.

• Develop, maintain, optimize, troubleshoot, debug, monitor, backup and recovery operations for the ETL environment.

• Analyze datasets to ensure compliance with data sharing agreements and legislation restrictions, and for alignment with data architecture guidelines.

• Mentor, support and train Information Analyst and junior Data Management resources, as required.

What you must have:

• Possesses a bachelor’s degree in information technology, Engineering or Computer Science.

• Minimum of five (5) years of proven experience working as a Data Engineer or similar role.

• Experience using Informatica software (i.e., Power Centre, Integration Services, Workflow Manager, IDMC and TDM) in an integrated support environment.

• Oracle and SQL Server Database Management Systems and tools.

• ETL and data pipeline development experience; providing technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.

• Computer programming languages such as PL/SQL, R, Python.

• Operating systems such as Unix, Linux, and Windows.

• Shell Scripting language.

• Data Application Programming Interface (API).

• Algorithms and data structures.

The ideal Resource(s) should have extensive experience with:

• Information management, logic modeling, conceptual, business process, and workflow design.

• Requirements gathering, analysis, plan, design, develop, implement and maintain Data Management systems.

• Critical, constructive and creative problem-solving skills that involve issue identification, development of objectives, development of an action plan overseeing what needs to done, while identifying the resources required to ensure quality products.

• Cloud platform for data management. It would be an asset for the ideal Resource(s) to have:

• Microsoft Certified: Azure Data Engineer Associate would be considered an asset.

• Experience working with healthcare data would be considered an asset

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