About the role
Intact Insurance is seeking a Data Engineer to design, develop, and maintain scalable data solutions using SQL Server, SSMS, SSRS, and SAS. You will build ETL pipelines, optimize queries, and create dashboards, reporting, and data visualizations while ensuring data integrity across systems.
The role reports to the Head of DataOps, with a hybrid work arrangement across Ireland. You will collaborate with stakeholders, support BI reporting, and contribute to data governance and security practices.
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 data accuracy, integrity, and consistency across systems. Manage and tune SQL Server databases for performance and scalability. Collaborate with business stakeholders to translate requirements into data solutions. Perform data analysis and validation to support reporting and decision-making. Monitor and resolve data-related issues and system bottlenecks. 3–5 years of experience in a Data Engineer role. Advanced SQL and Databricks experience is compulsory. Experience in a regulatory environment is strongly preferred. Experience with ETL development and BI reporting is desirable.