Description de l'offre
In the data warehouse team, 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.
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)
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.
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
The key missions of a BI data modeller/engineer are
. Understanding the functional domain of a business line
. Master the applicative BI domain of a business line
. Organization and moderating workshops with the business client in order to define their business needs.
. Gathering the business requirements and define solutions with the client
. Being able to plan and follow up projects
. Designing the different data patrimonies and keep it coherent in time
. Assessing new tools, new technologies and methodologies
. Creating and updating the functional documentation
. Explaining the functional contents of the projects to the development team (link between users and the development team)
. The monitoring/control of the functional design (logical data, functionalities and controls) of the applications of his business domain.
. Validating the deviations needed in the design and controlling they are documented.
. Ensuring the respect of the functional and technical design standards.
. Definition of best practices and patterns to be applied in his application context and documenting and maintaining them.
. Helping to define the testing approach of the projects with the clients
. Testing of new developments or changes of existing functionalities.