Database Analyst/Data Modeller, Bank, Brussels

OBJECTIVE: Looking for a Database Analyst/Data Modeller to support developers and designers at this international bank.

TASKS:

You will be part of a Component Management team which has a cross-functional role acting as a service desk for the designers, developers, etc. The team does configuration management activities for projects and maintenance tasks. It also has a gatekeeper role, reviewing all naming convention and databases standards and ensuring they are compliant with configuration management good practices. The Component Management team is spread over 3 locations (Brussels, Paris , and London) with on average 10 team members.

- LOGICAL DATA MODELLER TASKS:

Business requirement Analysis:
Interact with business to get the functional requirements;
Interact with end users and find out the reporting needs.
Conduct interviews, brain storming discussions with project team to get additional requirements.
Gather accurate data by data analysis and functional analysis.

- DEVELOPMENT OF DATA MODEL:

Create standard abbreviation document for logical, physical and dimensional data models;
Create logical, physical and dimensional data model (data warehouse Datamodelling);
Document logical, physical and dimensional data model (data warehouse Datamodelling);

- REPORTING/REVIEW:

Generate reports from data model.
Review the data model with functional and the bank's technical conventions (naming, physical database recommendations etc.)

- SUPPORT AND MAINTENANCE:

Assist developers, Designer, BI team and end users to understand the data model.
Maintain change log for each data model.

- Physical Data Modeller Role:

Create SQL code from data model and create development database.
Co-ordinate with Production Integration teams to create testing and production database.
Check to see data models and databases are in sync.
Adding database objects (like indices partitions in DB2 database) for performance.
Generating reports

ESSENTIAL SKILLS:
- Experience with physical and logical Datamodelling.

NICE TO HAVE SKILLS:
- Oracle/DB2/SQL Server;
- some experience with a modelisation tools (ex. MEGA, ER-Studio, ERWIN);
- CA Unicenter Service Desk, Windows Office;
- Mainframe and distributed systems environment knowledge

Language: English.

You must be an EU citizen to apply for this role.