Be responsible for assisting in the end to end maintenance of the Data Warehouse.
Assist in the development of the Data Warehouse
Collate all disparate data sources
Make raw data as easy as possible to report on.
Manage the collection of data from a variety of sources including: transactional, web, third party and CRM.
Build ad-hoc BI tools and dashboards for various parts of the business to use
Integrate with third party APIs to access external data
Have a solid understanding of the fundamental stages within the delivery life cycle of Business Intelligence solutions
The JUST EAT BI team use Python as the ETL tool. Therefore, it is essential for the successful candidate to have utilised Python or similar.
An understanding of data mining – using SQL to write queries.
Have experience in the Extract Transform and Load (ETL) process and be able to develop end to end ETL solutions.
Have experience in data cleansing and aggregation.
Experience of Data modelling and data architecture design (preferred)
Be able to successfully maintain a relational database and the ETL processes.
Have experience of programming
Have some experience in a BI or Data Warehousing type position
Be used to working in an agile environment with the ability to pick up and learn how to use new data tools very quickly
Strong communication skills are a must to effectively present reports to multiple stakeholders.
Nice to have:
Experience using Pig, Hive, Spark, Storm, Flink, Hadoop
Experience with ETL tools such as Talend, Pentaho, Alteryx or similar
Experience working within an Amazon Web Services (AWS) environment
API integration experience – ability to take a 3rd party data source and fully integrate into our DW