Eu - Data-warehouse & Reporting Developer - Brussels

il y a 2 semaines


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 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.

**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

**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.

**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 tools
- 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
- Ability to participate in technical meetings and good communication skills
- 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;

**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)

**CERTIFICATIONS & STANDARDS:
Not applicable



  • 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 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 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...

  • Data Warehouse Developer

    il y a 3 semaines


    Brussels, Belgique Sparagus Temps plein

    Position: Data Warehouse Developer Start date:15/01/2024 (flexible) End Date: 31/07/2024, with opportunity for extension. The assignment requires a commitment of 2.5 days/week. **Description**: The legacy CRM system is being replaced by a new IT platform. Alongside the new IT platform, there is also work being done on a new data warehouse. It will be fed...

  • Data Warehouse Developer

    il y a 3 semaines


    Brussels, Belgique Uni Systems Temps plein

    Preparation of technical specification for ETL, data modelling for the data warehouse. - Definition and recommendation of improvements on solution design for data warehouse. - Management of maintenance on the data warehouse and ETL data flows developed. - Development and maintenance of Data warehouse, ETL jobs and data flows. - Reporting of progress and...


  • 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...


  • Brussels, Belgique AMP Temps plein

    AMP?AMP (bpost group) est la plus grande société de distribution de presse en Belgique. A partir de 5 sites de distribution et de bureaux en Flandre, à Bruxelles et en Wallonie, nous desservons 5.000 points de vente de presse et distribuons 425.000 magazines et 260.000 journaux par jour. Aujourd'hui, nous renforçons encore notre position en...


  • Brussels, Belgique AlmavivA de Belgique Temps plein

    DESCRIPTION OF THE TASKS The following tasks will be performed: - Development and maintenance of Enterprise Data Warehouses (EDW) - Gathering business requirements - Designing ETL processes - Data modeling - Physical DB design - DB performance analysis - Design of Data Quality and Health Monitoring processes - Elaboration of test programs - Writing of...

  • Data Warehouse Developer

    il y a 2 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...

  • Operations Manager B2C

    il y a 2 semaines


    Brussels, Belgique AMP Temps plein

    AMP?AMP (bpost group) est la plus grande société de distribution de presse en Belgique. A partir de 5 sites de distribution et de bureaux en Flandre, à Bruxelles et en Wallonie, nous desservons 5.000 points de vente de presse et distribuons 425.000 magazines et 260.000 journaux par jour. Aujourd'hui, nous renforçons encore notre position en...


  • Brussels, Belgique Ankix Temps plein

    **Oportunidade**: A Ankix é uma empresa especialista em competências tecnológicas que presta serviços nas áreas de IT Outsourcing e Consultoria / Desenvolvimento à medida. O nosso posicionamento carateriza-se pela qualidade e inovação das soluções que propomos, assim como pela dedicação e orientação para os nossos consultores & clientes, bem...

  • Data Warehouse Developer

    il y a 3 semaines


    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...

  • Medior Data Analyst

    Il y a 2 mois


    Brussels, Belgique Pauwels Consulting Temps plein

    We are seeking a skilled BI Analyst/Developer to join the dynamic Data & Analytics team of one of our biggest clients located in Brussels. You will play a crucial role in developing and maintaining data-driven solutions that leverage API management and reporting Business Intelligence (BI) tools. You will have the opportunity to work in a collaborative...

  • Data Warehouse Tester

    Il y a 2 mois


    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.) -...

  • Data Functional Analyst

    Il y a 2 mois


    Brussels, Belgique Juvo Temps plein

    **Location: Brussel, 50% remote** The Data Functional Analyst & Architect plays a key role in the requirements gathering and the data modelling of data analytics solutions developed for company Business Units. You are part of the Data Office, a central organization providing data services across the different business lines. **RESPONSIBILITIES** -...

  • Business Analyst

    Il y a 2 mois


    Brussels, Belgique Source Group International Temps plein

    Posted: - Today- Location: - Brussels, Belgium- Job Ref: - BH-39622- Expiry date: - 8/24/2023**Business Analyst - Data & Reporting** You will be joining a large Financial Company in Brussels. As Business Analyst you'll be a vital link between business needs and technical solutions. The role centres around translating challenges into clear requirements,...

  • Qliksense/SQL Developer

    il y a 3 semaines


    Brussels, Belgique Oliver James Associates Temps plein

    **Oliver James is looking for a QlikSense/SQL for different roles, with strong capabilities.** **We introduce talented people to great organizations so that both may grow and benefit from each other's experiences, helping to fulfil their potential. As such, you can come to expect a consistently high level of service and delivery, placing up to C-suite...

  • Data Analysis

    il y a 1 semaine


    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...

  • Chief Data Architect

    Il y a 2 mois


    Brussels, Belgique Juvo Temps plein

    **Location: Brussel, 50% remote** As Chief Data Architect, you will play a central role in the design and development of the data platform. You will actively participate in the implementation of a strategy to move towards a more data-driven organization. The Chief Data Architect is part of the Data Office department and reports directly to the Chief Data...


  • Brussels, Belgique Dark Light Temps plein

    Dark Light is a staffing agency specializing in the recruitment and outsourcing of data and business intelligence profiles. We are currently seeking an Enterprise Data Warehouse Engineer for one of our clients, a big player in the FMCG located in Brussels. Tasks For the setup of a new enterprise data warehouse, we are looking for an Enterprise Data Warehouse...