Hybrid Data Engineer: ETL & BI Expert (SQL/SAS)

Intact Insurance IE; Dublin; Hybrid; EUR 80,000 - 110,000; Full time

Job summary

Intact Insurance Ireland DAC is seeking a skilled Data Engineer to design, develop, and maintain scalable data solutions using SQL Server technologies (SSMS, SSRS, SSIS) and SAS, with ETL and BI reporting focus.

You will join the Data and Analytics team supporting data pipelines, governance, and dashboards, working across Dublin, Galway and Belfast to enable informed decisions and reliable reporting.

Qualifications

• Bachelor’s degree in computer science, data engineering, IS, or related field.
• 3–5 years in a similar data engineering role.
• Strong SQL, SSMS/SSRS/SSIS, and SAS experience.
• Experience in ETL development and data warehousing.
• Knowledge of data governance and security practices.

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 data accuracy, integrity, and consistency across systems.
• 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.

Skills

Advanced SQL

ETL development

Data modeling

Analytics

Power BI

Python

Data governance

Regulatory experience

Education

Bachelor’s degree in Computer Science or related field

Tools

SQL Server (SSMS)

SSRS

SSIS

SAS

Power BI

Databricks

Python

Job description

Intact Insurance Ireland DAC is seeking a skilled Data Engineer to design, develop, and maintain scalable data solutions using SQL Server technologies (SSMS, SSRS, SSIS) and SAS, with ETL and BI reporting focus.

You will join the Data and Analytics team supporting data pipelines, governance, and dashboards, working across Dublin, Galway and Belfast to enable informed decisions and reliable reporting.