Description
).
2. Mission period
Start date: ASAP
Duration: 1 year
(Depending on project evolution, extension is possible)
3. Language requirement
Languages Speaking Reading Writing Mandatory Preferable
English 2 3 2 X
Dutch 3/1 3/1 3/1 *X
French 3/1 3/1 3/1 *X
1 = Basic – 2 = Good – 3 = Fluent
*Dutch and French, one Fluent other one maybe passive
4. Localisation
Brussels centre.
5. Level of education required
Master degree in Informatics or equivalent through experience.
6. Required Knowledge and Experience
Personal Skills Years
Mandatory – Must be a self-starter, work well independently, and in a
collaborative team environment
– Solution driven / Pragmatic
– Strong problem solving skills
– Pro-active and flexible
– Strong verbal / written communications and presentation
skills
– Coaching & training skills
Preferable –
Business experience required Years
Mandatory – Experience as ETL developer on SQL server platform. >3
– Experience as a SQL server database developer (tables,
views, triggers, unions, joins, complex queries, stored
procedures)
– Experience as BI developer on SQL Server based
technologies
– Experience as technical architect on SQL Server solutions
projects (BI and/or operational DB applications)
– Experience in DWH concepts and run >5
Preferable – Experience within Insurance or financial or risk domain
– Experience on projects with different technology stacks,
integration aspects (with packages or external solutions) &
infrastructure aspects
– Experience on .NET applications development
Technical experience required Years
Mandatory – Experience in SAS DWH
– Extensive knowledge and hands on in SQL Server 2014 and
2017 (tables, views, triggers, unions, joins, complex queries,
T-SQL & stored procedure programming).
– Extensive knowledge and hands on in ETL (SSIS) >3
– Fluency with appropriate tools including SQL Management
Studio, Profiler, Performance Monitor and other SQL Server
management tools or related tooling as the MS Office suite.
– General Knowledge on SQL server working >3
– Extensive knowledge & hands on Performance tuning &
index management
– Experience in solving performance related problems
specifically on database applications.
– Extensive knowledge and hands on experience in reporting
with SSRS
– Extensive Knowledge of BI Reporting: OLAP SSAS tabular
design, implementation & overall framework
– Knowledge .NET C# & traditional data access techniques
such as ADO.NET
– Knowledge of popular technologies & framework built
around SQL Server
– Being aware of best practices, trends & evolutions of the IT
industry and most particularly Microsoft SQL Server
technologies stacks.
Preferable – Knowledge of .NET technologies such as Entity framework,
WCF, Web services
Functional experience required Years
Mandatory – Database modelling via modelling tools such as Erwin or
Visio
– Architecture, functional & technical analysis on database,
ETL & BI solutions
– Understanding of Best Practices for SQL server Database,
datawarehousing, ETL & BI solutions across the Enterprise
Preferable – Ability to interact with Business Owners and gather
Business Requirements
– Ability to translate Business Requirements into functional &
technical Requirements.
7. Objective of the job
– Define a SQL-server AG framework for BI: development standards, metadata
management, logging…
– Integrate all non functional requirements to gather from the DWH team and infra
team.
– Study of the migration from SAS storage to SQL-Server: define approach,
technical migration… follow-up and take part to it.
– Provide architecture, design & support on new or existing SQL Server solutions:
o BI solutions (analysis/reporting/dashboarding) based on SQL Server 2014
& 2017 including SSIS/SSAS/Power BI / DAX.
o Dashboard, KPI & metrics.
– Provide Microsoft database & BI technology expertise (SQL server, etc.) across
IT.
– Provide guidance on SQL Server development (best practices, architecture
guidelines, etc.)
– Support & coaching to SQL server developers.
Languages: English, Dutch, French
Location: Brussels centre.
Start date: ASAP
Duration: 1 year
(Depending on project evolution, extension is possible)
Personal skills:
– Must be a self-starter, work well independently, and in a
collaborative team environment
– Solution driven / Pragmatic
– Strong problem solving skills
– Pro-active and flexible
– Strong verbal / written communications and presentation
skills
– Coaching & training skills
Business experience required
– Experience as ETL developer on SQL server platform. >3
– Experience as a SQL server database developer (tables,
views, triggers, unions, joins, complex queries, stored
procedures)
– Experience as BI developer on SQL Server based
technologies
– Experience as technical architect on SQL Server solutions
projects (BI and/or operational DB applications)
– Experience in DWH concepts and run >5
Optional:
– Experience within Insurance or financial or risk domain
– Experience on projects with different technology stacks,
integration aspects (with packages or external solutions) &
infrastructure aspects
– Experience on .NET applications development
Technical experience required
– Experience in SAS DWH
– Extensive knowledge and hands on in SQL Server 2014 and
2017 (tables, views, triggers, unions, joins, complex queries,
T-SQL & stored procedure programming).
– Extensive knowledge and hands on in ETL (SSIS) >3
– Fluency with appropriate tools including SQL Management
Studio, Profiler, Performance Monitor and other SQL Server
management tools or related tooling as the MS Office suite.
– General Knowledge on SQL server working >3
– Extensive knowledge & hands on Performance tuning &
index management
– Experience in solving performance related problems
specifically on database applications.
– Extensive knowledge and hands on experience in reporting
with SSRS
– Extensive Knowledge of BI Reporting: OLAP SSAS tabular
design, implementation & overall framework
– Knowledge .NET C# & traditional data access techniques
such as ADO.NET
– Knowledge of popular technologies & framework built
around SQL Server
– Being aware of best practices, trends & evolutions of the IT
industry and most particularly Microsoft SQL Server
technologies stacks.
Optional:
– Knowledge of .NET technologies such as Entity framework,
WCF, Web services
Functional experience required
– Database modelling via modelling tools such as Erwin or
Visio
– Architecture, functional & technical analysis on database,
ETL & BI solutions
– Understanding of Best Practices for SQL server Database,
datawarehousing, ETL & BI solutions across the Enterprise
Optional:
– Ability to interact with Business Owners and gather
Business Requirements
– Ability to translate Business Requirements into functional &
technical Requirements.
Apply
If you are interested in this role please send your CV in English to info@rmm-cg.com
All applications will be treated as strictly confidential
[wordpress_file_upload uploadpath="uploads/CV/%pagetitle%" uploadpatterns="*.pdf,*.doc,*.docx" maxsize="5" createpath="true" duplicatespolicy="maintain both" uniquepattern="datetimestamp" placements="userdata/filename/selectbutton/subfolders/consent/uploadbutton/message" uploadtitle="JOB APPLICATION" selectbutton="Upload CV" uploadbutton="Apply" successmessage="You successfully applied for this position!" errormessage="There was an error while applying for this position!" notify="true" notifyrecipients="todorkacarski@gmail.com" notifysubject="CV Upload Notification" notifymessage="Dear Recipient,%n%%n% This is an automatic delivery message to notify you that a new CV has been uploaded.%n%%n%Applicant details:%n%Last name: %userdata1%%n%First name: %userdata2%%n%Email: %userdata3%%n%Phone: %userdata4%%n%Reference: %userdata5%%n%%n%Best Regards" attachfile="true" successmessagecolors="#00ba25,#EEFFEE,#006666" widths="selectbutton:150px, uploadbutton:150px" userdata="true" userdatalabel="Last name*|t:text|s:placeholder|r:1|a:0|p:right|d:/First name*|t:text|s:placeholder|r:1|a:0|p:right|d:/Email*|t:email|s:placeholder|r:1|a:0|v:1|p:right|d:|g:/Phone|t:text|s:placeholder|r:0|a:0|p:right|d:/reference|t:text|s:left|r:0|a:1|p:none|d:"]