Senior Data Engineer London (GB)

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 and Bristol. 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 £29 billion in funds under management and circa 700 staff.

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 senior 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 design and 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.
• Contributing to the architectural design of the new Enterprise Data Platform.
• Contributing to development best practices.
• Mentoring junior data engineers.
• 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.

Key Skills and Competency Requirements:

• At least 3 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.