29 Oct
For our client EC we are looking for a Datawarehouse Reporting Specialist
1. DESCRIPTION OF THE TASKS
Following tasks will be performed by external service provider:
Development and maintenance of Enterprise Data Warehouses (EDW).
Design, test and implementation of data flows and data pipelines solutions.
Functional requirements and business case analysis and gathering business intelligence requirements.
Create business architecture models that reflect the organization’s strategies and goals.
Identify ways to reduce the number of data issues communicated by the business in the IS.
Evaluate systems for discrepancies or vulnerabilities,
Data modelling.
Design and development of reporting applications.
DB performance analysis
Design of Data Quality and Health Monitoring processes.
Design measurement methods and metrics to assess the effectiveness and efficiency of the design processes and their deliverables.
Elaboration of test programs.
Assistance in the testing, the technical documentation, the deployment, the evaluation and the reporting.
Assistance and support to Business Intelligence analysts and developers.
Writing of technical documentation.
Participation in meetings with other project teams.
2. KNOWLEDGE AND SKILLS
Following skills and knowledge are required for the performance of the above listed tasks:
Excellent knowledge of data warehouse design & architecture.
Excellent knowledge of relational database systems applied to data warehouse.
Knowledge of enterprise architecture tools such Enterprise Architect.
Experience defining and implementing strategies under a Team leader or equivalent.
Ability to combine many different skills and experiences to address and solve business, information, and technology related opportunities and problems.
Excellent knowledge of SQL.
Excellent knowledge of business intelligence reporting tools.
Good knowledge of ETL/data flows tools.
Object Oriented programming.
Strong analysis and design skills. Problem solving skills.
Very good knowledge in modelling and graphical representations and abstractions.
In depth knowledge of information systems and DataWarehouse.
Experience with complex application environments.
In depth knowledge of Business Intelligence matters.
Working experience with Oracle RDBMS.
Experience of Workflow applications.
Expertise with data migration and data flows in the cloud (AWS, Azure).
Expertise with Python.
Very good communication skills with technical and non-technical audiences.
Capacity in preparing and writing clear and structured technical and user documents.
3. Specific Expertise
Following specific expertise is mandatory for the performance of tasks:
• At least 2 years of cloud-based ETL and data integration service experience and cloud-based build, testing and release experience (min. competence level 3).
At least 5 years of specific expertise in Data modelling (min. competence level 5).
4. Certification and Standards
N/A
5. Service Delivery
The services shall be performed remotely in Near-Site location allowing to reach the Commission
premises in Brussels 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 (and exceptionally in other locations).