Job Description:

Department Overview

Rakuten24 is one of the few direct-to-consumer e-commerce platforms operated by Rakuten, specializing in a wide range of products including daily necessities, food, beverages, cosmetics, baby products, pet supplies, and healthcare items. Through this platform, we aim to drive the growth of Rakuten Ichiba and the broader Rakuten Group.

This unique platform offers opportunities to engage in comprehensive decision-making processes, including direct marketing to end-users, product assortment, and supply chain management.

The Marketing & Planning Division is dedicated to addressing challenges through data-driven strategies for both Rakuten24 and Rakuten Ichiba. Our primary mission is to increase the user base of Rakuten24, including attracting new users and re-engaging former users, as well as implementing strategies to enhance ARPU (Average Revenue Per User).

With approximately 6.5 million users annually, Rakuten24 presents significant growth opportunities, particularly in an industry marked by rapid and dynamic changes.

Position:

Position Details

Job Summary:
You will support the execution of marketing initiatives from a data perspective through activities such as "data analysis and proposal," "building and maintaining data analysis environments/data marts," and "ad hoc data creation."

Key Responsibilities
1. Data Analysis and Proposal
・Within the Marketing & Planning Division, you will be involved in formulating marketing strategies (e.g., channel strategies, CRM, AI strategies) aimed at achieving business revenue, profit goals, and various KPIs. This will involve collaboration with cross-functional teams including MD, production, engineering, and logistics.
・A critical aspect of this role is accurately capturing daily changes and challenges based on the diverse data accumulated within Rakuten24. You will conduct data analysis from various perspectives to identify ongoing changes and provide advice and support for problem-solving.
・You will participate in kickoff meetings to support decision-making from a data perspective and provide insights and proposals based on analysis results, thereby having the opportunity to influence business decisions.

2. Building Data Analysis Environments / Maintaining and Operating Data Marts
・You will utilize BI tools and Excel to acquire and analyze regularly monitored data, ensuring the establishment and maintenance of a robust data analysis environment. Additionally, you will be responsible for the creation and management of data marts required for in-depth data analysis.

3. Ad Hoc Data Creation
You will handle various one-time data extraction requests for initiatives and campaigns by using SQL to retrieve and aggregate data from databases, and then provide the results in Excel or other formats. Furthermore, you will generate lists of target individuals relevant to each initiative.

Work Environment:

The team consists of 7 men and 1 woman (contract employee). Roughly half of the team members are mid-career hires, while the other half are recent graduates. This is a highly motivated team eager to undertake new initiatives without being constrained by past practices. Your proactive actions will significantly influence many of our decisions.

Mandatory Qualifications:

・Practical experience using SQL (preferably 4 years or more)
・Skills in processing and aggregating large-scale data (hundreds of billions of records or more)
・Ability to design data marts for efficient data processing
・Experience in planning initiatives/strategies based on data

Desired Qualifications:

・Experience in designing and implementing analytics infrastructure
・Experience in data visualization using BI tools (e.g., Looker Studio, Tableau)
・Practical experience using Python
・Experience in building BI tools
・Basic knowledge of statistics
・Demonstrated analytical and problem-solving skills in a business environment
・Project management experience
・Knowledge or experience in manufacturing business and e-commerce (EC)

Others:

Work Location:
Rakuten Crimson House, Futako-Tamagawa

#business #CRM #marketing #analist #EC #eCommerce #commerce #RakutenIchiba #Rakuten24

Languages:

English (Overall - 3 - Advanced), Japanese (Overall - 4 - Fluent)