Data Transformation Engineer

3 weeks ago

London, Greater London, United Kingdom Pacific Life Full time
Job Title

Data Transformation Engineer

Job Description

Pacific Life Re is undertaking a major back-office transformation programme and has established a Divisional Data Team to develop and manage an enterprise-wide data solution, reporting services, and to embed best practice data governance. This team will support the business throughout its back-office transformation and will deliver significant improvement in efficiencies and the value derived from our data assets globally.

We are looking to appoint a Data Transformation Engineer; to support the definition and delivery of an enterprise data platform with engineering best practices. Specifically, this role will help the divisional data team (DDT) to understand, manage, and prioritise data engineering and transformation activities.

The role is reporting to the Senior Transformation Analyst, who is responsible for prioritising, planning, and development of the data engineering and transformation tasks required.

This role holder will build close working relationships with the DDT team and business units across our operating geographies and will be responsible for ensuring that technical requirements are clearly understood throughout the project lifecycle, and develop a data warehouse that empowers delivering reporting outputs that meet the needs of our internal customers.

Duties
  • Assist the senior transformation analyst with the delivery of data engineering activities.
  • Prepare technical design specifications based on functional requirements and analysis documents.
  • Implement, test, maintain, and support software, as outlined in technical design specifications.
  • Enhance system quality through identification of issues, common patterns, and formulation of standard operating procedures.
  • Support Business Control compliance through technology and ensure IT Controls are incorporated into Systems.
  • Review functional requirements, analysis, and design documents to provide pertinent feedback.
  • Provide technical support to customers, solving problems and answering queries.
  • Support testing and validation activities within data related projects and initiatives.
Qualifications & Experience
  • Proven experience in the market as a SQL and PLSQL developer.
  • Extensive experience with SQL cloud databases like Snowflake/Redshift/BigQuery/Azure SQL database and on-premise SQL databases like MS SQL Server, Teradata etc.
  • Azure DevOps experience is a plus.
  • Clear understanding of data modeling, data curation, and orchestration.
  • Experience with Business Intelligence tools like PowerBI is a plus.
  • Sound understanding of unit testing, test-driven development, functional testing, and performance aspects.
  • Knowledge of at least one shell scripting language.
  • Ability to network with key contacts outside of own expertise.
Technologies
  • SQL (On-premise or cloud)
  • ETL
