Expire in: a month
Job Title: Senior SQL & SSIS Data Engineer (Data warehouse)
Contract Length: 6 Months (possibility for perm)
Location: London (5 days in 10 )
Working Pattern: Full Time
Rate: Highly competitive rate available for suitable candidates
Are you a data wizard ready to take on a challenging role in a dynamic Data Warehouse team? Our client is on the lookout for a talented Senior Data Engineer with a passion for SQL and SSIS development. Join us for a thrilling 6-month journey focused on optimising our existing SQL Server 2019 data warehouse environment, which is poised for transformation!
About the Role
In this hands-on, technical position, you will take ownership of a significant portfolio of around 90 SSIS batch jobs. You'll dive deep into performance analysis, tackle existing technical debt, and implement best practises that will elevate our data operations. Your expertise will be crucial as we gear up for an exciting data warehouse migration from New York to London in 2026!
Key Responsibilities
Analyse and optimise SSIS ETL pipelines and batch jobs.
Improve SQL performance through effective indexing and execution plans.
Identify and resolve locking and blocking issues to enhance efficiency.
Apply best practises to boost overall warehouse performance.
Work independently to drive optimisation initiatives.
Collaborate with senior developers for insightful technical reviews.
Support and prepare for upcoming migration activities.Required Skills
Expert-level SQL proficiency (SQL Server 2019 on-prem) Data Warehousing and PowerBI is essential
Strong SSIS development and optimisation experience is essential.
Solid experience with SSAS and SSRS tools.
Deep understanding of execution plans and performance tuning techniques.
Strong troubleshooting and problem-solving skills.
Proven history of improving complex ETL environments.Nice to Have
Experience with C# for SSIS scripts.
Proficiency in Python.
Exposure to Power BI for data visualisation.Why Join Us?
Be part of a vibrant team that values innovation and collaboration.
Contribute to a significant migration project that will make a real impact.
Enjoy a hybrid working arrangement that promotes work-life balance.
Opportunities for contract extensions based on performance.If you're ready to unleash your data engineering skills and make a meaningful difference, we want to hear from you! Apply today and embark on an exciting journey with us as we transform our data landscape.
Let's shape the future of our data together!
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. If you require reasonable adjustments at any stage, please let us know and we will be happy to support youDo not include the following in your job application, CV, or cover letter:
You should not be asked for payment or irrelevant information. If you have concerns about a job advert or employer, seek guidance on how to proceed.
Looking for your next career move? Join a top company hiring Senior SQL & SSIS Data Engineer (Data warehouse) job near me in London! This is your chance to work on exciting projects, grow professionally, and enjoy a rewarding career with competitive pay and excellent benefits. Whether you're an experienced professional or looking to take the next step, this role offers the perfect opportunity to enhance your skills and make an impact. Don’t miss out—apply today via Vita CV and take your career to the next level!
© Vita CV: Registered in England and Wales (16187919).
Vita CV uses cookies to enhance your experience, analyze site traffic, and personalize content. By continuing to browse, you agree to our use of cookies.