Technical Architect - SC ClearedA technical architect is required for a client based in London.You will have strong stakeholder engagement skills and work collaboratively to assess integration into the product roadmap. Responsibilities: Low-level design and build, ensuring best practices for reusable pipelines and data models. Leveraging an appropriate technology stack to build high performance, reusable, self service pipelines for automating Extract Load configurations. Defining infrastructure for data pipelines using AWS technologies (eg, S3, Glue, Athena). Casting, cleaning, testing, and modelling loaded data using dbt, following a Kimball Dimensional Model architecture. Migrating extract/load pipelines from Airflow infrastructure, including defining a robust testing approach. Re architecting pipelines from ETL to ELT, leveraging dbt for dimensional modelling and transformation.Skills: AWS technology including S3, Glue, Athena Python Airflow infrastructure ETL The role requires two days on site in London every week and is inside IR35. To be considered please forward your CV. Due to the nature and urgency of this post, candidates holding or who have held high level security clearance in the past are most welcome to apply. Please note successful applicants will be required to be security cleared prior to appointment which can take up to a minimum 10 weeks. LA International is a HMG approved ICT Recruitment and Project Solutions Consultancy, operating globally from the ..... full job details .....