Data Engineer - FMCG Customer Strategy Section, FMCG Customer Strategy Department (C&M)
Core
Design and build databases/data marts, create BI dashboards, and analyze customer purchasing and website visitor data to drive UI/UX improvements and business metrics for Rakuten 24.
Role type
Data Engineer
Builds
Databases, data marts, BI dashboards, and analytical environments for e-commerce operations
Domain
E-commerce, Retail, Consumer Goods
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL (joins, subqueries, conditional logic), BI tool development, data extraction, data validation, data pattern coverage, report creation
Preferred skills
RDBMS design (MySQL, PostgreSQL, Oracle), NoSQL (MongoDB, Cassandra), Google Cloud services (Cloud Run, Looker, BigQuery, Vertex AI), Python scripting, data warehouse construction, data cleansing, data monitoring
Technologies
SQL, MySQL, PostgreSQL, Oracle, MongoDB, Cassandra, Google Cloud Run, Looker, BigQuery, Vertex AI, Python
Responsibilities
Design and optimize databases/data marts; Create and maintain BI dashboards; Extract and aggregate purchasing/access data via SQL; Define requirements and validate data patterns; Create documentation for analysis manuals and designs
Seniority
Mid-career (70% of team), New graduate (30%)
