Associate Data Engineer

The Associate Data Engineer will be involved in engaging projects that cover the entire data lifecycle - from raw data integrations with primary and secondary systems, to advanced data modeling, to cutting-edge data visualization and the creation of innovative data products. You will have the chance to learn how to construct and interact with both batch and real-time data processing pipelines. You will be working in a modern cloud-based data warehousing environment alongside a diverse, passionate, and intriguing team of colleagues. You will collaborate with other departments - such as product & tech, core business divisions, trust & safety, finance, among others - to ensure their success. Key Responsibilities: - Integrating raw data with primary and third-party systems - Modeling of data warehouse for operational and application data layers - Development in Amazon Redshift cluster - SQL development as part of an 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 visualizations in Periscope Data with a focus on UX, simplicity, and usability - Collaborating with other departments on data products – i.e. product & technology, marketing & growth, finance, core business, advertising, and others - Being part and contributing to a strong team culture and aspire to be at the forefront of big data Requirements: - Internship experience preferably with customer-oriented data at a large scale in an online/e-commerce context - Basic knowledge of one or more programming languages, especially Python - Understanding 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 and conceptual thinking; Business Acumen; Entrepreneurial spirit and the ability to think creatively - Highly motivated and self-driven; strong curiosity and a passion for continuous learning - Written and verbal proficiency in English #LI-TM1