Data Analyst

Company description

Publicis Groupe is not just a company you work for; it’s a platform for you to take your talent to the world. If you want to help change the world, ideas alone are not enough. Real impact can only come from having meaningful access to a world of knowledge, people, and resources.

At Publicis Groupe, you are connected to our global network, intelligence, tools, clients, brands and 90,000+ brilliant minds with expertise in data, technology, media, strategy, creativity, and business transformation, all literally at your fingertips.

Publicis Groupe is the largest communications group in the world. Founded in Paris in 1926, we are present in more than 100 countries as leaders in marketing, communication, and digital business transformation. Over the past three years our Japan Media team has won numerous pieces of business, making us the one of the fastest growing agencies in Japan and we are now looking to expand the team.

This represents a great opportunity to join a fast moving, award winning media team, that offers massive potential for career growth, the opportunity to work overseas via our Work Your World programme, a leading SGD programme and many more career and life expanding programmes.

Overview

This candidate is tasked to extract and manage campaign data sets from a variety of data sources including CRM, sales, web/app analytics and third parties, and analyze and report to improve activities and to build strategies. The candidate will work closely with primarily Quick Service Restaurants (QSR), automotive and possibly CPG (tobacco, fast food, etc.) clients. The candidate will need to work with all internal departments of the agency.

This is someone with ability to problem solve with data analysis skills, Strong communication and interpersonal skills and presentation ability to communicate insights and solutions to key business stakeholders.

Responsibilities

What you will do with us:

• Extract and cleanse data from multiple data sources to create audience segmentation and targeting CRM campaigns.
• Identify insights and opportunities from the segmentation of tracked behaviors and profiles.
• Perform detailed strategic analysis that contributes to the client's annual marketing plan. Identify solutions to client problems and new opportunities from a medium-long term perspective.
• Design data acquisition and A/B testing.
• Generate promotional response reports that are easy to understand for all members of different positions like clients, strategists, creative and media persons.

Qualifications

What you will bring:

• Knowledge of Relational Database structures.
• Excel skills
• At a minimum, must be proficient in creating pivot tables, filterable reports and reports with mathematical functions.
• Experience with SQL
• At a minimum, must be proficient in joins, aggregate functions, date/time manipulation and nested records
• Must be able to understand and use basic statistical methods and data analytics. Machine learning skills are a plus.
• Experience in CRM related areas such as database marketing, campaign management, data analysis, etc.
• Experience with web analytics tools (Adobe Analytics, Google Analytics).
• R/Python skills are beneficial but not essential.
• Power Pivot and Power Query skills are beneficial but not essential.
• Experience using DBT, Airflow, Jira, Gitlab or GCP is beneficial but not essential.
• Two years or more work experience preferred.
• Business fluent English

Additional information

What Publicis Groupe can offer you

Be a part of the Publicis Groupe family - one of the world’s most progressive and dynamic modern communications businesses enjoying all the perks that come with our network offering:

• A hybrid, full flex work style, with 3 days a week spent meeting your clients and/or colleagues face to face.
• Extensive Learning & Development opportunities, including more than 15,000 learning programs via our online learning platform Marcel Classes
• Work Your World program enabling employees the flexibility to work from anywhere in the world for up to 6 weeks per year
• A culture of open feedback and support to reach your goals through our Career Conversations program
• Access to our Global AI Platform, Marcel, connecting Publicis Groupe employees with opportunities for advancement and collaboration with our global network
• And many more benefits, including a range of leaves, health related support, and so forth.

Publicis Groupe believes that our people are our greatest asset. Our people are chosen for their skill sets, their ethics and professional qualities without any exclusion, preferential treatment, or discrimination. We are proud to be an equal opportunities employer and do not discriminate by reason of age, gender, gender identity, race, sexual orientation, nationality, religion or disability or any other difference. We encourage applications from all qualified individuals and will provide appropriate assistance for candidates who may need other considerations or adjustments throughout the recruitment process upon request.