BI Data modeler/engineer
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.
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.
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.
Pragmatic and result oriented
Hands on and problem solver
Demonstrated ability to work in a small team setting
Superior communication and interpersonal skills (tact,