For out client EC we are looking for Business Intelligence Expert
1. DESCRIPTION OF THE TASKS
Following tasks will be performed by external service provider:
• Implement business rules in the HR Business Intelligence Data Warehouse
• Develop and maintain ETL processes to ensure accurate and timely data integration from multiple
sources
• Create and maintain data marts and dimensional model, and the logic to keep these updated
• Implement best practices to ensure the integrity of data with exception-handling routines
• Development of custom applications, application components and database objects in support of
information systems
• Conduct performance tuning and optimization of the data warehouse environment
• Develop and maintain data models to ensure efficient data storage and retrieval
• Actively contribute to all aspects of the data project lifecycle including request intake and
acknowledgment, project estimation, time-tracking, and prioritization of tasks
• Participation in data governance initiatives to uphold data quality standards
• Participation in technical and business meetings with IT and business stakeholders to identify data
needs, clarify requirements, and implement solutions
2. KNOWLEDGE AND SKILLS
Following skills and knowledge are required for the performance of the above listed tasks:
• Very good knowledge of Data Warehousing best practices
• Ability to model data efficiently and fast
• Ability to work on multiple concurrent projects, activities or tasks under time constraints with a proven
ability to meet challenging deadlines
• Ability to give business and technical presentations
• Ability to apply high quality standards
• Ability to cope with fast changing technologies used in data and analytics domain
• Very good communication skills with technical and non-technical audiences
• Analysis and problem solving skills
• Capability to write clear and structured technical documents
• Ability to participate in and drive technical meetings and good communication skills
3. Specific Expertise
Following specific expertise is mandatory for the performance of tasks:
• Excellent ability to analyse, model and interpret data
• Experience working within an Agile/Scrum environment
• Extensive Data Warehouse experience using SAP BODS (SAP Business Objects Data Services,
Repository Manager, ETL Mapping/Transformations/Job Scheduling, Process Optimization), and
Oracle DB. Working knowledge in other ETL / ELT tools is considered a plus
• Working knowledge of a version control system such as Git
• Excellent knowledge of Data Vault concepts
• Deep experience in data quality applied to Data Warehouse / Data Vault
• Experience of preparing FSD/TSD (Functional/Technical Specification Document) documents from
BRD (Business Requirement Document) / Customer Requirements.
• Extensive experience in designing and modelling using modelling tools like PowerDesigner
• Thoroughly proficient in SQL, PL/SQL development in Oracle. Expertise in other programming
languages such as Python or JavaScript is considered a big plus
• Working knowledge in cloud platforms such as Microsoft Azure or AWS
• Experience with Microsoft Azure Cloud platform and related components, SQL Server on Azure,
Azure Data Factory and Azure Synapse is considered a plus
• A valid certification in a recognized quality assurance standard is considered a plus (i.e. ISTQB),
certification in data and analytics testing is considered a plus (i.e. DAU-CDAT)
4. Certification and Standards
Following certificates & standards are required for the performance of tasks:
• Certification in Oracle database administration
• Certification in Data-Warehouse using Oracle or SAP
Following certificates & standards are considered a plus for the performance of tasks:
• Certification SAP S4HANA in Data warehouse context on premises or on cloud
• Good knowledge and ideally certification in the area of Artificial Intelligence in the data management
activities
• Certification in Microsoft Fabric Analytics Engineer
• Certification in Microsoft Azure Data Engineer
• Certification in Data Vault
5. Service Delivery
The services shall be performed remotely in Near-Site location allowing to reach the Commission
premises in Brussels, Belgium Rue de la Loi 107 (Building L107) within 2 hours.
Laptop will be provided by the Commission.
The external service provider may be requested to participate in the meetings with the Commission’s
services in Brussels, Belgium Rue de la Loi 107 (Building L107) (and exceptionally in other
locations).