SQL Developer | S | Financial Crime CoE | Milton KeynesCountry: United Kingdom
Interested in part-time, job-share or flexible working? We want to talk to you!
Join our community.
We have multiple exciting opportunities for SQL Developers to join the Data and Analytics team, supporting the Data Analysis and Management Information needs of Santander’s Financial Crime CoE function.
You will play an active part in analysing complex data sets from Legacy systems and the Bank’s core Data Lake. You will be responsible for building Remediation populations and data driven efficiency improvements, designing, and implementing solutions as required.
The difference you will make.
1. Supporting the Data Analysis & Management Information requirements for all Remediation, Rectification and Financial Crime Projects
2. Supporting and creation of tools for Operational areas
3. Extracting and analysing large volumes of data from the bank’s data lake and various legacy platforms
4. Helping to expand the existing data warehouse - reporting through MS SSRS and Tableau
5. Supporting BAU & Operational needs with data driven efficiency improvements
What you will bring.
6. Extensive SQL Server experience
7. Experience writing complex SQL queries
It would also be nice for you to have.
8. Data modelling experience (Both dimensional and OLTP)
9. Experience with Impala – creating queries with efficient execution plans
10. Experience with reporting tools (preference of Tableau & SSRS)
11. Proven track record of automating manual processes
12. Data warehousing experience (preferred Kimball)
13. Experience of configuring server/environments would be advantageous
What else you need to know.
We want our people to thrive at work and home, and we recognise that many people benefit from flexible arrangements. To enable us to deliver the best outcomes for our customers and to help each other develop we understand the importance of having the right balance of spending time togetherin an office while maintaining flexibility.
By working this way, we can continue to create moments that matter for everyone. To support this, we offer site-based contracts with a hybrid working pattern and we’re happy to discuss specific requirements throughout the recruitment process.
Our preferred location for this role is Milton Keynes andcurrent expectation is at least days in an office every week. We would also encourage you to apply if you are in a reasonable travel distance of Glasgow, Bradford or Sheffield
Ifyou’re interested in this role but with part time hours or a job-share we would still love to hear from you and discuss these.
Application process
If your application is successful a member of our recruitment team will be in touch. We will arrange a short call with you to learn more about you and what you are looking for from your next career move, as well as answer any questions you have about working in the Santander tech team. If both sides agree we will send your CV to the hiring manager to review. For this position, the interview process will be:
st Stage – Technical assessment
nd Stage – A one-hour formal interview where we will ask both technical and competency-based questions. This can be done virtually or face to face depending on your situation.
If there’s anything we can do in the recruitment process to help you achieve your best, please let us know.
Inclusion
At Santander we’re creating a thriving workplace where all colleagues feel they belong and are supported to succeed. We all help to make Santander a workplace that celebrates diversity and attracts, retains, and develops the most talented and committed people through living our values of Simple, Personal, and Fair.
How we’ll reward you
As well as a competitive salary, you’ll enjoy a benefits package that you can tailor to your needs.
14. Eligible for a discretionary performance-related annual bonus
15. We put % of salary into your pension, even if you don’t contribute yourself. We’ll pay in up to .% of salary, if you contribute as well, and you can take some of our contribution in cash if you prefer.
16. days’ holiday plus bank holidays, which increases to days after yrs service, with the option to purchase up to contractual days per year
17. £, car allowance per year
18. Company funded individual private medical insurance
19. Voluntary healthcare benefits at discounted rates such as private medical insurance for your family, dental insurance, healthcare cash plan and health assessments
20. Benefits supporting you and your family, such as death-in-service benefit, income protection, and voluntary life assurance and critical illness cover
21. Share in Santander’s success by investing in our share plans
What to do next: