R16143

SQL/BI Architect

Brussels
Category
Development
Description

Our client is actively searching a SQL/BI architect to join its data integration team.
The Data Integration team is managing the integration flows with external partners or with packages, as well as preparing data for reporting & analytics. Architecture, design & implementation are managed within the team.

Responsibilities

Provide architecture, design & support on new or existing SQL Server solutions:
o Application/operational relational databases based on SQL Server 2014
and higher including SSIS/SSAS Tabular
o BI solutions (analysis/reporting/dashboarding) based on SQL Server 2014 & 2017 including SSIS/SSA/Power BI / DAX.
o Dashboard, KPI & metrics.

- Support on user requirements gathering & analysis, functional analysis of specific requirements when related to BI or reporting.
- Support & build of Dashboard/Scorecard/KPI/Metrics.
- Provide Microsoft database & BI technology expertise (SQL server, MS Office,
etc.) across IT.
- Provide guidance on SQL Server development (best practices, architecture
guidelines, etc.)
- Support & coaching to SQL server developers

Technical skills

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)
>3
 Experience as BI developer on SQL Server based
technologies
>3
 Experience as technical architect on SQL Server solutions
projects (BI and/or operational DB applications)
 Experience in dashboard & scorecard (with SQL server)
 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,
T-SQL & stored procedure programming).
>3
 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.
>3
 General Knowledge on SQL server working >3
 Extensive knowledge & hands on Performance tuning &
index management
>3
 Experience in solving performance related problems
specifically on database applications.
>3
 Extensive knowledge and hands on experience in reporting
with SSRS
 Extensive Knowledge of BI Reporting: OLAP SSAS tabular
 Design, implementation & overall framework
 Good knowledge of Power BI
 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.
 Ability to interact with Business Owners and gather Business Requirements
 Ability to translate Business Requirements into functional & technical Requirements
 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

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

Contact name
David Van Hooydonck
Contact email

Apply for this job!

One file only.
256 MB limit.
Allowed types: txt rtf pdf doc docx.

* required

Apply formulier Sharpspring