Analyst, Advanced Analytics

Job Description: Rakuten International oversees 7 businesses with over 4,000 employees globally. The brand is recognized for its leadership and innovation in e-commerce, digital content, advertising, entertainment and communications, bringing the joy of discovery and access to more than 1 billion members across the world. Our teams deliver on the company’s mission to delight merchants and customers through innovation, optimism, and teamwork. Rakuten Advertising provides advertising technology and consumer insights to the world’s leading brands and retailers. Working with agencies and brands around the world, Rakuten Advertising unites 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, Rakuten Advertising creates the right conditions to reach new customers and sustain long-lasting loyalty. Summary Description: The Support Specialist position is an entry-level role responsible for the foundational execution of analytical tasks, data management, and reporting to support the Advanced Analytics team. This role focuses on ensuring the accuracy, efficiency, and maintenance of analytical assets and data processes, contributing directly to the team's ability to deliver insights without direct client interaction. The Junior Analyst will utilize a range of analytic techniques and tools to produce reliable operational reports and support internal data integrity initiatives. Responsibilities: Reporting & Dashboard Development: Build and maintain recurring reports and dashboards according to specifications provided by Advanced Analytics Consultants and other team members. Perform basic to moderate updates and optimizations of existing performance dashboards (e.g., "trend cards"). Confirm updates of files through internal recurring task processes. Address fiscal calendar challenges by ensuring reports are correctly populated and aligned with internal requirements. Data Management & Quality: Perform data extraction, transformation, and loading for routine analytical tasks. Ensure data quality and accuracy in all delivered outputs, proactively identifying and escalating discrepancies. Investigate and reconcile discrepancies between internal dashboards and manual reports, identifying root causes. Process Optimization & Maintenance: Automate and optimize repetitive reporting processes to enhance efficiency. Update and maintain existing analytical assets, methodologies, tools, and templates. Contribute to the development and maintenance of appropriate internal documentation regarding analytic approaches, metric definitions, and data processes. Team Support: Support the Advanced Analytics team in various internal projects as directed by leadership. Proactively seek opportunities to improve existing internal processes and analytical outputs. Specific tasks: Recurring Reporting: Set up and optimize basic-to-moderate trend cards for internal tracking and analysis. Execute routine data pulls and transformations for standard reporting. Monitor and confirm successful completion of recurring reporting tasks via internal tools. Adjust reports and data based on fiscal calendar requirements to maintain accuracy. Data Investigation: Investigate data discrepancies between various internal reporting tools and manual reports to ensure consistency and reliability. Asset Management: Assist in updating and maintaining internal databases, analytical models, and reporting templates. Required Skills and Experience: Candidate will have at least 1 year of experience in analytics/reporting and/or data management. Analytical Skills - Analyzing and synthesizing information to understand issues and identify options. Ability to translate internal requirements into reporting/analysis specifications. Technical Abilities - Proficiency in Microsoft Excel, including experience with Pivot Tables, advanced formulas, and data manipulation. Familiarity with the broader Microsoft Office Suite (e.g., PowerPoint, Word, Outlook) is beneficial. Experience with Strategy (formerly MicroStrategy) or comparable Business Intelligence (BI) tools (Tableau, Power BI, etc.) would be a significant plus. Familiarity with Python for automation initiatives and data manipulation/analysis is beneficial. Organizing and Planning - Ability to plan, organize, and prioritize work, balancing resources, skills, and timescales to achieve objectives. Capable of managing multiple analytical tasks simultaneously. Adaptability - Ability to respond and adapt to changing circumstances and to manage, solve problems, and provide solutions in a climate of ambiguity. Proactive in seeking solutions and learning new approaches. Communicating Effectively - Writes effectively; adjusts to fit the audience and the message. Ability to clearly articulate analytical findings and data issues internally, both verbally and in writing. Team Player - Proven ability to manage strong working relationships within the company. Able to complete tasks and work cooperatively with others. Actively contributes to team knowledge sharing and best practices. About Rakuten Advertising: Rakuten Advertising delivers performance-driven, brand-driven, and people-driven ad solutions that help the world’s top brands connect with unique, highly engaged audiences – from first impression to final sale. Backed by industry-leading technology, global media properties, and the largest, high-quality partner network, Rakuten Advertising taps into decades of data and experience to develop the strategies and ad experiences that will drive engagement, sales, loyalty, and beyond. A leader in the industry since its beginnings, Rakuten Advertising is a division of Rakuten Group, Inc. (4755: TOKYO), one of the world’s leading internet service companies. The company is headquartered in San Mateo, California, with offices throughout EMEA, APAC, LATAM, and North America. Learn more at . Five Principles for Success Our worldwide practices describe specific behaviors that make Rakuten unique and united across the world. We expect Rakuten employees to model these 5 Shugi Principles of Success. Always improve, Always Advance - Only be satisfied with complete success - Kaizen Passionately Professional - Take an uncompromising approach to your work and be determined to be the best H ypothesize - Practice - Validate – Shikumika - Use the Rakuten Cycle to succeed in unknown territory Maximize Customer Satisfaction - The greatest satisfaction for our teams is seeing their customers smile Speed!! Speed!! Speed!! - Always be conscious of time - take charge, set clear goals, and engage your team