Analytics Engineer

Job Description

• Collaborate with Product, Technical and Business teams to design and implement the necessary data structures to enable reporting of defined business KPIs.
• Employ a data-driven approach, ensuring that multiple data sources match in terms of quality and reporting is of a high standard
• Design, develop, and optimize complex ETL processes for a large-scale Data Warehouse using Vertica as the primary database platform.
• Ensure to data modeling and normalization principles to maintain data integrity and scalability of DWH environment.
• Build and automate DWH-ETL pipelines across the Data Warehouse on ETL-scheduling tool.
• Implement optimized query structures and table formats in order to enhance data querying efficiency and improve overall system performance.
• Build and enhance existing DWH models in order to enhance performance of queries triggered by BI Visualisation platform.
• Collaborate with DWH/BI analysts to understand reporting requirements across the business domains.
• Develop DWH pipelines regarding reporting requirements and system efficiency constraints.
• Collaborate with Data Architecture and infrastructure teams to optimize DWH pipelines deployment and monitoring on Vertica Analytics Platform.
• Support data analytics teams by providing optimized datasets and ensuring efficient ETL workflows.

Qualifications

• BSc degree in Computer Science, Mathematical Engineering, Statistics, Industrial Engineering, Information Systems, Mathematics, or a related field
• Minimum 4 years of experience as a Data Warehouse Developer
• Strong experience with SQL development, including query optimization, indexing strategies, and performance improvements
• Strong proficiency in writing complex SQL queries, indexing strategies, stored procedures, and functions in Vertica
• Hands-on experience in building ETL/ELT pipelines and working with modern ETL tools
• Familiarity with the terms like; Conversion Funnel, A/B or Split Testing, Customer Insights
• Domain knowledge in similar businesses or e-commerce is a huge plus.
• Strong communication skills, with the ability to collaborate effectively with cross-functional teams and business stakeholders.

Preferred Skills

• Expertise in managing and optimizing Vertica
• Familiarity with version control systems like Git.