Within the COO/Group Services/Risk organisation, the Asset & Liability Management (ALM) team is looking for a senior Designer and Developer to join our team to fully re-design the current Data Staging Area, and to integrate currently separate ETL flows. The senior Designer and Developer needs to be ‘hands-on’, capable to oversee complex data flow structures and needs to be experienced with large data volumes.Your work environmentTo enable ING’s monthly financial forecasting processes and to support ING stress tests, the ALM platform has been set up. The ALM platform consists of a Data Staging Area built in MS SQL Server and C#, which extracts, transfers monthly financial data. The data is loaded in an application. The application is used by ING business lines, Financial Risk, Finance and Bank Treasury to calculate and to report on financial forecasts, and ING stress tests.Further development of the ALM platform has been prioritised by higher management as one of ING’s most important strategic worldwide objectives. Currently, the ALM platform is being transformed into a group-wide standard to support global and local requirements, and step by step new countries are on-boarded. For the Data Staging Area, this means that data of countries with different financial products needs to be aligned, enriched, transformed and functionality needs to be built to analyse or monitor unexpected differences between data.Your ALM squad is a BusDevOps team, combining expertise of business, IT and OPS specialists. The squad works according to Agile scrum, which means that work is sliced and planned in sprints, and as part of the team you take responsibility to deliver value according to sprint planning. Together with your squad/team, you are responsible to (re-)design a stable, standardized and consistent ALM platform. And together with all stakeholders, you jointly work towards the combined goal: have all the ING offices worldwide use one ALM standard.Job description:Main services delivered by you are:
Set up a step by step approach, and fully re-design the current Data Staging Area, in the following way:
Improve and simplify data loads and ETL processes, despite of differences and variety in country data
Design, develop, configure and test secure software automation solutions in SQL Server and where applicable, SSIS and C#
Change data flows, tables, and interfaces, make existing data flows more transparent. Work towards a simple and robust solution with functionality to identify and analyse unexpected differences in data in an early stage. Together with a colleague developer/DBA-er, improve maintainability and performance of the Data Staging Area
Maintainable
High performance
Carry out a senior engineer role, e.g.:
If requested, advice business or operation colleagues e.g. at identifying root causes for incidents related to data errors. Give advice about the data to be processed to architects and other developers at a current project to set up a BI layer to improve reporting.
With help of business experts, analyse, understand and get the overview of how monthly financial data and financial products are processed, translate functional requirements into technical solutions
Your profile
Minimum of 4 years experience with MS SQL Server, T-SQL, and Stored Procedures applied in minimum of 3 projects
Experienced with SSIS or with other ETL tools
Experienced with C# (.Net), Web APIs, Python, Bash, PowerShell and/or other scripting languages
Hands-on and pro-active attitude
Quick learner
Capable to keep oversight of complex processes in a constantly changing environment, and capable to slice work into steps and can work accordingly
Strong analytical skills, attention to detail and are willing to learn and understand the world of financial risk. You are able to peel down technical problems, and doing so, you develop new insights.
You can explain complex matters in a simple way
You are fluent in English
You are a team player
Preferably you are experienced in, or at least you are interested in the following:
Database version control
SSRS and SSAS
Testing and automation of testing such as BDD/TDD
LDAP/Active Directory to assign roles / permissions to end users
Processing financial data, e.g. related to market risk or interest rate risk & liquidity risk management
An Agile/Scrum way of working.
What do we offer?
A salary tailored to your qualities and experience
Flexible working hours and the possibility to work at home
A reimbursement for travel expenses
24 vacation days with a 36-hour working week. If you work 40 hours a week, you will receive 27 vacation days
Pension scheme
13th month salary
Individual Savings Contribution (BIS), 3.5% of your gross annual salary
8% Holiday payment
Personal growth and challenging work with endless possibilities to realize your ambitions
An informal working environment with innovative colleagues who strive for the very best
Progressive way of working according to the Agile method, so that new ideas come to life
Professional environment with possibilities to develop yourself in many areas such as IT management, Development, BI, IT Security and Finance
Extra informatie
Status
Inactief
Plaats
Amsterdam
Dienstverbanden
Fulltime (ervaren)
Amsterdam | ICT / IT / Programmeur | Fulltime (ervaren)
Ontvang vergelijkbare vacatures in je mailbox
Vul in waar je vergelijkbare vacatures zoekt en vergeet je e-mailadres niet!
We heten wel YoungCapital, maar iedereen is even welkom. Ook als je al wat meer ervaring hebt. Meer weten? Check onze FAQ.