Data Warehouse and Reporting Developer
il y a 2 semaines
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.
As stated in the Article 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 SKILLSFollowing 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 selfstarting capability and experience in working in team.
- Ability to participate in multilingual meetings.
- Ability to work in multicultural environment, on multiple large projects.
- Excellent Team Player.
- Ability to understand, speak and write English (C1/C2), French (B2) will be an advantage.
**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 Python/R, Qlik Sense, PowerBI or similar tools (min. competence level 4)
-
Data Warehouse and Reporting Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique HNM Solutions Temps pleinJob ID:HNMJD2538:Role: Data Warehouse and Reporting DeveloperLocation: Brussels, BelgiumDescription: 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, business terms, processes, as well...
-
Data Warehouse and Reporting Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Serco Europe Temps pleinJob 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...
-
Data Warehouse and Reporting Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Serco Europe Temps pleinJob 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...
-
Data-warehouse & Reporting Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique HNM Solutions Temps pleinJob ID:HNMJD3546:Role: Data-Warehouse & Reporting DeveloperLocation:Brussels, BelgiumLanguage:EnglishDescription 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, and schema designs (Oracle is client main...
-
Data Warehouse and Reporting Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique AlmavivA de Belgique Temps pleinOF THE TASKSThe 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 technical documentation Assistance...
-
Data Warehouse Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Uni Systems Temps pleinPreparation 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 activities....
-
Data Warehouse Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Sparagus Temps pleinPosition: Data Warehouse DeveloperStart 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 by the new...
-
Data Warehouse and Reporting Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Ankix Temps pleinOportunidade: 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 como...
-
NTTDATA- Data analyst
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique NTT DATA Temps pleinNTT DATA is currently looking for a IT Data Analyst for a client in Brussels.The Data Functional Analyst plays a key role in the development of the data analytics platform for the organisation. He/she is in regular contact with the Business to understand business needs and translate them into data and technical requirements.The Data Functional Analyst er is...
-
NTTDATA- Data analyst
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique NTT DATA Temps pleinNTT DATA is currently looking for a IT Data Analyst for a client in Brussels.The Data Functional Analyst plays a key role in the development of the data analytics platform for the organisation. He/she is in regular contact with the Business to understand business needs and translate them into data and technical requirements.The Data Functional Analyst er is...
-
Data Warehouse Tester
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Uni Systems Temps pleinElaboration 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.) Advice on...
-
Data Warehouse Engineer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Uni Systems Temps pleinAt Uni Systems, we are working towards turning digital visions into reality. We are continuously growing and we are looking for a Data Scientist to join our UniQue team.What will you be doing in this role?Understand and model policy and operational needs. Develop data products to meet the business needs. Compile the information and deliver detailed analyses...
-
Reporting Data Analyst
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique NVISO Temps pleinWho 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 that...
-
Business Intelligence Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Lineas Temps pleinMission:As Business Intelligence Developer, you support Lineas' management at different levels of the organization in achieving our strategy by creating and managing Reporting and Analytics solutions that turn data into knowledge. You will be responsible to translate business requirements into reports and underlying queries and database models. You will also...
-
Qliksense/SQL Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Oliver James Associates Temps pleinOliver 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 talent in...
-
Reporting and Accounting
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique EPRA Temps pleinAbout the jobEPRA Internship :Reporting and Accounting**- Assist reporting & accounting team in updating and refining Excel Models. Entering data into database and checking automated reports against raw data. Assist Project Manager in identifying corrupt or missing historic data/documents and "backfill" with correct data. Assist the wider EPRA team in using...
-
BI Developer Dwh
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Oliver James Associates Temps pleinOliver James is looking for aBI developerfor different roles, with strong capabilities. We introduce talented people to great organisations 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 Csuite talent in...
-
Data Analysis
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique PaymentGenes Temps pleinOur 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...
-
Eu - IT Expert (SAP Data Expert) - Brussels
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique The White Team Temps plein**CONTEXT/INTRODUCTIONThe European Commission's financial and accounting management is supported by a corporate information system known as ABAC. It consists mainly of ABAC Accounting (SAP ECC-based), ABAC Workflow (in-house developed using Oracle database, WebLogic and JAVA) and ABAC SAM (SAP ECC-based). Furthermore, it includes the ABAC Data warehouse...
-
Business Intelligence Developer
il y a 2 semaines
Bruxelles, Région de Bruxelles, Belgique Uni Systems Temps pleinAt Uni Systems, we are working towards turning digital visions into reality. We are continuously growing and we are looking for a Business Intelligence Developer to join our UniQue team in BrusselsWhat will you be bringing to the team? Creation and maintenance of Enterprise Data Warehouses (EDW) and complex Business Intelligence Solutions (Data Lakes / Data...
