Data Engineer

LGT Group; London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading company in wealth management is seeking a Data Engineer to join their Data Development team in London. The role involves designing and implementing data warehouse solutions, developing data pipelines, and optimizing data delivery. Candidates should have experience with Snowflake and data engineering best practices, contributing to high-profile initiatives that support business growth.

Qualifications

• At least 2 years' experience designing and implementing a full-scale data warehouse solution using Snowflake.
• Expertise with Snowflake internals and data processing integration.
• Experience in developing production-ready data processing pipelines using DBT.

Responsibilities

• Data warehouse design and implementation towards a single source of truth.
• Development of data ingestion/transformation pipelines using Fivetran and DBT.
• Creation of management information dashboards.

Skills

Data Modelling

Data Engineering

ETL Best Practices

Agile Methodology

Tools

Snowflake

DBT

Gitlab

Fivetran

Power BI

Job description

LGT Wealth Management UK LLP is a UK-based partnership, wholly owned by the private banking group LGT, which is in turn owned by the Princely Family of Liechtenstein. When we set up LGT Wealth Management in 2008, our aim was to offer a fresh approach to wealth management. Alongside the LLP we also have two other entities which focus on US and Jersey based clients. Our head office is based in London however we have a presence in Edinburgh, Jersey, Leeds, Birmingham, Bristol and Manchester. The plan was simple: put our clients first by providing a transparent service, designed around what is right for each of them. By drawing together in-depth knowledge and experience from across the industry, we provide a flexible, bespoke service adapted to each of our clients' needs.

Our mission is to create long-term value for all stakeholders. Our culture encourages individuals to generate, develop and implement ideas which will strengthen our business. Belonging, respect, integrity, conviction and entrepreneurship are our core values. As our brand recognition grows, we are fast becoming an employer of choice in our sector. We have over £30 billion in funds under management and circa 700 staff.
Job Description
Business Unit

Our ambitious growth strategy is underpinned by our commitment to enhance the client experience and deliver market leading personalised Wealth Management. We are embracing digital technology to help us achieve this ambition.

Our Technology team, co-located with our business in the heart of the City of London, is central to achieving this ambition. We are investing in a modern technology stack, adopting a product-based approach to development, and delivering solutions through an agile framework.

Our Technology team is responsible for:

• Software Development
• Data Engineering
• Infrastructure
• DevOps and Automation
• Service Delivery
• Project Management

Brief Role Objective:

As a member of the Data Development team, you will be responsible for developing ways to consolidate, analyse, and present our data to support the operations and future growth of our business. In this role you will be involved in a wide variety of high-profile business facing initiatives from developing data extracts and PowerBI reports to optimising the data warehouse to deliver data more quickly to the business each day. You will work with the Lead Data Engineer and other members of the Data Engineering team to deliver our new strategic enterprise data platform based on Snowflake and DBT, while also maintaining our legacy data platform.

Key Responsibilities:

• Data warehouse design and implementation working towards the creation of a single source of truth.
• Development of data ingestion/transformation pipelines using Fivetran, DBT and Gitlab.
• Creation of management information dashboards.
• Work with business analysts and end-users to plan and implement feature enhancements and changes to existing systems, processes and data warehouses.
• Working with internal staff and third parties (suppliers and partners) to plan and develop new databases, extracts and reports.
• Assist with the migration from legacy data platforms, software systems and reports to modem technologies.
• Create, test and maintain code in line with industry best practice and internal programming guidelines.
• Provide support of the systems developed to other IT teams and also to business users as required.
• Manage work using the JIRA project tracking software, ensuring all work completed is reflected in the tool.
• Able to work effectively and self-sufficiently in a fast-changing working environment.
• Adhere to all Information Security Policies.
• Completing other duties as directed.
• The nature of the role requires some work outside of normal business hours including weekends, evenings and public holidays.

Requirements

Key Skills and Competency Requirements:

• At least 2 years' experience designing and implementing a full-scale data warehouse solution using Snowflake
• Expertise and excellent proficiency with Snowflake internals and integration of Snowflake with other technologies for data processing and reporting.
• Data Modelling using the Kimball Methodology.
• Experience in developing production-ready data processing pipelines using DBT.
• Experience in developing CI/CD pipelines using Gitlab or similar.
• Comprehensive knowledge of data engineering, data modelling and ETL best practice
• Experience of working within a global team.
• Experience of working with multiple stakeholders as part of an Agile team.

Desirable Skills:

• Experience in developing production-ready data ingestion and processing pipelines using Python.
• Experience of ingesting data into a data platform using Fivetran.
• Experience of developing BI dashboards using Power BI.
• Knowledge of security concepts relevant to Azure.
• Experience of workflow management tools such as Apache Airflow.

Contact Information

We are looking forward to receiving your online application.

For any further information please do not hesitate to contact us.

LGT Wealth Management UK LLP
Human Resources
Alex Johnson