ETL Engineer

Job Title

ETL Engineer

Job Description

We are seeking a skilled developer to join our GTS Team. The ideal candidate will be responsible for managing and optimizing data integration processes using various ETL/ELT tools such as SNP Glue, Matillion and Data Services. Additionally, the role would need an all round scripting skillset to write automation jobs and customise Power BI. This role involves working closely with various departments to ensure seamless data flow and integration between multiple systems.

This is part of an exciting project to produce cloud-based data models in Snowflake and Oracle

Key Responsibilities
• Data Integration: Design, implement, and manage data integration workflows.
• Data Replication: Oversee high-volume data extraction and replication processes, ensuring pipeline reliability, scalability, and performance.
• Change Data Capture (CDC): Implement and manage CDC methods to capture and replicate changes in real-time.
• Scripting : Scripting in Power Automate and Power BI
• Performance Optimization: Monitor and optimize the performance of data integration processes to ensure efficiency and reliability.
• Error Handling: Develop and maintain error handling and troubleshooting procedures for data integration workflows.
• Security & Compliance: Ensure data integration processes comply with security standards and data governance policies.
• Collaboration: Work closely with business analysts, data engineers, and other stakeholders to understand data requirements and deliver solutions.
• Documentation: Maintain comprehensive documentation of data integration processes, configurations, and best practices.
• Project Onboarding: Integrating new pipelines aligned to project goals and deliverables with the necessary tools, resources and information.

Skills/Experience

Essential
• 3+ years of experience in ETL development and data integration
• Proficiency with ETL tools such as Matillion, Data Services, SNP Glue or similar and/or scripting of data migration
• Strong SQL skills and experience with relational databases (e.g., SQL Server, Oracle, Snowflake)
• Experience with Snowflake or other cloud data platforms
• Familiarity with event-based architectures and HTTP connectors

Desirable
• Re-insurance industry knowledge.
• SAP certification in relevant modules & experience with SNP Glue
• Familiarity with data governance and data quality frameworks
• Knowledge of scripting languages (e.g., Python, Shell)

Personal Characteristics
• Collaborates well with all levels of the organization, including senior management.
• Good Communicator – succinctly communicates product vision to all stakeholders in a compelling and effective way.
• Decisive – makes effective customer centric decisions.
• Flexible – adapts and thrives under change and ambiguity in an independent and flat structure.
• Excellent internal customer service and communication skills.
• Ability to work in a fast-paced environment with multiple priorities.
• Ability to produce accurate work under pressure with frequent deadlines.
• Demonstrate critical thinking and analytical skills with attention to detail.
• Excellent problem-solving skills, with the ability to work independently as well as collaborating with others as and when needed.
• Ability to exercise confidentiality and professionalism in the workplace.

Working For Pacific Life Re

Every person in our global team is valued for the unique qualities they bring to our business and we seek to build their expertise and support their individual ambitions at every step. Of course, we take our work seriously and we know our team can operate under great pressure. We work hard and thrive on achievement, but we also know how to have fun and relax too. We regularly host a range of team building days to strengthen our team's connection with each other and reflect on their successes.

Providing employees with a healthy work-life balance is very important to our culture. We have a wide range of employee benefits and we host regular social activities and well being initiatives. We are also committed to supporting our employee's involvement in their communities, by actively fundraising, hosting charity events and overseeing volunteering opportunities.

Benefits (Only For Permanent And Fixed Term Employees)
• Stakeholder Pension Scheme
• Life Assurance
• Subsidised Gym Membership
• Private Medical Insurance
• Season Ticket Loan
• Eye Care
• Employee Assistance Programme
• Group Income Protection
• Wellness Benefits

As part of our commitment to diversity and inclusion, we will provide reasonable adjustments during the recruitment process to ensure equal access to applicants with disabilities. Please contact us about your needs so that we can discuss these with you to make sure that suitable adjustments are made, where possible.

Pacific Life Re Principles and Behaviours

Please click here to view our company principles and behaviours