Data Engineer

Job Description

This is an exciting opportunity to join a dynamic and experienced Data Engineering team at AJ Bell, contributing significantly to the development of our state-of-the-art data platform using cutting-edge technology. As a Data Engineer, you will play a pivotal role in designing, building, maintaining, and evolving our data infrastructure, ensuring it meets the growing needs of our business. You'll engage in end-to-end development, collaborate closely with key stakeholders and internal customers, and empower the organisation by enabling informed, data-driven decision-making.

What does the job involve?

The key responsibilities of the role are as follows:

Collaborating with stakeholders to identify and refine data requirements, ensuring data is accessibility and alignment with business needs.

Developing Data Warehousing solutions.

Automating extract, load and transform (ELT) pipelines that follow modern CI/CD practices.

Data Integration Design – Ensure development is scalable, efficient and future-proof.

Data Modelling – Producing clear data models where necessary.

Maintaining and continuously enhancing the data platform.

Provisioning data from various sources.

Create automated tests to ensure quality and integrity of data.

Ensure data is compliant with AJ Bell’s Data Governance and Data Classification policies.

Maintain data dictionary.

Maintain business level data model.

Recommending and introducing new technology where needed.

Core:

Cloud data platforms (e.g. Snowflake, BigQuery, Redshift)

Data transformation technology such as DBT

Visual Studio Code

Python

CI automation systems such as Jenkins

A git-based source control system such as BitBucket

Data Warehouse/Kimball methodology

Data replication technology such as Fivetran HVR.

Excellent problem-solving skills.

Good communication skills and comfortable working with both technical and non-technical teams

Other:

Good knowledge of IT products and systems

Good analytical skills

Excellent communication skills verbal and written

Able to communicate with people at all levels co...