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 confidently and effectively
• Able to prioritise work effectively
• Customer focussed
• Flexible approach to work - team player
• Adaptable to changing environment
• Self-motivated
• Embraces continuous learning
• Previous experience working in an e-commerce and/or financial services business
• Ability to use Docker and container orchestration tools
• AWS cloud infrastructure including AWS CDK
• MS SQL
• No SQL database such as Mongo
• AI Tools such as CoPilot, Snowflake Cortex