SQL Server BI Architect
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.
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.
Master degree in Informatics or equivalent through experience.
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
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.