Data Warehouse Engineer

Role: Data Warehouse Engineer Location: London, 2 days per week on site required Rate: £450.00 - £500.00 per day (umbrella) Contract Type: 12-month Contract Role Overview: We are seeking a skilled Data Warehouse Enigneer to assist with upgrading the Lease Finance Data Warehouse (LF DW). You will play a crucial role in upgrading data components, ETL processes, and tooling, following the upgrade of our underlying OLTP platforms. This position involves hands-on design and implementation, ensuring minimal disruption across the platform while delivering high-quality data solutions. Key Responsibilities: Design migration approaches for components impacted by the platform upgrade. Ensure alignment with the chosen approach to minimize downstream effects. Implement agreed designs for data migration and integration. Participate in peer reviews and collaborate with cross-functional teams. Build production-quality components to ensure the stability and scalability of the data warehouse. Essential Skills & Experience: Proficiency with Microsoft SQL Server (preferably 2019). Advanced T-SQL skills, with a proven ability to write complex functions and stored procedures. Experience in designing and implementing end-to-end data solutions. Hands-on experience with dbt or similar ETL tools. A successful track record delivering data solutions in the financial services sector. Expertise in data modelling, integration, and database systems. Strong analytical and problem-solving skills, with the ability to troubleshoot complex data issues. Experience working in an Agile environment (Scrum/Atlassian tooling). Excellent communication skills to explain designs to both technical and non-technical stakeholders. Why Join Us? Be part of a dynamic team working on cutting-edge financial services technology. Work in a collaborative, innovative environment with opportunities to grow your technical expertise. Flexible working arrangements and competitive compensation packages. If you're ready to take on this exciting challenge and contribute to the success of a key financial services platform, we'd love to hear from you! Candidates will ideally show evidence of the above in their CV to be considered please click the "apply" button. Please be advised if you haven't heard from us within 48 hours then unfortunately your application has not been successful on this occasion, we may however keep your details on file for any suitable future vacancies and contact you accordingly. Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive