Data Engineer - Intern

Bayut & dubizzle have the unique distinction of being iconic, homegrown brands with a strong presence across the seven emirates in the UAE. Connecting millions of users across the country, we are committed to delivering the best online search experience. As part of Dubizzle Group, we are alongside some of the strongest classified brands in the market. With a collective strength of 5 brands, we have more than 123 million monthly users that trust in our dedication to providing them with the best platform for their needs. The Data Engineer intern 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. In this role, you will handle: - 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 - 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: - Bachelor’s degree in computer science, engineering, math, physics or any related quantitative field. - 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.) - Attention to details and analytical thinking - Entrepreneurial spirit and ability to think creatively; highly-driven and self-motivated; strong curiosity and strive for continuous learning Benefits: - Ability to contribute to a platform used by more than 5M users in UAE and other platforms in the region. - Strengthen your resume and build your network. - Opportunity to find a full time career with the region's leading organization. - Working in a multicultural environment with over 60 different nationalities - Access to the Learning & Development tools and courses provided by the company. Bayut & dubizzle is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. #UAEdubizzle

In this role, you will handle: - 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 - 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.