Nice to haves
  • Snowflake
  • DBT
  • Azure DevOps
  • PowerBI/Tableau
  • SNP Glue/Matillion/FiveTran
  • SAP
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. 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 are also committed to supporting our employees' 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.

  • Data Transformation Specialist

    3 weeks ago

    London, Greater London, United Kingdom Data Idols Full time £90,000 - £110,000

    Data Transformation SpecialistAs a Data Transformation Specialist at Data Idols, you will play a key role in driving high standards across the data function. You will support the team in building pipelines to deliver insights enabling the company to be more data-driven with their decision-making. Key Responsibilities: Collaborate with the wider data teams to...

  • Data Transformation Specialist

    3 weeks ago

    London, Greater London, United Kingdom Data Idols Full time £90,000 - £110,000

    Data Transformation SpecialistAt Data Idols, we're seeking a skilled Data Transformation Specialist to support the delivery of data transformation during an exciting time within the company. As a key member of our data team, you will collaborate with the wider data teams to build and maintain data pipelines. Your extensive experience with data pipelines,...

  • Senior Data Engineer

    3 weeks ago

    London, Greater London, United Kingdom Data Idols Full time £75,000 - £95,000

    Senior Data EngineerJoin Data Idols as a Senior Data Engineer and support the delivery of data transformation during an exciting time. You will collaborate with the wider data teams to build and maintain reliable and high-quality data solutions. Strong experience in Python is required. You will play a key role in driving high standards across the data...

  • Data Engineer

    4 weeks ago

    London, Greater London, United Kingdom Data Idols Full time

    The OpportunityWe are seeking a highly skilled Staff Data Engineer to join our team at Data Idols. As a Staff Data Engineer, you will play a key role in driving high standards across the data function and supporting the delivery of data transformation during an exciting time within the company.You will collaborate with the wider data teams to build and...

  • Data Engineer

    4 weeks ago

    London, Greater London, United Kingdom Data Idols Full time

    The OpportunityWe are seeking a highly skilled Staff Data Engineer to join our team at Data Idols. As a Staff Data Engineer, you will play a key role in driving high standards across the data function and supporting the delivery of data transformation during an exciting time within the company.You will collaborate with the wider data teams to build and...

  • Senior Data Engineer

    4 weeks ago

    London, Greater London, United Kingdom Data Idols Full time £75,000 - £95,000

    Senior Data EngineerJoin Data Idols, a renowned retail brand in the UK, as a Senior Data Engineer and play a pivotal role in shaping the company's data transformation journey. We're seeking an experienced professional with a strong background in building and maintaining data pipelines to collaborate with our data teams.Key Responsibilities:Design and...

  • Senior Data Engineer

    4 weeks ago

    London, Greater London, United Kingdom Data Idols Full time £90,000 - £110,000

    Join Data Idols as a Staff Data Engineer and be part of an exciting journey in the retail industry. As a key member of the data team, you will play a crucial role in delivering high-quality data transformation solutions. Your expertise in building and maintaining data pipelines, data warehousing, and driving standards across the data function will be...

  • Data Engineering Manager

    6 days ago

    London, Greater London, United Kingdom Data Idols Full time £90,000 - £95,000

    The OpportunityData Idols is seeking a Data Engineering Manager to support the delivery of data transformation during an exciting time within the company. This individual will work with the teams to implement data strategy and deliver value throughout the company.The ideal candidate will have extensive experience in managing teams, stakeholder management,...

  • Data Engineering Manager

    4 weeks ago

    London, Greater London, United Kingdom Data Idols Full time

    Data Engineering ManagerJoin Data Idols in this exciting opportunity to support the delivery of data transformation at one of the UK's best-known retail brands. As a Data Engineering Manager, you will work closely with teams to implement data strategy and drive value throughout the company.The OpportunityWe are seeking a seasoned Data Engineering Manager...

  • Data Engineering Manager

    4 weeks ago

    London, Greater London, United Kingdom Data Idols Full time

    Data Engineering ManagerJoin Data Idols in this exciting opportunity to support the delivery of data transformation at one of the UK's best-known retail brands. As a Data Engineering Manager, you will work closely with teams to implement data strategy and drive value throughout the company.The OpportunityWe are seeking a seasoned Data Engineering Manager...

  • Senior Data Engineer

    4 weeks ago

    London, Greater London, United Kingdom Data Idols Full time

    Unlock Your Potential as a Senior Data EngineerJoin Data Idols, a renowned retail brand, as a Senior Data Engineer and contribute to the delivery of data transformation during an exciting period of growth. Collaborate with the wider data teams to build and maintain data pipelines that drive high standards across the data function.The OpportunityAs a Senior...

  • Senior Data Engineer

    4 weeks ago

    London, Greater London, United Kingdom Data Idols Full time £75,000 - £95,000

    Senior Data EngineerJoin Data Idols, one of the UK's most renowned retail brands, as a Senior Data Engineer and play a pivotal role in shaping the company's data transformation journey.We're seeking an experienced professional with a strong background in building and maintaining data pipelines and collaborating with cross-functional data teams.As a Senior...

  • Senior Data Engineer

    4 weeks ago

    London, Greater London, United Kingdom Data Idols Full time £75,000 - £95,000

    Senior Data EngineerJoin Data Idols, one of the UK's most renowned retail brands, as a Senior Data Engineer and play a pivotal role in shaping the company's data transformation journey.We're seeking an experienced professional with a strong background in building and maintaining data pipelines and collaborating with cross-functional data teams.As a Senior...

  • Senior Data Engineer

    2 months ago

    London, Greater London, United Kingdom Data Idols Full time £75,000 - £95,000

    Unlock Data-Driven Decision MakingJoin Data Idols as a Senior Data Engineer and contribute to the delivery of data transformation during an exciting time. Collaborate with the wider data teams to build and maintain reliable and high-quality data solutions.The OpportunityAs a Senior Data Engineer, you will play a key role in driving high standards across the...

  • Senior Data Engineer

    2 months ago

    London, Greater London, United Kingdom Data Idols Full time £75,000 - £95,000

    Unlock Data-Driven Decision MakingJoin Data Idols as a Senior Data Engineer and contribute to the delivery of data transformation during an exciting time. Collaborate with the wider data teams to build and maintain reliable and high-quality data solutions.The OpportunityAs a Senior Data Engineer, you will play a key role in driving high standards across the...

  • Big Data Engineering Manager

    4 weeks ago

    London, Greater London, United Kingdom Data Science Festival Full time

    Data Engineering Manager OpportunityWe are seeking a highly skilled Data Engineering Manager to join our team at Data Science Festival. As a key member of our data engineering team, you will play a crucial role in supporting the delivery of data transformation and implementing data strategy.About the RoleThis is a hands-off leadership position, requiring a...

  • Big Data Engineering Manager

    4 weeks ago

    London, Greater London, United Kingdom Data Science Festival Full time

    Data Engineering Manager OpportunityWe are seeking a highly skilled Data Engineering Manager to join our team at Data Science Festival. As a key member of our data engineering team, you will play a crucial role in supporting the delivery of data transformation and implementing data strategy.About the RoleThis is a hands-off leadership position, requiring a...

  • Data Engineer

    4 weeks ago

    London, Greater London, United Kingdom she does data. Full time £20,000

    Job DescriptionWe are seeking a highly skilled Data Engineer to join our team at Mirai. As a Data Engineer, you will play a crucial role in designing, building, and maintaining our data infrastructure to support our business operations.Key ResponsibilitiesDesign and develop data pipelines to extract, transform, and load data from various sourcesDevelop and...

  • Data Engineer

    4 weeks ago

    London, Greater London, United Kingdom she does data. Full time £20,000

    Job DescriptionWe are seeking a highly skilled Data Engineer to join our team at Mirai. As a Data Engineer, you will play a crucial role in designing, building, and maintaining our data infrastructure to support our business operations.Key ResponsibilitiesDesign and develop data pipelines to extract, transform, and load data from various sourcesDevelop and...

  • Senior Data Engineer

    5 days ago

    London, Greater London, United Kingdom Data Idols Full time £75,000 - £95,000

    Data Engineering Role at Data IdolsJoin Data Idols, a renowned retail brand in the UK, as a Senior Data Engineer and contribute to the delivery of data transformation during an exciting period of growth. The ideal candidate will have extensive experience in building and maintaining data pipelines and collaborating with cross-functional data teams.About the...