Data Engineer

Location: Brussels, Belgium Salary: €400 - €450 per day
Sector: Consultancy Type: Contract
Reference #: CR/067627_1579169180

Data Engineer / Brussels / 12 months / Start ASAP

Description and what we have to offer:

The Advanced Analytics team is currently looking for a new Data Engineer whose core objectives will be

- Collect, clean, prepare and load the necessary data - structured or unstructured - onto Hadoop, our Big Data analytics platform, so that they can be used for reporting purposes, creating insights and answering business challenges

- Act as a liaison between the team and other stakeholders and contribute to support the Hadoop cluster and the compatibility of all the different software's that run on the platform (Spark, R, Python, …)

- Experiment new tools and technologies related to data extraction, exploration or processing

Job description:

* Identify the most appropriate data sources to use for a given purpose and understand their structures and contents, in collaboration with SMEs when required
* Extract structured and unstructured data from the source systems (relational databases, data warehouses, document repositories, file systems, …), prepare such data (cleanse, re-structure, aggregate, …) and load them onto Hadoop.
* Actively support reporting teams in the data exploration and data preparation phases. Where data quality issues are detected, liaise with the data supplier to do root cause analysis
* Contribute to the design, build and launch activities
* Ensure the maintenance and support of production applications
* Liaise with Technology Services teams to address infrastructure issues and to ensure that the components and software's used on the platform are all consistent


Required skills:

* Experience with understanding and creating data flows, with data architecture, with ETL/ELT development and with processing structured and unstructured data
* Proven experience with using data stored in RDBMSs and experience or good understanding of NoSQL databases
* Ability to write performant SQL statements
* Ability to analyse data, to identify issues like gaps and inconsistencies and to do root cause analysis
* Knowledge of Java
* Experience delivering scripts
* Experience in working with customers to identify and clarify requirements
* Ability to design solutions that are fit for purpose whilst keeping options open for future needs
* Strong verbal and written communication skills, good customer relationship skills
* Have a true agile mindset, capable and willing to take on tasks outside of her/his core competencies to help the team
* Strong technical skills and a strong interest in the financial industry.
* Will be considered as assets
* Knowledge of R, Python, Scala and Spark
* Understanding of the Hadoop ecosystem including Hadoop file formats like Parquet and ORC
* Experience with open source technologies used in Big Data analytics like Spark, Pig, Hive, HBase, Kafka, …
* Ability to write MapReduce & Spark jobs
* Knowledge of Cloudera
* Knowledge of IBM mainframe
* Knowledge of AGILE development methods such as SCRUM is clearly an asset.