SQL Developer | S3 | Financial Crime CoE | Milton Keynes Milton Keynes, England
Job description
WHAT YOU WILL BE DOING
Join our community.
This role is offered on a site-based contract with a hybrid working pattern, which can be discussed with the recruitment team during the hiring process.
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.
Supporting the Data Analysis & Management Information requirements for all Remediation, Rectification and Financial Crime Projects.
Supporting and creation of tools for Operational areas.
Extracting and analysing large volumes of data from the bank’s data lake and various legacy platforms.
Helping to expand the existing data warehouse - reporting through MS SSRS and Tableau
Supporting BAU & Operational needs with data driven efficiency improvements.
What you will bring.
Extensive SQL Server experience.
Experience writing complex SQL queries.
It would also be nice for you to have.
Data modelling experience (Both dimensional and OLTP)
Experience with Impala – creating queries with efficient execution plans.
Experience with reporting tools (preference of Tableau & SSRS)
Proven track record of automating manual processes.
Data warehousing experience (preferred Kimball)
Experience of configuring server/environments would be advantageous.
What else you need to know.
The is a permanent role which can be located in any of our national offices: Milton Keynes, Glasgow, Bradford or Sheffield. You will be expected to attend the office 40% of the time.
We can support flexible working depending on your requirements.
Everyday 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.
Eligible for a discretionary performance-related annual bonus
We put 8% of salary into your pension, even if you don’t contribute yourself. We’ll pay in up to 12.5% of salary, if you contribute as well, and you can take some of our contribution in cash if you prefer
30 days’ holiday plus bank holidays, which increases to 31 days after 5yrs service, with the option to purchase up to 5 contractual days per year
£6,000 car allowance per year
Company funded individual private medical insurance
Voluntary healthcare benefits at discounted rates such as private medical insurance for your family, dental insurance, healthcare cash plan and health assessments
Benefits supporting you and your family, such as death-in-service benefit, income protection, and voluntary life assurance and critical illness cover
Share in Santander’s success by investing in our share plans
What to do next.
If this sounds like a role you’re interested in, then please apply.
If there’s anything we can do in the recruitment process to help you achieve your best, get in touch. Whether it’s a copy of our application form in another format or additional assistance, we’re available through telephone, email, or face to face. You can contact us at [email protected] or call 0870 414 9080.
