BI Data modeler/engineer




IT Infrastructure/support

Project description:

Data analysis is becoming more and more important in today’s world of business decision making. Who hasn’t heard about Advanced Analytics and Machine learning?
In the data warehouse team at the client, we are working in the fascinating world of data every day. In order to be fully prepared for tomorrow’s challenges, we have put in place a new platform, new tools and new detailed and aggregated data for our business clients to support
them in their analysis. We work closely with the business to analyse and model data.
In the DWH team, we strive to combine insurance business concepts and develop well reflected
systems to respond a maximum to our business clients’ reporting needs.


The key missions of a BI data modeller/engineer are
a. Understanding the functional domain of a business line
b. Master the applicative BI domain of a business line
c. Organization and moderating workshops with the business client in order to define their business needs.
d. Gathering the business requirements and define solutions with the client
e. Being able to plan and follow up projects
f. Designing the different data patrimonies and keep it coherent in time
g. Assessing new tools, new technologies and methodologies
h. Creating and updating the functional documentation
i. Explaining the functional contents of the projects to the development team (link between users and the development team)
j. The monitoring/control of the functional design (logical data, functionalities and controls) of the applications of his business domain.
k. Validating the deviations needed in the design and controlling they are documented.
l. Ensuring the respect of the client functional and technical design standards.
m. Definition of best practices and patterns to be applied in his application context and documenting and maintaining them.
n. Helping to define the testing approach of the projects with the clients
o. Testing of new developments or changes of existing functionalities.

Technical skills:


University Graduate or Professional bachelor Ideally University graduate “Master” in information Science, Management or Industrial Engineer.

 Experience in data modelling and functional analysis
 Experience in star scheme modelling through projects
 Good knowledge of insurance processes and of BI
principles to support these.
 Strong interest for business process analysis
 Project management experience (planning, communication)
 Experience in functional enterprise modelling and
 Thorough experience in data modelling techniques trough projects
 Understanding development life cycles
 Good organizational skills with demonstrated ability to deliver data oriented projects on time and on budget.
 Experience in data modelling via Erwin
 Mastering scheduling principles and techniques
Detailed understanding of SAS (Base, DI, EG) development and tabular models on SSAS through experience
 Knowledge of SQL server and SSIS
 Good computer skills, proficient with Microsoft office
applications including Microsoft BI Tools such as PowerBI.
 Experience with cloud and on premise architectures and setup
 Mastering scheduling principles and techniques (CTRL/M)
 Thorough understanding of corporate practices, processes
and standards and their impact on project deliveries.

Soft skills:

 Structured and pro-active
 Flexible
 Pragmatic and result oriented
 Hands on and problem solver
 Stress resistant
 Quality driven
 Demonstrated ability to work in a small team setting
 Superior communication and interpersonal skills (tact,
diplomacy, influence).
 Client friendly

Contact person:

Contact name: Yves De Vocht