/

SQL Server BI Architect

Bruxelles, Belgium

Share

SQL Server BI Architect


RealDev is a dynamic Technology and Management Consulting Group located in Belgium. Our teams have taken on multiple consulting projects, assisting in the development of leading competitors in various sectors.We are committed to finding efficient solutions for sustainable growth and profit.Our positive, motivated, and challenging team environment is seeking talented expert.

Job description

The company is actively searching a SQL Server BI architect to join its IT BI/data analytics team. Among others, this team is managing the Data Warehouse (DWH) of the company, as well as preparing data for reporting & analytics. Architecture, design & implementation are managed within the team.

Current DWH technology is SAS for lower levels of the storage, SQL-Server and Microsoft technologies for data marts/SSAS and PowerBI for presentation.

The Company would like to create a full Microsoft stack solution 

  • 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:

                - BI solutions (analysis/reporting/dashboarding) based on SQL Server 2014 & 2017 including SSIS/SSAS/Power BI / DAX.

                - 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.

Qualifications
  • Master degree in Informatics or equivalent through experience.

Personal Skills

  • Must be a self-starter

  • Work well independently, and in a collaborative team environment

  • Solution driven / Pragmatic and strong problem solving skills

  • Pro-active and flexible

  • Strong verbal / written communications and presentation skills

  • Coaching & training skills 

Technical and Business Skills

  • 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

  • Extensive knowledge and hands on in SQL Server 2014 and 2017 (tables, views, triggers, unions, joins, complex queries,

  • management tools or related tooling as the MS Office suite.

  •  Extensive knowledge & hands on Performance tuning & index management

  • Extensive knowledge and hands on experience in reporting with SSRS

  • Being aware of best practices, trends & evolutions of the IT industry and most particularly Microsoft SQL Server technologies stacks.

  • Knowledge of .NET technologies such as Entity framework, WCF, Web services

  • Database modelling via modelling tools such as Erwin or Visio

  • English : Fluent

  • Dutch : Fluent

  • French : Fluent

  • Contract Type : Project

  • Duration : end 2019 (extensible)

  • Location of Project : Brussels

Conditions

At RealDev, we are seeking to expand our team of experts by investing in individuals who are capable of taking on challenging projects. We’re offering exciting positions in a dynamic and professional company. Our positions provide great opportunities to develop your career while working in driven environments and industries with sector leaders.