Position: Business Intelligence Engineer
Company: Materialise
Experience required: 3y
Category: SQL
English level: intermediate
Published: 2021-10-01T00:00:00+03:00

**Qualifications & Experience**
 
**Responsibilities**
Development and analysis of database objects (tables / views / procedures / indexes ...)

Design & development SSRS reports, SSAS Cubes, Tabular models, SSIS packages, Azure Data Factory pipelines

Design & development interactive Power BI Dashboards

Developing and maintaining data warehouse for operational systems (MS Dynamics, in house systems)

Participate in projects for development new data cubes, analytical dashboards, building data marts for sales, finance, medical, manufacturing

Performing detailed analysis of changes in source systems & impact on reporting platform

Participate in technical researches

Create and maintain technical design documentation
 

**Requirements**
Strong knowledge & experience with SQL programming (5+)

5+ years of experience with any RDBMS (preferable MS SQL Server 2014/2016/2019 / ...)

Understanding principals of SQL code optimization

Good knowledge of the processes inside SQL Server

Has good understanding of SQL database design and implementation methodologies.

Strong experience with at least one ETL tool (MS SSIS, Data Integrator, Informatica, ...)

Good knowledge of Microsoft Power BI (on premise / on-cloud)

Understanding Data Warehousing design approaches

 
**Will be a plus**
Knowledge / experience with

MS Analysis Services Multidimensional / Tabular

Experience with the MS Reporting Services or any other reporting platforms

Microsoft Azure (SQL database, Data Factory / Data Lake)

Best practices for design, development, modeling, and implementation of data warehouses and relational databases