Job Description

Data Engineer

We are seeking a skilled Data Engineer to design, develop, and maintain scalable data solutions. The ideal candidate will have strong expertise in Microsoft SQL Server technologies (SSMS, SSRS, SSIS) and analytical tool SAS, with a proven ability to manage large datasets, optimize performance, and support business intelligence reporting.

The Intact Data and Analytics team supports the business' data and reporting needs using a hub-spoke model. The selected candidate will be expected to provide technical development skills to build ETL pipelines and effectively

The Data Engineer will report to the Head of DataOps.

Key Responsibilities

Design, develop, and maintain data pipelines and ETL processes using SQL Server and SAS
Write, optimize, and troubleshoot complex SQL queries, stored procedures, and functions in SSMS
Develop and maintain SSRS reports, dashboards, and data visualizations
Ensure