DataEngineer

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 sk