The Associate Data Engineer will be participating in exciting projects covering the end-to-end data lifecycle – from raw data integrations with primary and third-party systems, through advanced data modelling, to state-of-the-art data visualisation and development of innovative data products.

You will have the opportunity to learn how to build and work with both batch and real-time data processing pipelines. You will work in a modern cloud-based data warehousing environment alongside a team of diverse, intense and interesting co-workers. You will liaise with other departments – such as product & tech, the core business verticals, trust & safety, finance and others – to enable them to be successful.

Key Responsibilities:

  • Raw data integrations with primary and third-party systems
  • Data warehouse modelling for operational and application data layers
  • Development in Amazon Redshift cluster
  • SQL development as part of agile team workflow
  • ETL design and implementation in Matillion ETL
  • Design and implementation of data products enabling data-driven features or business solutions
  • Data quality, system stability and security
  • Coding standards in SQL, Python, ETL design
  • Building data dashboards and advanced visualisations in Periscope Data with a focus on UX, simplicity and usability
  • Working with other departments on data products – i.e. product & technology, marketing & growth, finance, core business, advertising and others
  • Being part and contributing towards a strong team culture and ambition to be on the cutting edge of big data


Requirements:

  • Internship experience preferably with customer-centric data at big data-scale in an online / e-commerce context
  • Basic knowledge of one or more programming languages, especially Python
  • Knowledge of relational and dimensional data models
  • Knowledge of terminal operations and Linux workflows
  • Ability to communicate insights and findings to a non-technical audience
  • Good SQL skills across a variety of relational data warehousing technologies especially in cloud data warehousing (e.g. Amazon Redshift, Google BigQuery, Snowflake, Vertica, etc.)
  • Analytical thinking; Conceptual thinking; Business Acumen; Entrepreneurial spirit and ability to think creatively
  • Highly-driven and self-motivated; strong curiosity and drive for continuous learning
  • Written and verbal proficiency in English



#LI-TM1