Job Description
Business Overview
Rakuten Ichiba is an internet shopping mall with the No.1 market share in Japan, and since its founding in 1997, has upheld the management philosophy of empowering people and society through the internet (Empowerment), with the goal of becoming the world's No.1 internet service company.

Department Overview
Ichiba Creative & Web Design Department belongs to the Commerce & Marketing Company (an in-house company focusing on e-commerce businesses, primarily Rakuten Ichiba), which is at the heart of Rakuten Group. We are responsible for the creative aspects of Rakuten Ichiba, providing optimal UI/UX to our users.

Rakuten Ichiba

Within this department, our Strategy Promotion Group leverages user behavior and demographic analysis to report on the overall performance of Rakuten Ichiba to executive management. We also identify challenges and propose improvements to drive the department's strategic initiatives.

Position
Why We Hire
To drive the department's strategic initiatives, we are establishing a new team to handle business intelligence, focusing on:

• Developing a robust data infrastructure to comprehensively understand user behavior across Rakuten Ichiba.
• Designing appropriate KPIs for each departmental strategy and collaborating closely with relevant teams to ensure alignment and execution.

This newly formed Business Intelligence team will play a crucial role in visualizing the overall performance of Rakuten Ichiba, linked to customer purchasing behavior models. We also aim to strengthen our ability to react instantly to market trend changes.

We are looking for a hands-on SQL and BI professional who can immediately contribute to data analysis while also being eager to design and lead the development of our KPI frameworks and analytical infrastructure. We welcome candidates not only from operating companies but also those with backgrounds in consulting firms or SIers.

This role offers a unique opportunity to gain diverse experience. You won't just be aggregating data; you'll be interpreting the broader trends of society and Rakuten Ichiba, forming hypotheses about users' latent needs, and supporting executive decision-making and the actions of various internal teams.

Attractiveness of the Role

• Attractiveness of the Business/Organizational Phase

Analyzing sales and traffic on a very large scale.

• Attractiveness of Discretion and Organizational Culture

Frequent opportunities to present outputs to management and business divisions, leading to significant impact.

• Career Development (Acquirable Skills and Career Path)

Ability to handle both "immediate proficiency in SQL and BI" and "leading analytical infrastructure and KPI design."

Environment where you can practically develop advanced skills such as Python.

Opportunity to be involved in the full cycle from analysis to improvement promotion.

• Differentiation from Competitors (Attractiveness leveraging this business x Rakuten Group resources)

Capable of large-scale data analysis due to possessing a significantly larger member base than competitors.

Position Details
To visualize the overall performance of Rakuten Ichiba and support business growth, we are currently rebuilding our tracking environment based on customer purchasing behavior models and KPIs. In this pivotal role, you will be instrumental in leading data infrastructure, BI design, and analytics, contributing significantly to service improvements and the design of KPIs for key departmental strategies.

• Visualizing Rakuten Ichiba's overall performance metrics and conducting data analysis to maximize performance. This includes in-depth analysis of purchasing data, traffic data, NPS surveys, market research, and industry analysis.
• Decomposing, defining, and visualizing the "KPIs to track" for each of the department's key strategic initiatives.
• Developing and improving the foundational data infrastructure (logs/measurement environment) and designing Business Intelligence (BI) solutions.
• Creating regular "Service Performance Reports".
• Conducting urgent analysis and preparing rapid reports in cases of KPI deterioration.
• Proposing and supporting the implementation of improvements based on analytical findings.
• Providing analytical support and sharing knowledge (e.g., through study sessions and training) with internal and external team members.

Work Environment
Organizational Structure

• Overall Department: Approximately 300 employees (including temporary staff and contractors)
• CWD Strategy Promotion Section: Approximately 80 employees (including temporary staff and contractors)

Senior Manager: 1

Managers: 5 (including those with dual roles/concurrent posts)

Assistant Managers: 6

• Strategy Promotion Group: 8 employees (including part-timers)

Average Age: 35 years old

New Grad/Mid-Career Ratio
New Graduates: 50%

Mid-Career Hires: 50%

Background of Mid-Career Hires

• Sales at a research firm
• Research Specialist at a gaming company

Illustrative Career Paths for Successful Mid-Career Hires

• Promoted to a team leader within 4 years of joining our group.
• Assumed a concurrent role in a service planning and promotion department (in another division) within 3 years of joining.

Mandatory Qualifications

• 3+ years of practical experience in large-scale data analysis using SQL.
• Hands-on experience in website analysis using access analysis tools (etc. Adobe Analytics, Google Analytics).
• Experience in designing dashboards using BI tools (etc. Looker, Tableau, DOMO).
• Practical experience in KPI design and utilizing analytical frameworks (etc. AARRR, Funnel analysis).
• Strong logical thinking skills and the ability to structurally organize problems/issues.
• Experience in cross-departmental requirements gathering and coordination.
• Ability to balance working both independently and as part of a team.

Desired Qualifications

• Experience in data analysis and/or building simple models using Python or R.
• Experience in designing and improving web/app tracking environments.
• Experience in requirements definition and translating analytical requirements in collaboration with the business side.
• Practical experience in service improvement or project management/promotion (even on a small scale).
• Strong communication skills to actively engage with assigned teams and drive initiatives forward.

Candidate Profile

• Possesses a strong hands-on capability in SQL and BI, while also being able to lead the design of data infrastructures and analytical workflows.
• Can accurately interpret data and tell a compelling story through numbers.
• Finds fulfillment in translating data into actionable insights for decision-making and improvement.
• Can work with a sense of urgency and adapt flexibly to changing situations.
• Excels at cross-departmental communication and coordination.
• Is eager to acquire new knowledge and skills, contributing to their own and the team's growth.

Other Information
Additional information on Location
Rakuten Crimson House

1-14-1 Tamagawa, Setagaya-ku, Tokyo

Additional Information On English Qualification
TOEIC score of 800 or higher (or equivalent proof of English proficiency, such as a degree from a university in an English-speaking country).

Proof of this qualification is required by the time of offer notification.

For candidates who do not possess a valid score or certificate, we will arrange for a TOEIC IP test during the selection process.

Rakuten Group Official Careers Page

• Benefits:
• Application Process & General Information:
• Rakuten Culture:

business #commerce #dataanalyst #dataanalytics

Languages
English (Overall - 4 - Fluent), Japanese (Overall - 4 - Fluent)