Data Analyst, eCommerce/B2C Marketing

Summary

Join JobLeads as a B2C Marketing Data Analyst and leverage your expertise in Power BI, SQL, and Python to transform data into actionable insights. You will be responsible for ad performance tracking, sales forecasting, attribution modeling, and dashboard creation. This role requires at least 5 years of online industry experience with a focus on B2C and subscription-based models. You will collaborate closely with marketing and sales teams to optimize strategies and enhance customer acquisition. The position offers a competitive salary, flexible working hours, a collaborative team environment, and various team events.

Requirements

• High expertise in Power BI for creating detailed reports and dashboards
• Strong skills in SQL for data querying and manipulation
• At least 5 years of experience in the online industry, working with tracking data, demonstrating exceptional SQL skills, and possessing a deep understanding of online marketing function
• Experience in businesses similar to ours, with a focus on B2C, subscription-based models, and online marketing, including search engines and LinkedIn
• Proficient in using digital marketing analytics platforms such as Google Analytics, LinkedIn, Facebook Insights, or similar tools to gather and interpret data relevant to online advertising and sales
• Exceptional ability to perform quantitative analysis with a deep understanding of digital marketing metrics and KPIs. Capable of transforming complex data into digestible and actionable insights
• Solid experience in managing and analyzing online ad campaigns, including SEO/SEM, pay-per-click (PPC) campaigns, and social media advertising. Familiarity with A/B testing and multivariate experiments to enhance ad effectiveness
• Excellent communication skills in English, with the ability to present complex information clearly and persuasively to a variety of stakeholders

Responsibilities

• Use advanced analytical tools to monitor the performance of search and social media advertising campaigns. Analyze click-through rates, conversion rates, and ROAS to provide actionable insights that can improve ad strategies and budget allocation
• Develop predictive models and forecasting tools using SQL and Python to estimate future revenues based on historical data, customer lifetime value and market conditions. Prepare comprehensive reports in Power BI and Excel to communicate these insights to stakeholders
• Develop and refine advanced attribution models to accurately distribute ad spend credit among various touchpoints in a user's journey. Utilize both first-touch and last-touch attribution perspectives to understand the impact of initial and concluding interactions on user conversion. By analyzing detailed click history data, create models that help optimize the allocation of advertising budgets and enhance the overall effectiveness of our marketing campaigns
• Design and maintain dynamic dashboards that provide real-time insights into advertising spend, sales performance, and customer engagement metrics. Ensure these dashboards effectively support decision-making processes in marketing and sales strategies
• Work closely with marketing and sales teams to refine targeting strategies and optimize ad placements. Leverage data-driven insights to inform creative strategies and promotional tactics that enhance customer acquisition

Preferred Qualifications

• Knowledge of German is a plus, aiding in local market communications
• Proficiency in Python is highly beneficial for automating data processes and enhancing analytical capabilities

Benefits

• Salary package tailored to match your experience and responsibilities
• Flexible working hours and absolutely no bureaucracy
• Challenging tasks, fruitful interactions with your colleagues, as well as plenty of opportunities to bring in your own ideas
• Virtual team lunches, regular team events and, most importantly, our annual JobLeads Sailing Week in the Mediterranean