Voor 1 van onze klanten zijn we op zoek naar een Data modeler.
Context of the mission
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 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.
Mission period
Expected Start date: ASAP Duration: 12 months (Depending on project evolution, extension is possible)
Language requirement
Dutch and/or French with knowledge of the second languague.
Localisation
Brussels centre.
Level of education required
University Graduate or Professional bachelor Ideally University graduate “Master” in information Science, Management or Industrial Engineer.
Personal Skills (soft skills - intangible qualities or traits that enhance our interactions) Mandatory
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
Preferable
Client friendly
Superior communication and interpersonal skills (tact, diplomacy, influence).
Business experience required (work experience) Mandatory Years
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.
Mid-level (2 y - 5 y)
Technical experience required (hard skills related to physical or digital tools) Mandatory Years
Detailed understanding of SAS (Base, DI, EG) development and tabular models on SSAS through experience
Knowledge of SQL server
Good computer skills, proficient with Microsoft BI Tools (PowerBI)
Long experience in analysis, knowledge of efficient testing techniques, efficient and performant coding capabilities
Mid-level (2 y - 5 y)
Preferable
Mastering scheduling principles and techniques (CTRL/M)
Thorough understanding of corporate practices, processes and standards and their impact on project deliveries.
Functional experience required (job experience in particular industry and in particular function) Mandatory Years
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.
Mid-level (2 y - 5 y)
Preferable
Experience in data modelling via Erwin
Mastering scheduling principles and techniques
Objectives of the job
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
Designing the different data patrimonies and keep it coherent in time
Creating and updating the functional documentation
Explaining the functional contents of the projects to the development team (link between users and the development team)
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.
Testing of new developments or changes of existing functionalities.