Analyst, Consumer Insights

Rakuten International; São Paulo; Presencial; BRL 60 000 - 90 000; Tempo integral

Resumo da oferta

Rakuten International is seeking an Analyst, Consumer Insights (Advanced Analytics) to help build repeatable analytical outputs and scalable workflows. The role emphasizes producing high-quality analyses from panel and network data, creating standardized QBR decks and category benchmarking, and supporting automation initiatives to accelerate reporting and presentation development.

The position involves collaborating with the VP of Consumer Insights and internal teams to ensure accuracy and

Responsabilidades

• Insights Production - Execute analyses using consumer panel data, internal affiliate network data, and other approved datasets to answer business questions related to e-commerce performance, category dynamics, shopper behavior and competitive benchmarking.
• Recurring Deliverables and Content Development: Build and maintain standardized deliverables including QBR decks and/or microsites (structured narrative, consistent charts/tables, clear takeaways), category scorecards and benchmarking assets (definitions, consistent time windows, comparable cuts), and high-priority ad hoc analyses for internal teams supporting client questions.
• Reporting and Dashboard development: Utilize Looker, Strategy and BigQuery to build, QA and maintain dashboards and/or recurring reporting views. Perform basic-to-moderate updates and optimizations of existing reporting assets (e.g., trend views/cards), ensuring accuracy and usability.
• Data Quality, QA and Documentation: Perform data pulls, transformations, and structured QA checks to ensure accuracy and repeatability of deliverables. Investigate and reconcile discrepancies across toolsets, source extracts, and Excel-based outputs; document root causes and recommended remediation.
• Workflow Automation & AI/Agentic Enablement: Identify repetitive workflows suitable for automation (data refreshes, table creation, charting, slide production, QA checks, documentation). Build or support lightweight automation using SQL and/or Python, and explore agentic workflows leveraging tools such as Claude Code to accelerate production and reduce manual effort.

Descrição da oferta de emprego

Job Description

Rakuten International is a division of Rakuten Group, Inc., a Japanese global technology leader in services that empower individuals, communities, businesses, and society. Headquartered in San Mateo, California, with more than 4,000 employees worldwide, Rakuten International's business portfolio includes market leaders in e-commerce, digital marketing, advertising, communications, and entertainment. The company creates products and services that provide exceptional value by aligning members and the businesses that want to engage them in a shared community.

Rakuten Advertising provides advertising technology and consumer insights to the world's leading brands and retailers. Working with agencies and brands globally, Rakuten Advertising brings together technology, client strategy, and consumer insights to deliver advertising experiences that drive increased brand awareness and marketing performance. With access to Rakuten's diverse media properties and audiences, combined with an award-winning performance network and proprietary consumer research, it creates the right conditions to reach new customers and sustain long-lasting loyalty.

Job Summary

The Analyst, Consumer Insights (Advanced Analytics) is an early-career role responsible for the execution, improvement and operational scaling of research-based deliverables, powered by licensed and internal data. This position focuses on building high-quality, repeatable analytical outputs (e.g., QBR decks/microsites, category scorecards/benchmarking, and ad hoc client questions) and strengthening the underlying workflows that produce them. This role is not expected to be client-facing. The Analyst partners closely with the VP of Consumer Insights and internal stakeholders to ensure insights are accurate, decision-oriented, and production-ready. The Analyst will also contribute to automation and modernization of the team's workflow, including exploration and development of AI-enabled and agentic solutions that accelerate reporting, analysis, and presentation production.

Responsibilities

• Insights Production - Execute analyses using consumer panel data, internal affiliate network data, and other approved datasets to answer business questions related to e-commerce performance, category dynamics, shopper behavior and competitive benchmarking. Apply an understanding of research panel fundamentals (e.g., sampling, weighting/projections, bias considerations, panel stability) to interpret outputs responsibly and flag limitations in data or methodology. Support synthesis across disparate signals (panel vs. network vs. public/licensed sources), identifying where measures are directionally consistent, where they diverge and why.
• Recurring Deliverables and Content Development: Build and maintain standardized deliverables including QBR decks and/or microsites (structured narrative, consistent charts/tables, clear takeaways), category scorecards and benchmarking assets (definitions, consistent time windows, comparable cuts), and high-priority ad hoc analyses for internal teams supporting client questions. Maintain a strong focus on "what the client would want to know", ensuring deliverables answer the underlying strategic question, not just the stated request.
• Reporting and Dashboard development: Utilize Looker, Strategy and BigQuery to build, QA and maintain dashboards and/or recurring reporting views. Perform basic-to-moderate updates and optimizations of existing reporting assets (e.g., trend views/cards), ensuring accuracy and usability. Support consistency between tool outputs and manual analysis, escalating discrepancies and proposing fixes.
• Data Quality, QA and Documentation: Perform data pulls, transformations, and structured QA checks to ensure accuracy and repeatability of deliverables. Investigate and reconcile discrepancies across toolsets, source extracts, and Excel-based outputs; document root causes and recommended remediation. Contribute to internal documentation regarding metric definitions, data source differences (panel vs. network), methodology notes, and reporting processes/templates.
• Workflow Automation & AI/Agentic Enablement: Identify repetitive workflows suitable for automation (data refreshes, table creation, charting, slide production, QA checks, documentation). Build or support lightweight automation using SQL and/or Python, and explore agentic workflows leveraging tools such as Claude Code to accelerate production and reduce manual effort. Maintain appropriate controls and review processes for any AI-assisted outputs to ensure accuracy, confidentiality, and reproducibility

Specific tasks

• QBR, Account Review and Microsite production support: Pull and QA recurring cuts (category, retailer, brand, channel, time period) and translate them into standardized story components
• Draft and format charts/tables in Excel; translate into PowerPoint or microsite-ready visuals aligned to internal templates.
• Produce first-pass insight write