Analyst, Consumer Insights

Rakuten Americas; Osasco; Presencial; BRL 361 011 - 567 303; Tempo integral

Resumo da oferta

Rakuten International seeks an Analyst, Consumer Insights (Advanced Analytics) to execute and scale research-based deliverables using licensed and internal data. You will build repeatable outputs like QBR decks, microsites, category scorecards, and benchmarking assets while partnering with senior leaders to ensure accuracy and actionability.

The role emphasizes automation and AI-enabled workflows, with hands-on work in SQL, Python, Looker, and BigQuery to produce robust insights and client-ready

Qualificações

• Advanced analytical skills with ability to translate ambiguous requirements into precise questions.
• Experience turning data into actionable insights and recommendations.
• Proficiency with Excel (advanced functions, VBA) and PowerPoint for clear storytelling.
• Familiarity with SQL; comfortable joining and transforming data.
• Exposure to Looker/BigQuery; Python is a plus.
• Experience or interest in AI tools to improve workflows and QA.

Responsabilidades

• Execute analyses using consumer and internal data to answer business questions about e-commerce performance and shopper behavior.
• Build and maintain standardized deliverables (QBR decks, microsites, category scorecards).
• Develop dashboards and recurring reporting views in Looker, BigQuery, and related tools; QA outputs.
• Perform data pulls, transformations, and QA checks; document issues and remediation steps.
• Prototype automation workflows and agentic processes using SQL/Python; maintain scripts and templates.
• Support QBR, account reviews, and microsite production; translate findings into story components.
• Maintain benchmarking definitions and refresh scorecards; identify structural breaks and propose fixes.
• Respond to ad hoc internal questions with defensible reads and supporting exhibits.
• Maintain basic BI dashboards and assist in QA of dashboard population.

Conhecimentos

SQL basics

Excel (advanced, VBA)

PowerPoint

Data analysis

Communication

Team collaboration

Formação académica

Bachelor's degree

Ferramentas

Looker

BigQuery

Python basics

Descrição da oferta de emprego

Company Overview

Rakuten International is a division of Rakuten Group, Inc., headquartered in San Mateo, California, focusing on e-commerce, digital marketing, advertising, communications, and entertainment.

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 such as QBR decks, microsites, category scorecards, benchmarking, and ad hoc client questions, while strengthening underlying workflows. The analyst is not 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, and contributes 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 understanding of research panel fundamentals to interpret outputs responsibly and flag limitations.
• Recurring Deliverables and Content Development – Build and maintain standardized deliverables including QBR decks or microsites, category scorecards and benchmarking assets, ensuring they answer underlying strategic questions and meet internal templates.
• Reporting and Dashboard Development – Utilize Looker, Strategy, and BigQuery to build, QA, and maintain dashboards and recurring reporting views; perform updates and optimizations, ensuring consistency between tool outputs and manual analysis.
• Data Quality, QA and Documentation – Perform data pulls, transformations, and structured QA checks; investigate and reconcile discrepancies; document root causes and recommended remediation; contribute to internal documentation on metric definitions and reporting processes.
• Workflow Automation & AI/Agentic Enablement – Identify repetitive workflows suitable for automation, build or support lightweight automation using SQL or Python, explore agentic workflows leveraging tools such as Claude Code, and maintain controls and review processes for AI-assisted outputs.
• Specific Tasks – Support QBR, account review and microsite production; pull and QA recurring cuts and translate them into standardized story components, draft insight write‑ups, and produce visual assets aligned to internal templates.
• Category Scorecards / Benchmarking – Maintain consistent benchmarking definitions, refresh scorecards, flag structural breaks, and propose mitigation.
• Ad Hoc Requests – Respond to time-sensitive internal questions with defensible reads and clean supporting exhibits that can be used in client-facing materials after internal review.
• Strategy Dashboard Maintenance & QA – Build and maintain basic BI dashboards in Strategy, investigate divergences, monitor recurring refreshes, and validate dashboard population.
• Automation / Agentic Workflows – Prototype automation workflows for repeatable steps, create maintainable internal assets such as scripts, templates, and prompt playbooks.

Qualifications

• Advanced Analytical Skills – Expert in analyzing and synthesizing complex information to understand issues, identify root causes, and propose solutions.
• Demonstrated ability to translate ambiguous business requirements into precise analytical questions and comprehensive solution designs.
• Proficiency in Microsoft Excel (advanced functions, VBA) and PowerPoint (clear slide structure, chart/table presentation, template discipline, speed). Experience with Strategy (MicroStrategy) or ability to learn it quickly is important.
• Proficient in basic SQL; comfortable pulling and aggregating data with joins and transformations.
• Familiarity with Google BigQuery and basic Python is a plus.
• Experience or interest in applying modern AI tools such as Claude Code to improve workflow efficiency and building or supporting agentic workflows with proper QA.
• Strong organizational and planning skills – manage multiple concurrent deliverables with deadlines while maintaining high attention to detail and version control.
• Adaptability – proactively respond to changing circumstances and solve problems in ambiguous environments.
• Effective communication – written and verbal skills, with the ability to adjust messaging for diverse audiences and deliver compelling presentations.
• Team player – build strong working relationships within the company and contribute to knowledge sharing, mentorship, and best practices.
• Critical thinking – articulate limitations, confidence levels, and understand how different data sources may reflect truth, with familiarity with concepts such as regression and causality at a high level.
• Understanding of digital advertising, especially affiliate advertising, to contextualize findings and recommendations for clients.
• Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Minimum Requirements

• 1–3 years of experience in analytics, reporting, insights, consulting, or related field.
• Consumer research panel literacy – understanding of panel operations, weighting/projection, sampling, and bias considerations.
• Bachelor’s degree required.