Data Warehouse and Reporting Developer

Il y a 7 mois


Brussels, Belgique The White Team Temps plein

**Data Warehouse and Reporting Developer (DWRD) - Brussels - EU Public Organisations**

**1. CONTEXT/INTRODUCTION CINEA**

A1 in partnership with other Commission services and stakeholders, provides high quality corporate solutions/information systems for accessing to accurate data, reporting and Business Intelligence services, including those needed for feedback to policy transforming CINEA into an efficient, data-driven organisation and, enabling the successful implementation of the Commission's Digital Transformation and EU policies. In close collaboration with other Commission services and its customers, CINEA, A1 builds and operates solutions in the areas of financial and technical implementation of the programmes under the responsibility of the Agency. S/he will work in unit A1, in the reporting team under the supervision of the Head of Sector Business Intelligence and Reporting. The main responsibilities for this position involve designing data models, building data warehouse workflows, implementing data quality checks, conducting data analysis and other datawarehouse maintenance/documentation tasks. The solution assignment may change over time, according to the portfolio/project/service needs.

**2. DESCRIPTION OF THE TASKS
Following tasks will be performed by external service provider:

- Designing and creating the data model for the data warehouse, including entity-relationship diagrams, data flow diagrams, and schema designs (Oracle is CINEA’s main database).
- Building, maintaining and integrating data from multiple sources into the data warehouse, ensuring consistency and accuracy (KNIME is CINEA’s main ETL tool).
- Implementing data quality checks and processes to ensure the accuracy and completeness of data in the data warehouse.
- Documenting and keeping datawarehouse documentation (data model, dictionaries and metadata) up to date.
- Developing and maintaining reports, dashboards, and other analytics solutions built on top of the data warehouse.(CINEA main BI tools are Qlik Sense, Python or R).
- Prepare advanced and complex SQL queries including query tuning; optimize query performance and other database objects.
- Development and maintenance of business intelligence solutions built in Qlik Sense, Python, R or 2 similar tools.
- Interaction with the business analysts, customer, users, project leaders and the developers.

**3. LEVEL OF EDUCATION
As stated in the Article 2.6.3.1. of DIGIT-TM II Service requirements, a minimum educational qualification for lot 2 is: Level of education corresponding to Level 6 of the European Qualification Framework which typically corresponds to a bachelor’s level or 3 years of higher education.

**4. KNOWLEDGE AND SKILLS
Following skills and knowledge are required for the performance of the above listed tasks:

- Excellent knowledge of Oracle, SQL and PL/SQL. Experience with cloud-based technologies (such Amazon Redshift or Azure) would be considered advantageous.
- Excellent knowledge of Datawarehouse ETL tools (KNIME or other tools likeTalend or Pentaho).
- Excellent knowledge of data modelling and schema design.
- Excellent knowledge of data analysis tools such as Python/R, Qlik Sense, PowerBI or similar tolos.
- Ability to properly document data dictionaries, metadata and data models.
- Ability to give business and technical presentations.
- Ability to cope with fast changing technologies used in data analytics, business intelligence and data warehousing activities.
- Analysis and problem solving skills.
- Capability to write clear and structured technical documents.
- Capability of integration in an international/multicultural environment, rapid self-starting capability and experience in working in team.
- Ability to participate in multilingual meetings.
- Ability to work in multi-cultural environment, on multiple large projects.
- Excellent Team Player.
- Ability to understand, speak and write English (C1/C2), French (B2) will be an advantage.

maintained in CINEA, A1 contain personal and confidential data.

**5. SPECIFIC EXPERTISE
Following specific expertise is mandatory for the performance of tasks:

