Description:
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.
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.
What you will help us to achieve
- 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
Technologies & Frameworks:
- Experience in SQL Server – DW, SSIS.
- Relational Database design
- Experience with programming languages: Java, C#, Python
- Scripting: Powershell, Bash
- Networking & Communication Protocols – DNS, TCPIP, UDP, HTTP, HTTPS, SSL, FTP, SCP.
Technology Stack and Tools:
- DBs – SQL Server, Oracle, MySQL
- DB ETL – SSIS
- Snowflake, Azure Data Factory
- AI Tooling, CoPilot
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.
Even if you don’t see yourself reflected in every job requirement listed on the posting above, we encourage you to reach out and apply if you feel you are a good fit for the role. We are committed to creating a more equitable, inclusive and diverse company, and we strongly encourage applicants of all genders, ages, ethnicities, cultures, abilities, sexual orientation and life experiences to apply.
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
[email protected] 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.
