Data Engineer

• We collaborate with stakeholders to identify and refine data requirements, ensuring data accessibility and alignment with business needs.
• We develop data warehousing solutions.
• We automate extract, load and transform (ELT) pipelines using modern CI/CD practices.
• We design scalable, efficient and future-proof data integrations.
• We produce clear data models where necessary.
• We maintain and continuously enhance our data platform.
• We provision data from various sources.
• We create automated tests to ensure data quality and integrity.
• We ensure data complies with our Data Governance and Data Classification policies.
• We maintain the data dictionary and business-level data model.
• We recommend and introduce new technology where needed.

Technologies:

• AI
• AWS
• Redshift
• BigQuery
• BitBucket
• CI/CD
• Cloud
• Copilot
• Data Warehouse
• Docker
• Fivetran
• Git
• Jenkins
• MongoDB
• NoSQL
• Python
• SQL
• Snowflake
• Visual Studio
• dbt

More:

We are AJ Bell, a fast-growing UK investment platform business helping people invest with confidence through easy-to-use ISA, pension and dealing account solutions. Our Data Engineering team is working on a state-of-the-art data platform using cutting-edge technology, and this role offers the chance to contribute end-to-end while working closely with stakeholders and internal customers. We offer a supportive and collaborative culture, hybrid working with at least 50% of your time in the office each month, and an initial full-time office period for new starters. Our benefits include 25 days holiday plus bank holidays and a buy/sell scheme, 6% pension with matched contributions, discretionary bonus, share schemes, health cash plan, discounted private healthcare, free onsite gym, enhanced family leave, travel and bike loan schemes, an employee assistance programme, regular social events, learning and development opportunities, and a casual dress code. We are proud to be recognised as one of the UKs Best 100 Companies to Work For and a Great Place to Work, and we are committed to inclusion, diversity and welcoming applications from all backgrounds.

• We are looking for experience with cloud data platforms such as Snowflake, BigQuery or Redshift.
• We need experience with data transformation tools such as DBT.
• We require proficiency in Visual Studio Code and Python.
• We are looking for experience with CI automation systems such as Jenkins and git-based source control such as Bitbucket.
• We need knowledge of Data Warehouse and Kimball methodology.
• We value experience with data replication tools such as Fivetran or HVR.
• We are looking for strong problem-solving skills.
• We need good communication skills and the ability to work confidently with both technical and non-technical teams.
• We value good knowledge of IT products and systems.
• We are looking for strong analytical skills and the ability to prioritise work effectively.
• We need a customer-focused, flexible, adaptable and self-motivated team player.
• We value an appetite for continuous learning.
• We prefer experience in e-commerce and/or financial services.
• We value experience using Docker and container orchestration tools.
• We require experience with AWS cloud infrastructure, including AWS CDK.
• We need experience with MS SQL and NoSQL databases such as MongoDB.
• We value familiarity with AI tools such as Copilot and Snowflake Cortex.