Expert Database and Business Intelligence Developer – Fully Remote

The consultant will perform the following tasks/services:

• Write complex stored procedures and queries in SQL Server;
• Design, implement and deploy solutions based on Data Vault methodology;
• Design, implement and deploy data warehousing solutions based on Kimball and/or Inmon methodologies;
• Implement and deploy SSIS ETL flows;
• Configure SSAS (multidimensional and tabular) to build data cubes;
• Work with reporting tools such as Tableau or PowerBI.

The consultant is expected to align appropriately with the Contractor and Europol and engage in professional, results-orientated interactions (including by estimating upon request the work to be done and following SCRUM methodology procedures and discipline adapted to the nature of the service) with the aim of delivering the services as per Europol’s requirements and with the degree of independence appropriate to the Expert level covered by this RfS.

Following skills and knowledge are mandatory for the performance of the above listed tasks:

• Working knowledge of English (level to be specified: C1[1] or higher)
• A minimum number of years of relevant professional experience in Software Development corresponding to the area, category and level requested, i.e. 9 years or 10 years taking into account the above level of education
• A minimum of three (3) years of professional experience in Database Design and Development with Data Vault Modelling
• A minimum of twelve (12) years of experience writing Microsoft T-SQL code
• A minimum of three (3) years of experience with Flyway deployment
• A minimum of twelve (12) years of experience with SSAS (multidimensional + tabular) development and deployment
• Excellent knowledge on writing complex SQL queries and stored procedures
• Excellent knowledge of Microsoft SQL Server and its main components
• Excellent hands-on knowledge of Data Vault modelling and implementation
• Excellent knowledge of SSIS and SSAS (multidimensional + tabular) development and deployment
• Excellent knowledge of data warehousing and dimensional modelling

 

Following skills and knowledge are desirable for the performance of the above listed tasks:

• A minimum of six (6) years of experience with Microsoft SSIS
• A minimum of twelve (12) years of experience in database dimensional modelling (Kimball + Inmon)
• A minimum of six (6) years of experience in configuring reporting tools such as Tableau or PowerBI
• Good knowledge of SSIS and SSAS server configuration
• Good knowledge of development and configuration of PowerBI on prem
• Good knowledge of CI / CD systems (e.g. TFS)
• Good knowledge of Agile Team implementing Scrum principles