Data Engineer

AI overview

Contribute to the development of a state-of-the-art data platform while collaborating with stakeholders and utilizing cutting-edge technologies like Snowflake and Python.

Purpose of the role

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 us

AJ Bell is one of the fastest-growing investment platform businesses in the UK offering an award-winning range of solutions that caters for everyone, from professional financial advisers to DIY investors with little to no experience. We have over 644,000 customers using our award-winning platform propositions to manage assets totalling more than £103.3 billion. Our customers trust us with their investments, and by continuously striving to make investing easier, we aim to help even more people take control of their financial futures.

Having listed on the Main Market of the London Stock Exchange in December 2018, AJ Bell is now a FTSE 250 company.

Headquartered in Manchester with offices in central London and Bristol, we now have over 1,500 employees and have been named one of the UK's 'Best 100 Companies to Work For’ for six consecutive years and in 2024 named a Great Place to Work®.

At AJ Bell you can expect a friendly working environment with a strong sense of teamwork, we have a great sense of pride in what we do, and this is reflected in our guiding principles.

Our perks and benefits

  • Competitive starting salary
  • Starting holiday entitlement of 25 days, increasing up to 31 days with length of service and a holiday buy and sell scheme
  • A choice of pension schemes with matched contributions up to 6%
  • Discretionary bonus scheme
  • Annual free share awards scheme
  • Buy As You Earn (BAYE) Scheme
  • Health Cash Plan – provided by SimplyHealth
  • Private healthcare scheme and dental plan
  • Free gym membership
  • Employee Assistance Programme
  • Bike loan scheme
  • Sick pay+ pledge
  • Enhanced maternity, paternity, and shared parental leave
  • Loans for travel season tickets
  • Death in service scheme
  • Paid time off for volunteer work
  • Charitable giving opportunities through salary sacrifice
  • Calendar of social events, including monthly payday drinks, annual Christmas party, summer party and much more
  • Ongoing technical training
  • Professional qualification support
  • Talent development programmes
  • Peer recognition scheme, with rewards including restaurant and shopping vouchers or time off
  • Monthly leadership breakfasts and lunches

Hybrid working

At AJ Bell, our people are the heart of our culture. We believe in building strong connections by working together. That's why we offer a hybrid working model, where you’ll spend a minimum of 50% of your working time per month in the office. For new team members, an initial period will be full-time in the office to help you immerse yourself in our business and build valuable relationships with your colleagues.

AJ Bell is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and all employees are empowered to bring their whole self to work.

Perks & Benefits Extracted with AI

  • Education Stipend: Ongoing technical training, professional qualification support
  • Health Insurance: Private healthcare scheme and dental plan
  • Other Benefit: Employee Assistance Programme
  • Paid Time Off: Starting holiday entitlement of 25 days, increasing up to 31 days with length of service and a holiday buy and sell scheme
  • Wellness Stipend: Free gym membership

We're now recruiting a Head of Customer Marketing (D2C) to be responsible for the acquisition, engagement and analysis of customers across the AJ Bell retail platform, taking ownership for the deployment of the company’s acquisition strategy, with a lens on delivering excellent customer outcomes and marketing budget. Working directly with the Head of Brand and Marketing Director, the role requires an excellent understanding of brand, marketing and customer behaviours in a digital marketing environment. The position is a strategically senior role, leading the setting of acquisition budgets, communication with customers, deployment of marketing spend and analysis of customer data whilst providing leadership of the retail customer team.What does the job involve?Overall responsibility for creation and deployment of customer acquisition budgetsResponsibility for retail customer communications strategy, with a focus on giving clear and accurate informationLeadership of retail customer team.Deployment of marketing spend to achieve agreed customer acquisition and cross-sell targetsAnalysis of customer behaviour trends, including presentations to executive management and BoardOwnership of media buying agency relationshipOwnership of internal relations with Brand, Product, Strategic Partnerships and Strategic Planning & GovernanceInteraction with Strategic Partnerships on customer pricing and retention strategiesSupporting and enabling the business to deliver good outcomes for retail customers by helping achieve any regulatory requirements, including consumer duty.Key Responsibilities:Execution of customer acquisition strategy, in line with regulatory requirementsWorking with Brand to maximise new funded customer conversionsDelivery of customer communicationsManagement of customer marketing teamReporting and development of customer behaviour modelsParticipation in senior management function for D2C platformCreation and delivery of MI reports for areas of responsibilityAbout you:You'll have the ability to acquire customers effectively in a heavily regulated environmentExcellent knowledge of customer marketing techniques in a digital marketing settingStrong leadership skills and ability to drive results against agreed budget envelopesAbility to negotiate effectively with external partiesEffective management of internal relationships across both D2C and Advised platformsAbility to anticipate trends in customer needsExcellent statistical knowledge and ability to communicate complex data effectively.Strategic planning skillsAbout us:AJ Bell is one of the fastest-growing investment platform businesses in the UK offering an award-winning range of solutions that caters for everyone, from professional financial advisers, to DIY investors with little to no experience. We have over 484,000 customers using our award-winning platform propositions to manage assets totalling more than £76.2 billion. Our customers trust us with their investments, and by continuously striving to make investing easier, we aim to help even more people take control of their financial futures.Having listed on the Main Market of the London Stock Exchange in December 2018, AJ Bell is now a FTSE 250 company.Headquartered in Manchester with offices in central London and Bristol, we now have over 1300 employees and have been named one of the UK's 'Best 100 Companies to Work For’ for six consecutive years.What we offer:Starting salary of £90,000 - £110,000 (DOE)Generous holiday allowance increasing up to 31 days with service, plus bank holidaysHoliday buy/sell schemeHybrid working policyCasual dress codeDiscretionary bonusContributory pension schemeHealthcare Cash PlanBuy as you earn share schemeFree annual share schemePaid study support for qualificationsEnhanced maternity/paternity scheme from day oneBike loanSeason ticket loan portalDiscounted PMI and DentalFree gymPaid volunteering opportunities, free social events and moreAJ Bell is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and all employees are empowered to bring their whole self to work.We do not discriminate on the basis of race, sex, gender identity, sexual orientation, age, pregnancy, religion, physical and mental disability, marital status and any other characteristics protected by the Equality Act 2010. All decisions to hire are based on qualifications, merit and business need.

View all jobs
Get hired quicker

Be the first to apply. Receive an email whenever similar jobs are posted.

Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Data Engineer Q&A's
Report this job
Apply for this job