• Manage and maintain large datasets related to affiliate operations, ensuring data accuracy and integrity.
• Develop, optimize, and execute SQL queries to extract, manipulate, and analyze data for reporting and strategic planning.
• Use JavaScript, HTML, and CSS to design, implement, and enhance data visualization tools and dashboards.
• Provide in-depth analysis of affiliate program performance, identifying trends and recommending actionable strategies.
• Collaborate with internal teams (key account, campaign marketing, commercial, product) to define metrics, set KPIs, and support data-driven decisions.
• Automate routine reporting tasks and build dynamic dashboards to streamline affiliate program monitoring.
• Research and resolve data discrepancies, ensuring reliable and consistent reporting across the organization.
• Monitor the performance of affiliate campaigns and provide recommendations to improve effectiveness.
• Stay updated with the latest tools and technologies for data analysis and reporting to implement best practices.
• 4-5 years of experience in a data analysis role, preferably within an e-commerce or affiliate marketing environment.
• Advanced proficiency in SQL for data extraction, manipulation, and analysis.
• Hands-on experience with JavaScript, HTML, and CSS for data visualization and dashboard creation.
• Strong understanding of data management, reporting, and analytics tools.
• Proven ability to analyze complex datasets and provide clear, actionable insights.
• Detail-oriented, with excellent problem-solving and critical-thinking skills.
• Effective communication skills to present findings and recommendations to non-technical stakeholders.
• Experience with data visualization platforms like Tableau, Power BI, or Google Data Studio.
• Ability to work independently and as part of a team in a fast-paced environment.