Senior Data Engineer

Express Employment Professionals Regina; Regina; On-site; CAD 85,000 - 120,000; Full time

Job summary

A leading staffing agency is looking for two Senior Data Engineers in Regina. The role focuses on refining data from healthcare domains, utilizing various technologies to develop and maintain data models, ensuring compliance with data restrictions, while mentoring junior resources. Candidates should possess a bachelor's degree in IT or related fields and have a minimum of five years of experience, particularly using Informatica. This contract position offers a chance to extend further, emphasizing a strong background in data engineering and ETL processes.

Qualifications

• Minimum of five years of proven experience as a Data Engineer.
• Experience with Informatica's suite.
• Knowledge of cloud data management platforms.

Responsibilities

• Design infrastructure for data extraction, transformation, and loading.
• Build analytics tools for actionable insights.
• Mentor junior Data Management resources.

Skills

ETL Development

Data Modeling

Informatica

SQL

Python

R

Education

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

Tools

Informatica

SQL Server

Oracle

Job description

Direct message the job poster from Express Employment Professionals Regina

Job Type: Contract 9-12 months (potential to extend for 1 more year)

Express Employment Professionals is currently looking for two Senior Data Engineers to work with data from across the spectrum of healthcare domains, refining requirements with customers, developing data models, extracting data from various source systems and database formats, and providing data in a number of formats including Extract, Transform, Load (ETL) aligned with Informatica software.

Duties & Responsibilities:

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

Qualifications/Requirements:

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

The ideal candidate should have expert knowledge of:

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

• Algorithms and data structures.

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

• Cloud platform for data management.

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

Seniority level

• Seniority level

  Not Applicable

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Staffing and Recruiting

Referrals increase your chances of interviewing at Express Employment Professionals Regina by 2x

Get notified about new Senior Data Engineer jobs in Regina, Saskatchewan, Canada.

Senior Software Engineer - Digital Workplace

Embedded Linux Senior Software Engineer - Optimisation

Regina, Saskatchewan, Canada 3 months ago

Python and Kubernetes Software Engineer - Data, Workflows, AI/ML & Analytics

Python and Kubernetes Software Engineer - Data, AI/ML & Analytics

Regina, Saskatchewan, Canada 3 months ago

Senior Software Engineer, Backend (Merchant Risk Intelligence & Platform)

Senior Software Engineer - packaging - optimize Ubuntu Server

Senior Software Engineer - packaging - optimize Ubuntu Server

Senior Software Engineer (Capacity and Cloud Economics Engineering)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.