About the Role
Responsible for the development and execution of analyses that address specific client issues or initiatives. This role proactively identifies trends and issues utilizing a comprehensive range of analytic techniques and tools, translating complex business questions into actionable analytical solutions. The Consultant liaises directly with client services, network development, and operational personnel, and engages directly with clients to ensure the appropriateness of underlying assumptions and interpretations, and to provide expert direction on client analytics solutions/services, both internally and externally.
Responsibilities
- Lead the development and delivery of client analytics and reporting activities, driving client relationship building, and managing the overall project lifecycle of externally focused analytic deliverables.
- Independently develop and refine methodologies, tools, and templates to allow for the successful execution of analytic deliverables.
- Proactively identify opportunities for innovation and efficiency.
- Support the ongoing development of the Advanced Analytics group capabilities by sharing innovative approaches and solutions with the broader team, and actively mentor junior team members.
- Develop and deliver training content to Account Management and other internal functions.
- Lead the development and maintenance of appropriate documentation regarding advanced analytic approaches, metric definitions, etc.
- Proactively identify client business needs and translate them into robust analytical questions and solution designs.
- Present complex analytical findings and strategic recommendations directly to clients, influencing their decision-making processes.
- Lead client discussions to define analytical objectives and scope, guiding them towards the most impactful solutions.
- Design and execute advanced custom analyses leveraging internal tools/databases, delivering comprehensive insights and strategic recommendations.
- Develop and optimize complex trend analyses and performance dashboards, ensuring they align with evolving client needs and provide actionable intelligence.
- Oversee and ensure the integrity and accuracy of recurring reports and data pipelines, proactively resolving complex data discrepancies.
- Manage and adapt reporting structures to accommodate complex client requirements, including fiscal calendar challenges.
- Investigate and resolve complex discrepancies between dashboards and manual reports, implementing long-term solutions for data consistency.
- Independently assess and forecast sales potential for prospects based on comprehensive data analysis and market insights, providing strategic input to sales teams.
- Contribute to the strategic development of new analytical products and services based on client needs and market trends.
Requirements
- At least 2 years of experience in analytics/reporting, with a strong focus on client-facing roles or significant project ownership.
- Experience from an agency, client, or consulting environment.
- Advanced Analytical Skills – Expert in analyzing and synthesizing complex information to understand issues, identify root causes, and propose optimal solutions.
- Demonstrated ability to independently translate ambiguous business requirements into precise analytical questions and comprehensive solution designs.
- Proven ability to utilize and expand prospective business models.
- Proficiency in Microsoft Excel (including advanced functions, VBA).
- Strong experience with Business Intelligence (BI) tools (e.g., Tableau, Power BI, MicroStrategy) for dashboard development and data visualization.
- Proficiency in SQL for data extraction and manipulation is required.
- Familiarity with Python or R for advanced analytics and automation is highly beneficial.
- Proven ability to independently manage diverse client and internal stakeholder relationships, effectively communicating complex analytical concepts to both technical and non-technical audiences.
- Builds strong networks and acts as a trusted advisor.
- Demonstrated ability to independently plan, organize, and prioritize multiple complex projects, effectively balancing resources, skills, priorities, and timescales to achieve objectives.
- Adaptable and proactive in responding to changing circumstances, effectively managing, solving problems, and providing innovative solutions in ambiguous environments.
- Written and verbal communication skills, with a proven ability to adjust messaging to fit diverse audiences and deliver compelling presentations that drive action.
- Proven ability to manage strong working relationships within the company, and actively contribute to team knowledge sharing, mentorship, and best practices.
- Strong in using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to complex problems.
- Proactively identifies potential problems and independently creates robust contingency plans or “work-arounds” to ensure project success.
- Knows the mission-critical technical and functional skills needed; understands various types of business propositions and how businesses operate.
- Continuously learns new methods and technologies.
Skills
- Analytics
- Reporting
- Client-facing
- Project ownership
- Agency experience
- Client experience
- Consulting experience
- Advanced analytical skills
- Information synthesis
- Root cause analysis
- Solution design
- Business modeling
- Microsoft Excel
- VBA
- Business Intelligence (BI) tools
- Tableau
- Power BI
- MicroStrategy
- Dashboard development
- Data visualization
- SQL
- Data extraction
- Data manipulation
- Python
- R
- Advanced analytics
- Automation
- Client management
- Stakeholder management
- Communication
- Technical communication
- Non-technical communication
- Networking
- Trusted advisor
- Planning
- Organizing
- Prioritization
- Project management
- Resource balancing
- Adaptability
- Problem-solving
- Innovation
- Written communication
- Verbal communication
- Presentation skills
- Teamwork
- Knowledge sharing
- Mentorship
- Best practices
- Critical thinking
- Logic
- Reasoning
- Contingency planning
- Business understanding
- Learning agility
Location
- San Mateo, California
Work Type
- Full-time
Experience Level
- 2 years of experience
Education Level
- Bachelor’s degree
About the Company
- 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, the Rakuten International business portfolio includes market leaders in e-commerce, digital marketing, advertising, communications and entertainment.
- We create 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 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.
