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
About AJ Bell
AJ Bell is one of the UK’s fastest-growing investment platform businesses, providing award-winning solutions for everyone, from professional financial advisers to first-time investors.
Today, over 723,000 customers trust us to manage more than £108.7 billion of assets. By continually striving to make investing simpler and more accessible, we’re helping more people take control of their financial futures.
We’re proud to be recognised as one of the UK’s Best 100 Companies to Work For for six consecutive years, and a Great Place to Work® in 2025 and 2026 a reflection of our supportive and collaborative culture.
What we offer
- 25 days holiday, increasing with service + buy/sell scheme + bank holidays
- 6% Pension with matched contributions
- Discretionary bonus scheme
- Share schemes (including free shares and BAYE)
- Health Cash Plan and discounted private healthcare
- Free onsite gym
- Enhanced family leave (subject to qualifying criteria)
- Travel and bike loan schemes
- Employee Assistance Programme
Life at AJ Bell
- Regular social events including summer and Christmas parties
- Learning and development opportunities tailored to you
- Casual dress code
- Friendly, supportive team environment
Our ways of working
We offer hybrid working, with a minimum of 50% of your working time per month spent in the office.
For new starters, there’s an initial period of full-time office working to help you settle in and build relationships.
Inclusion & diversity
We’re committed to creating an inclusive environment where everyone feels respected and able to be themselves at work.
We welcome applications from all backgrounds and make hiring decisions based on skills, experience and potential.
Skills Required
- Experience with cloud data platforms like Snowflake, BigQuery, or Redshift
- Proficiency in data transformation technology such as DBT
- Ability to use Python for data engineering tasks
- Experience with CI automation systems such as Jenkins
- Familiarity with data warehousing and Kimball methodology
- Experience with Docker and container orchestration tools
- Knowledge of No SQL databases like Mongo
- Experience in e-commerce or financial services business
What We Do
AJ Bell was formed in 1995 and is now one of the leading online investment platforms in the UK. We provide customers and advisers with wide investment choice, low-cost delivery, market leading online functionality and first class service to help them manage investment portfolios within SIPPs, ISAs and Dealing accounts. We are a fast growing and profitable company, with over 484,000 customers and £76.2 billion of assets under administration. We are part of the FTSE 250 on the Main Market of the London Stock Exchange.
