OF THE TASKS
Following tasks will be performed by external service provider:
Design and implement ETL processes
Design and develop reports and dashboards
Provide advice on DB design and performance
Design and implement data governance procedures (incl. access, data quality, …)
Create data architecture models: optimise data flows and integrate solutions
Create and maintain Enterprise Data Warehouses (EDW) and complex Business Intelligence Solutions (Data Lakes / Data Lakehouses)
Conduct research to improve solutions and provide advice about new approaches and technologies (Data Virtualization, Data Mining, Linked Data, Artificial Intelligence, Big Data)
Gather business requirements related to reports and dashboards
Write technical documentation
Participate in meetings with other teams
Perform data quality tests
KNOWLEDGE AND SKILLS
Following skills and knowledge are required for the performance of the above listed tasks:
Good knowledge of data architecture frameworks
Excellent knowledge of data warehouse design and architecture
Very good knowledge of near real time data warehousing and/or change data capture technologies
Excellent knowledge of relational and non-relational database systems
Very good knowledge of data architecture best practices
Excellent knowledge of business intelligence technologies, including ETL, online analytical data processing, analytics, reporting etc.
Knowledge of data modelling, graphical representation, abstraction and design
Service- and client-oriented mindset
Ability to solve problems, recognise opportunities, analyse options, draw conclusions and promote approaches
Very good analytical capabilities and high-quality drafting skills.
Strong communications skills, both verbal (e.g.: presentations, technical- and non-technical workshops etc.), and written (e.g.: technical documents, reports etc.)
Leadership and conciliation skills, facilitation of group sessions
Ability to organise and supervise the work of others.
Ability to apply high quality standards, work efficiently and fast
SPECIFIC EXPERTISE
Following specific expertise is mandatory for the performance of tasks:
At least 10 years of specific expertise in data warehouses
At least 10 years of specific expertise in relational and non-relational database systems, data modelling tools and SQL
At least 10 years of experience with ETL/SAP Business Objects/QlikSense (min. competence level 4)
At least 3 years of experience with PowerBI
At least 10 years of experience with data quality management
Following specific expertise is an asset (advantage) for the performance of tasks:
Experience with MS-FABRIC.
Experience with scripting in Python.
Experience with AI/ML-powered analytics, including automated insights, natural-language query and predictive capabilities.
Knowledge of new technologies, including cloud-based business intelligence solutions, Linked Data, Artificial Intelligence.