Senior Software Developer

Irish Life Group Services Limited; Dublin; On-site; EUR 90,000 - 120,000; Full time

Job summary

Canada Life Group Services is seeking a Senior Software Engineer to design, develop and maintain ETL and data integration solutions using SSIS, with strong SQL Server/Oracle skills in a regulated financial services setting.

You will work in a Scrum team on prem and in the cloud (Azure/AWS), ensuring data quality and robust solutions, while mentoring colleagues on best practices and patterns.

Qualifications

• 5+ years of experience in a similar role.
• Experience designing data solutions in regulated environments.
• Strong SQL/SSIS programming and relational database knowledge.
• Knowledge of data warehousing design patterns and data modelling.
• Familiarity with DevOps and Agile practices.

Responsibilities

• Design, build, and implement scalable data solutions.
• Hands-on development for on-premise and cloud-based systems.
• Support and upskill team members; develop reusable patterns.
• Work in a Scrum team following Agile values and principles.

Skills

SQL/SSIS

Data warehouse concepts

Agile/Scrum

DevOps

Data governance

Problem solving

Team collaboration

English fluency

Education

Honours degree (3rd level)

Bachelor's degree

Tools

SQL Server

Oracle

Power BI

Snowflake

Azure Data Factory

JIRA

Confluence

Job description

Select how often (in days) to receive an alert:

Canada Life Assurance Europe plc (‘CLE’) is a dynamic insurance company with over 700 people across our offices in Germany and Ireland. We have been operating in Germany since 2000 and have established a fast-growing presence in one of the world’s largest and most established markets. We specialise in providing innovative unit-linked pension, savings, and protection solutions and have become a trusted partner for life insurance products distributed through independent brokers. It is our priority to support our customers at every stage of life with the best products and service, tailored to their needs - and we’re doing it all in a culture that promotes equality and inclusion for all of our current and future employees.

Role Overview

Canada Life Europe (CLE) is seeking a Senior Software Engineer to be responsible for the design, development and maintenance of ETL and data integration solutions using Microsoft SQL Server Integration Solutions (SSIS). Working with enterprise Data Warehouse solutions enabling the secure flow of data through the organisation. The person will have a strong development background and experience in building large scale n-tier systems. They must have experience of working in a Financial Services environment and be able to convert complex business requirements into working solutions. The applicant must be detail orientated and focused on quality of implementation.

• Design, build, and implement best of breed, scalable solutions according to defined patterns and practices.
• Hands on development activities, building and maintaining scalable solutions for both on premise and cloud-based systems.
• Hands on support and upskilling of existing resources, providing patterns for common problems and developing prototypes.
• Work as part of a Scrum team using Agile practices and adhering to the values and principles.

What you will need to be successful in the role

Key Strengths

• Hands on experience of designing and building data solutions across complicated, highly regulated environments.
• Experience with SQL Server, Oracle and other RDBMS
• Experience with ETL tools and development.
• Experience with cloud platform, Azure, AWS or other.
• Good knowledge of CI and CD principles and methodologies.
• Demonstrate hands on experience of ensuring code quality, data quality, and robust business solutions.

Essential Skills

• Extensive experience in designing data solutions and data extract, transforms and loads.
• Experience across multi-tiered systems, cloud and on premise.
• 5+ years SQL/SSIS programming experience and deep knowledge of relational databases (e.g. SQL Server).
• Highly proficient in SQL optimisation and performance tuning.
• Knowledge of Data Warehousing design patterns and data modelling.
• Understanding the concepts of Data Governance – Data Masking, Data Quality and Lineage.
• Good knowledge of System Architectures, Software Engineering, and DevOps / Agile practices - experience of Agile Methodologies and operating in agile / scrum-based teams.
• Strong competencies in Strategic Thinking, Collaboration, Communication, Problem Solving, Working on own Initiative.
• Excellent problem-solving skills, and ability to craft effective solutions.
• Excellent team player, collaborative, and supportive.
• Ability to multitask while maintaining a high level of attention to detail.
• A solution driven, self-starter with commitment and follow through.
• Fluent in English – written and verbal .

Necessary Skills

• Minimum 5 years’ experience in a similar role.
• 3rd level qualification (honours degree), preferably in a related discipline.

Desired Skills & Experience

• Knowledge of insurance or financial services industry applications and functionality.
• Experience with business intelligence and reporting - PowerBI.
• Knowledge and experience of Snowflake.
• Experience with Azure Data Factory.
• Experience using JIRA/Confluence.
• Working knowledge of German language

The company reserves the right to draw up a shortlist as part of the selection process. Where Agency assistance is required the Canada Life Recruitment Team will engage directly with suppliers. Unsolicited CVs / profiles supplied to Canada Life by Recruitment Agencies will not be accepted for this role.

Canada Life Group Services is proud to be an Equal Opportunities employer. We have created an environment of inclusion and growth to help people achieve their potential, to ensure they can bring their whole selves to work and to feel valued. We celebrate diversity of thought and perspective and want all of our employees to feel valued, respected and supported. We have built a culture that promotes equality and inclusion for all of our current and future employees and strive to ensure that our behaviours, processes and practices are aligned to this culture.

If you require any accommodations during the recruitment process please contact [e-mail] and we will be delighted to ensure you are fully supported to be your best.

CLGS supports Equal Opportunity and is regulated by the Central Bank of Ireland.