Data Engineer - FMCG Customer Strategy Section, FMCG Customer Strategy Department (C&M)
On-siteTokyo, Tokyo, Japan
Tokyo, Tokyo, JapanOn-siteFull TimeSenior LevelEnterprise
Full TimeSenior LevelEnterprise
Job Summary
Design and build new databases and data marts while optimizing existing structures for e-commerce sites like Rakuten 24. Create SQL queries to extract, aggregate, and analyze purchasing and visitor data, then maintain BI dashboards to visualize insights for UI/UX improvements and churn rate tracking. Define requirements, validate data patterns, and implement new technologies including generative AI tools to enhance business metrics. Create documentation for analysis manuals and conduct proof-of-concept testing for BI tool adoption.
Required 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)
- 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
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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.