Senior Microsoft BI Developer SSIS ETL MS SQL T-SQL

WHAT ARE WE LOOKING FOR?

Within the COO/Group Services the Asset & Liability Management (ALM) team is looking for a Designer and Developer to re-design the current Data Staging Area and to tailor ETL flows of finance data. The Designer/Developer needs to be capable to be hands-on, oversee complex data flow structures, and has to be experienced in data processing.

JOB DESCRIPTION:

Main services delivered by you are:

- Translate functional requirements from business analysts into technical solutions, eg:
- Improve and simplify data loads and ETL processes, despite of differences and variety in country data
- 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
- Implement an additional process to load source data from an additional source system (Oracle OFSAA)
- Together with one colleague developer/DBA-er, improve maintainability and performance of the Data Staging Area
- Carry out a senior engineer role, eg:
- With help of business experts, analyse, understand and get the overview of how monthly financial data and financial products are processed
- If requested, advice Operation engineers in their activities, eg at identifying root causes for incidents related to data errors
- Act as a sparring partner for business users to help them setting up and configuring calculations in the off-the-shelf application, to prevent performance problems
- 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 from the off-the-the-shelf application.

YOUR PROFILE

- 4 - 7 years of relevant experience with MS SQL Server and ETL
- Experience with Transact-SQL scripts
- Experience with SQL Server Integration Services (SSIS)
- A hands-on, and pro-active professional who can keep oversight of complex processes
- Experienced in, have understanding of, or at least you are interested in the following:
- C# (.Net)
- large data volumes
- An Agile/Scrum way of working
- Scripts to automate regression testing
- Finance, market risk management or treasury.
- Fluent in English
- Team player

WHAT WE OFFER

- Work with the latest technologies & tools
- Work in the most innovative area of the organisation
- Work in a very international and diverse environment
- Long-term project
- Relocation support (if requested)
- A competitive rate