Data Engineer

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 workpleted is reflected in the tool. Able to work effectively and self-sufficiently in a fast-changing working environment. Adhere to all Information Security Policies. The nature of the role requires some work outside of normal business hours including weekends, evenings and public holidays.
Requirements

Key Skills andpetency 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. 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 Job ID JR6564