- at least 5 years of excellent knowledge in Oracle, SQL, PL/SQL, cloud technologies and data warehouse development (min. competence level 4)
- at least 5 years of excellent expertise in ETL tools (such as KNIME, Pentaho or Talend) (min. competence level 4)
- at least 5 years of excellent expertise in Python/R, Qlik Sense, PowerBI or similar tools (min. competence level 4)



  • Brussels, Belgique HNM Solutions Temps plein

    **Job ID: HNMJD2538**: **Role: Data Warehouse and Reporting Developer** **Location: Brussels, Belgium** **Description**: - We are searching for 2 Data Warehouse and Reporting Developer to work on different projects. The DWH is specialized on Business Intelligence tools to work on the centralized data warehouse (DWH) that stands on shared models,...


  • Brussels, Belgique Serco Europe Temps plein

    Job Introduction Serco is a partner of choice to the European Institutions and other International Organisations. For the past 30 years, we have been providing European and International Organisations a wide range of services including ICT services in support, infrastructure, operations and development as well as managing different contact centres for the...


  • Brussels, Belgique HNM Solutions Temps plein

    **Job ID: HNMJD3546**: **Role: Data-Warehouse & Reporting Developer** **Location**: **Brussels, Belgium** **Language:English** **Description of the task**: - The Following tasks will be performed by an external service provider: - Designing and creating the data model for the data warehouse, including entity-relationship diagrams, data flow diagrams,...


  • Brussels, Belgique HNM Solutions Temps plein

    **Job ID: HNMJD2278**: **Role: Data warehouse and reporting developer** **Location: Brussels, Belgium** **Required experience / knowledge**: - Very good knowledge of the Financial Regulation and ABAC - Ability to deliver efficiently and fast - Ability to give business and technical presentations - Very good communication skills with technical and...


  • Brussels, Belgique Serco Europe Temps plein

    Job Introduction Serco is a partner of choice to the European Institutions and other International Organisations. For the past 30 years, we have been providing European and International Organisations a wide range of services including ICT services in support, infrastructure, operations and development as well as managing different contact centres for the...


  • Brussels, Belgique The White Team Temps plein

    **CONTEXT/INTRODUCTION CINEA, A1 in partnership with other Commission services and stakeholders, provides high quality corporate solutions/information systems for accessing to accurate data, reporting and Business Intelligence services, including those needed for feedback to policy transforming CINEA into an efficient, data-driven organisation and, enabling...


  • Brussels, Belgique ProfilerConsulting Temps plein

    **_Our client_** Our client is a leading player in the finance sector with an international presence on all continents, located in Brussels and specialized in asset management (bonds, equities, absolute return strategies, asset allocation and - more recently - real estate) and are known for their innovation and successful sustainable solutions (SRI). As a...


  • Brussels, Belgique HNM Solutions Temps plein

    Knowledge & Skills: The Following skills and knowledge are required for the performance of the above listed tasks: Excellent knowledge of Oracle, SQL and PL/SQL. Experience with cloud-based technologies (such as Amazon Redshift or Azure) would be considered advantageous. Excellent knowledge of Data warehouse ETL tools (KNIME or other tools likeTalend or...

  • Data Warehouse Developer

    il y a 7 jours


    Brussels, Belgique EUROPEAN DYNAMICS Temps plein

    **Your tasks** - Design of ETL processes and Data Quality and Health Monitoring processes; - Advice on Physical DB design and data modelling; - Elaboration of test programs and gather business requirements. **Requirements**: - University degree in IT combined with 13 years of IT professional experience; - At least 6 years of specific expertise in SQL; - At...

  • Data Warehouse Consultant

    il y a 5 jours


    Brussels, Belgique K&K social resources & development GmbH Temps plein

    **Data Warehouse Consultant** Standort: Brussels Anstellungsart(en): Full time **Role: Data Warehouse Consultant** **Start Date: ASAP** **Duration: Full-time permanent** **Location: Brussels, Belgium** **Experience required/ Responsibilities**: - **11+ years of experience in data disciplines with experience on any of the following areas**: - DWH strategy...

  • Data Warehouse Developer

    Il y a 7 mois


    Brussels, Belgique EUROPEAN DYNAMICS Temps plein

    **Your tasks** - Designing and creating the data model for the data warehouse, including entity-relationship diagrams, data flow diagrams, and schema designs (in an Oracle database); - Building, maintaining and integrating data from multiple sources into the data warehouse, ensuring consistency and accuracy (KNIME being the main ETL tool); - Implementing...

  • Data Warehouse Tester

    il y a 1 jour


    Brussels, Belgique Uni Systems Temps plein

    Elaboration and maintenance of IS quality control procedures. - Provision of quality plan. - Definition, elaboration, management, and reporting of quality tests. - Perform the testing of the data warehouse chain from data sourcing to data visualisation. - Perform data quality checks related to the data warehouse (completeness, accuracy, consistency, etc.) -...

  • Reporting Developer

    il y a 3 jours


    Brussels, Belgique Euroclear Temps plein

    Reporting Developer - (BRU205PX) Description **Division** The Group Digital Capabilities division ensures Euroclear’s competitiveness by delivering reliable and sustainable IT solutions for the financial securities markets. Our non-technical people maintain the maturity of the IT project delivery with appropriate controls in line with the group’s risk...

  • Database Architect

    Il y a 3 mois


    Brussels, Belgique EUROPEAN DYNAMICS Temps plein

    **Your tasks** - Assist during relevant parts of testing, analysis, technical documentation, deployment, evaluation and reporting; - Assist in the enforcement of project deadlines, schedules, and methodologies; - Assistance with deployment and configuration of the system; - Contribute and review the creation and maintenance of Enterprise Data Warehouses and...

  • Data Analysis

    Il y a 7 mois


    Brussels, Belgique PaymentGenes Temps plein

    Our client is a fintech that offers start-ups and established businesses a wide range of payment services, such as transaction processing, BIN sponsorship, e-money issuance and digital wallet provision, as well as full programme management and value-added services such as PSD2 and AML compliance expertise. The company is trusted to manage ground-breaking...

  • Data Warehouse Architect

    Il y a 3 mois


    Brussels, Belgique EUROPEAN DYNAMICS Temps plein

    **Your tasks** - Analyse the current state of the data analytics technologies, processes, and services to identify areas for improvement and create a plan for future development; - Design the transition strategy from current data analytics tools to the target platform; - Design Data Warehouse architecture; - Design, develop and maintain ETL processes to...

  • Data Engineer consultant

    il y a 2 semaines


    Brussels, Brussels, Belgique Finalyse Temps plein

    Data Engineer consultant - Risk and Regulatory ReportingOur aim is to support our clients incorporating changes and innovations in valuation, risk and compliance. We share the ambition to contribute to a sustainable and resilient financial system and facing these extraordinary challenges is what drives us every day. Our people are empowered to design and...


  • Brussels, Belgique Uni Systems Temps plein

    At Uni Systems, we are working towards turning digital visions into reality. We are continuously growing and we are looking for a professional XML/XBRL Data Reporting Specialist to join our UniQue Brussels team. The consultant will support the data collection processes of the European Institution related to the implementation of the reporting...

  • Reporting Data Analyst

    Il y a 7 mois


    Brussels, Belgique NVISO Temps plein

    Who are we? **It all starts with the mission**: NVISO is here to protect European society from potentially devastating cyber attacks! This means we offer cyber security services to private and governmental organizations to help them better prepare for, prevent, detect and respond to cyber security incidents. All of this is built on four fundamental values...

  • Data Reporting

    Il y a 4 mois


    Brussels, Belgique DWI Consulting Ltd Temps plein

    **Context**: The SPM-Visualization team has established a robust expertise in Tableau, becoming a vital asset for our internal clients. With the advancements in sales performance and the shift towards digitalization, there is an increasing need to develop sophisticated dashboards in Tableau. **Role Overview**: We are looking for a Tableau specialist to join...