SonicJobs Logo
Left arrow iconBack to search

SQL Data Engineer

Pontoon
Posted a day ago, valid for 24 days
Location

London, Greater London EC1R 0WX

Salary

£500 - £550 per day

Contract type

Full Time

In order to submit this application, a Reed account will be created for you. As such, in addition to applying for this job, you will be signed up to all Reed’s services as part of the process. By submitting this application, you agree to Reed’s Terms and Conditions and acknowledge that your personal data will be transferred to Reed and processed by them in accordance with their Privacy Policy.

Sonic Summary

info
  • The role of Data Warehouse Engineer is based in London, requiring two days per week on-site attendance.
  • The contract is for 12 months with a daily rate of £500.00 to £550.00 (umbrella).
  • Candidates should have experience in designing and implementing end-to-end data solutions, particularly in the financial services sector.
  • Proficiency with Microsoft SQL Server and advanced T-SQL skills are essential, along with hands-on experience in ETL tools like dbt.
  • Strong analytical skills and a successful track record in delivering data solutions are required, ideally with experience in an Agile environment.

Role: Data Warehouse Engineer

Location: London, 2 days per week on site required

Rate: £500.00 - £550.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.

Apply now in a few quick clicks

In order to submit this application, a Reed account will be created for you. As such, in addition to applying for this job, you will be signed up to all Reed’s services as part of the process. By submitting this application, you agree to Reed’s Terms and Conditions and acknowledge that your personal data will be transferred to Reed and processed by them in accordance with their Privacy Policy.