Data Warehouse Developer (On-premise)

An exciting opportunity has arisen for an experienced Data Engineer / Data Warehouse Developer to join a well-established Financial Services organisation in their Central London office - they operate a hybrid working model, and you will spend 2-3 days per week in their modern office to collaborate with your team.Following a recent company acquisition, they have kicked-off a large integration programme of work, including a large-scale Data Warehouse integration project. This will be a core focus of your role, and will involve uplifting and redeveloping their existing Data Warehouse to serve the needs of both entities.The role requires extensive experience with SSIS to uplift, re-build and optimise ETL processes, ensuring seamless data ingestion, analysis and integration from various source systems, into their unified Data Warehouse. You'll ensure the stability and scalability of the Data Warehouse, ensuring it can handle increasing data volumes and user demands.In doing so, you'll collaborate closely with the wider data and development team, subject matter experts and business stakeholders.This role would be well-suited to a Developer with strong T-SQL and SSIS skills, who is keen to play a key role in a large-scale and transformative Data Warehousing initiative.Requirements:Extensive T-SQL programming skills - writing complex scripts, developing and optimising stored procedures etc.Extensive SSIS skills - to rebuild and optimise ETL processesExperience with Data Warehouse developmentSome experience in scripting with PowerShell, C# and PythonExperience in Financial Services would be beneficial but not essentialExperience with WhereScape Red would be beneficial but not essentialExcellent communication and interpersonal skills, with the ability to collaborate effectively with diverse stakeholders and work in a team-oriented environmentBenefits: Salary from £55-70,000 depending on level of experience25 days annual leave, increasing with tenure, with option to buy & sell daysContributory pension schemePrivate medical insuranceLife assuranceOther optional add-ons Please Note: This is role for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check.Tenth Revolution Group (and Nigel Frank) are the go-to recruiter for Power BI and Azure Data Platform roles in the UK, offering more opportunities across the country than any other. We're the proud sponsor and supporter of SQLBits, and the London Power BI User Group. To find out more and speak confidentially about your job search or hiring needs, please contact me directly at