Data Engineer - FMCG Customer Strategy Section, FMCG Customer Strategy Department (C&M)

Job Description: Department Overview The FMCG Customer Strategy Department is a business division that operates multiple shops on Rakuten Ichiba, including "Rakuten 24," a direct-to-consumer (D2C) service for daily consumer goods. Rakuten 24 is a first-party model store operated by Rakuten itself within Rakuten Ichiba, offering a unique position where you can gain business experience while working within the organization. Our department contributes to business success through UI/UX improvements, web page creation, data analysis, and marketing. Beyond typical processes like advertising sales, driving traffic to store pages through events, and delivering creative materials, we handle everything from product procurement to sales, page creation, shipping, logistics, and UX verification until products reach customers, enabling skill development through the entire business process. From a data engineer perspective, you can gain the following experiences: Comprehensive involvement from planning to implementation: Since upstream processes like planning are conducted within our business division, you can track whether the projects you participate in contribute to business success, understand the overall project picture, and make more effective proposals. High impact: Rakuten24, which drives sales for "Rakuten Ichiba" - Japan's leading e-commerce marketplace - handles a wide range of products including daily necessities, pharmaceuticals, and food items, operating as a business with significant influence as social infrastructure. The ability to tangibly experience the concrete business results of projects you've worked on is a major attraction. Integration of technology and business: By leveraging technical skills while approaching projects with a business perspective, you can develop not only as an engineer but also enhance your skills as a business professional. Rakuten 24: Position: Why We Hire The FMCG Customer Strategy Department within our Consumer Goods & General Electronics Direct Business is seeking individuals to join us in maximizing sales revenue. As our business continues to expand, we are conducting customer data analysis and implementing rapid A/B testing based on these insights to further improve UI/UX. In this position, you will work as a data engineer to extract and analyze customer purchasing data and website visitor data for UI/UX improvements, including visualization through BI tools. Additionally, Rakuten Group is actively engaged in business process improvements and productivity enhancements using generative AI, and this position offers opportunities to gain experience with various AI technologies. Furthermore, we provide opportunities to actively promote various initiatives from an engineering perspective, including DX improvements and operational enhancements, not only within our business division but also across the entire Rakuten Group and to external audiences. Would you like to join us in realizing our VISION of creating new value for Rakuten's e-commerce site from a user-centered perspective, leveraging data and technology? We invite you to bring your expertise and passion to this role. What Makes This Position Attractive 1. Experience Overwhelming Scale and Business Growth Firsthand The FMCG Customer Strategy Department operates "Rakuten 24," which drives sales for "Rakuten Ichiba" - Japan's leading e-commerce mall. As a first-party model where Rakuten operates its own store within Rakuten Ichiba, you can experience business company decision-making and execution while working within the organization. UI/UX improvements directly translate to business results, allowing you to feel the magnitude of this impact. This role's appeal lies in offering a comprehensive, bird's-eye view of the entire business and acquiring diverse experience. 2. Ownership from Planning to Implementation and Impact Verification You can actively participate from the planning stage and pursue contributions to the overall business. Since everything from planning to implementation and verification is conducted consistently within the business division, you can track how much your work contributes to the business. With a deeply rooted culture of data-driven decision-making and A/B testing, proposals are validated and results are visualized. In this open environment, you can turn ideas into reality. 3. Become a High-Market-Value Engineer Who Integrates Technology and Business In addition to data-related technologies, you can acquire high-market-value skills through involvement in upstream processes such as planning and design. Planning & Business Perspective: Thinking skills that directly lead to business results. Data-driven Improvements: Development skills based on data analysis. Latest Technology Utilization: Hands-on experience with cutting-edge technologies like AI. Career Path: You can chart your career path from both technical and business perspectives. 4. Fusion of Rakuten Group Resources and Business Company Dynamism The greatest differentiating factor is experiencing both "Rakuten Group's robust technical foundation and extensive resources" and "the dynamism of moving an entire business that's unique to Rakuten 24 as a business company." You'll have access to a massive ecosystem, abundant data, and an environment where you can utilize the latest technologies like generative AI. From product procurement to logistics, you can experience everything from upstream to downstream business operations in-house and feel how your development contributes to the entire business. Position Details As a data engineer, you will be responsible for analyzing purchasing and access data for e-commerce sites operated by our business division, including Rakuten 24, as well as building analytical environments and researching and implementing new technologies. Main Responsibilities - Design and build new databases/data marts. Improve and optimize existing databases - Create, operate, and maintain BI dashboards - Create SQL queries for purchasing and access data extraction, aggregation, and analysis - Requirements definition, data extraction, data validation, comprehensive data pattern coverage, and report creation based on purchasing and access data analysis requests - Create and maintain documentation for analysis/aggregation manuals, designs, etc Specific Project Examples - To improve business metrics such as user churn rates and conversion rates: identifying issues through data analysis, proposing solutions, and validating effectiveness through A/B testing - Conducting PoC (Proof of Concept) for implementing new BI tools Work Environment Organizational Structure - Overall business division: Approximately 60 members - Data engineer team: Approximately 3 members - Age range: 20s to 30s - New graduate vs. mid-career ratio: New graduates (30%), Mid-career hires (70%) Mid-Career Hire Backgrounds - E-commerce industry server-side/front-end engineers (with SQL experience) Career Path Examples of Successful Mid-Career Hires - Promoted to leader within 3 years of joining and excelling in the role - Joined as a front-end engineer and successfully took on dual responsibilities as a data engineer Mandatory Qualifications: - Experience in SQL creation and design (2+ years) *Able to understand table structures and perform data extraction using multiple table joins, subqueries, and conditional settings. - Experience in creating dashboards with BI tools (1+ years) Desired Qualifications: - Experience in database design and construction using RDBMS (MySQL, PostgreSQL, Oracle, etc.), Data warehouse, and NoSQL databases (MongoDB, Cassandra, etc.) - Development and usage experience with Google Cloud services (Cloud Run/Looker/BigQuery/Storage/Vertex AI, etc.) - Experience implementing new BI tools - Data warehouse construction experience - Data engineering task experience (data extraction based on business requirements, cleansing missing values and outliers, data design, integrity checks, dataset maintenance, data provision, visualization, monitoring) - Experience in data processing and script creation using programming languages such as Python 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 proof of equivalent English proficiency, or proof of a graduate degree or higher from an English-speaking university) Proof of qualification is required by the time of notification of offer. If you do not have a score or a certificate, we will guide you to the TOEIC IP test sponsored by our company during the selection process. Rakuten Group, Inc. Homepage Link - Benefits: - Recruitment Information: * Employment type is detailed - Rakuten Culture: #engineer #DataEngineer #dataanalyst #dataanalytics #AI #commerce #Rakuten24 Languages: English (Overall - 3 - Advanced), Japanese (Overall - 4 - Fluent)