Senior Data Engineer

Job title:

Senior Data Engineer

Company

IT/IQ

Job description

Job Title: Senior Data Engineer x2
Location: Remote; must be physically located in Canada
Contract Duration: to March 31, 2026 + potential to extend
Start Date: ASAP
Rate Range: $75-90/hrServices Required:

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

Deliverables:

• Documentation artifacts, including but not limited to metadata, detailed requirements, technical design, data models, process flow diagrams, operational support documents.
• ETL, scripts and code to support data extraction and data pipelines established.

Qualifications / Experience Required:

• 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.
• 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.
• Microsoft Certified: Azure Data Engineer Associate would be considered an asset.
• Experience working with healthcare data would be considered an asset.

Expected salary

Location

Canada

Job date

Sat, 09 Aug 2025 00:43:28 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnearcanada.com) you saw this job posting.