Data Engineer

Intact Insurance

Dublin

Hybrid

EUR 70,000 - 120,000

Full time

13 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Intact Insurance Ireland is seeking a Data Engineer to design, develop, and maintain scalable data pipelines and ETL processes. The role emphasizes strong SQL Server and SAS capabilities, plus experience with BI tools like Power BI and Azure data services.

You will work within the Data and Analytics team to deliver reliable data solutions and support reporting across the business. The role reports to the Head of DataOps and offers hybrid work arrangements across Ireland, including Dublin,

Qualifications

  • 3–5 years of experience in a similar data engineering role.
  • Strong SQL and Data Bricks expertise required.
  • Experience with SSMS, SSRS, SAS is essential.
  • Experience with ETL, data warehousing, and large datasets.
  • Familiarity with Power BI or BI tools.
  • Bachelor's degree in CS/IS/Data Engineering.
  • Certifications in Microsoft SQL Server or SAS preferred.

Responsibilities

  • Design, develop, and maintain data pipelines and ETL processes.
  • Write and optimize complex SQL queries and stored procedures.
  • Develop SSRS reports and data visualizations.
  • Ensure data accuracy and consistency across systems.
  • Tune SQL Server databases for performance and scalability.
  • Collaborate with stakeholders to translate requirements into data solutions.
  • Monitor data issues and resolve bottlenecks.
  • Support BI reporting and decision-making.

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, anddata visualizations
  • Ensure data accuracy, integrity, and consistency across systems
  • Manage and tune SQL Server databases for performance andscalability
  • Collaboratewith business stakeholders to translate requirements into data solutions
  • Performdata analysis and validation to support reporting and decision-making
  • Monitor and resolve data-related issues and system bottlenecks
Requirements
  • Minimum 3 to 5 years'experience in a similar role
  • AdvancedSQL and Data Bricks experience is compulsory
  • Experience working in a regulatory environment is strongly preferred
  • Strong hands-onexperience with:
    • Microsoft SQL Server
    • SQL Server Management Studio (SSMS)
    • SQL Server Reporting Services (SSRS)
    • SAS (Base or EG SAS / SAS Programming)
  • Proficiency in SQL scripting, query optimization, and database design
  • Experience in ETL development and data integration
  • Solid understanding of data warehousing concepts
  • Ability to handle large datasets and performance tuning
  • Strong analytical and problem-solving skills
  • Experience with Power BI or other BI tools
  • Exposure to AzureData Services (e.g., Azure SQL)
  • Knowledge of Python or other scripting languages
  • Familiarity with data governance and security practices.
  • Bachelor's degree in computer science, Data Engineering, Information Systems, or related field
  • Relevant certifications in Microsoft SQL Server or SAS (preferred)
Join Intact Insurance and make a difference every day.

Whether you're just beginning your career or looking to take the next progressive step, Intact Insurance Ireland is where you can be yourself, learn and develop, and where your ideas matter.

With offices inBelfast, Galway, and Dublin, we've embracedhybrid work, empowering our people towork flexiblyand deliver great service to our customers every day.

We want you to thrive and grow with us – and we'll give you all the tools, flexibility and learning opportunities you need to do it.

And, if you bring your best, then we promise to give you, our best.

Our employees are at the heart of everything we do. Together, we help people, businesses, and society prosper in good times and be resilient in bad times.

Our employee promise represents Intact Insurance's commitment to you in exchange for living our Values, we promise to provide support, opportunities and performance-led financial rewards at a workplace where you can shape the future, win as a team and grow with us.

Regulatory Requirements

If this role is defined as a "controlled function" by the Central Bank Reform Act 2010 Regulations 2011. Any appointment will be conditional on the company being satisfied that you meet the requirements as set out in the Fitness & Probity standards issued in this Act.

Intact Insurance Ireland DAC and its affiliate companies consider applicants on the basis of qualifications and without regard to race, colour, religion, sex, national origin, age, marital or veteran status, sexual orientation, disability or any other legally protected status.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer – ETL, SQL Server & SAS
Data Engineer – ETL, SQL Server & SAS

Intact Insurance • Dublin

Hybrid
EUR 70,000 - 120,000
Data Engineer
Data Engineer

MetLife, Inc. • Galway

Hybrid
EUR 45,000 - 60,000
Hybrid work
Private health insurance
Pension benefits
Digital Marketing Executive
Digital Marketing Executive

Intact Insurance • Dublin

Hybrid
EUR 50,000 - 65,000
Hybrid work
Learning opportunities
Digital Marketing Executive
Digital Marketing Executive

Intact Insurance UK • Dublin

Hybrid
EUR 45,000 - 65,000
Hybrid work
Training and development
Senior Data Analyst, Business Intelligence.
Senior Data Analyst, Business Intelligence.

AIB • Dublin

Hybrid
EUR 70,000 - 95,000
Market-leading pension scheme
Healthcare scheme
Variable pay
+3
Customer Service Operations Underwriter
Customer Service Operations Underwriter

Intact Insurance UK • Galway

Hybrid
EUR 38,000 - 58,000
Hybrid work
Senior Data Analyst, Business Intelligence
Senior Data Analyst, Business Intelligence

Allied Irish Bank • Dublin

On-site
EUR 70,000 - 90,000
Employee Assistance Programme
Family leave options
Head of Data Engineering
Head of Data Engineering

Brightwater Executive • Dublin

On-site
EUR 140,000 - 210,000
Claims Investigator
Claims Investigator

Intact Insurance • Dublin, Galway

Hybrid
EUR 42,000 - 55,000
Hybrid work
Work flexibility
Data Engineer
Data Engineer

Fruition Group Ireland • Mullingar

On-site
EUR 60,000 - 90,000
Onsite in Mullingar
Top locations