Data Analyst (PowerBi/Excel)

Data Analyst (PowerBi/Excel)

London Full-Time 28800 - 42000 £ / year (est.) Home office (partial)
P

At a Glance

  • Tasks: Analyse and report business investment data using PowerBI and Excel.
  • Company: Join Publicis Groupe, a global leader in communications with 100,000 professionals across 110 countries.
  • Benefits: Enjoy hybrid working, corporate perks, and a supportive environment for all candidates.
  • Why this job: Be part of a dynamic team that values creativity and innovation in the platform world.
  • Qualifications: Strong Excel skills and experience with PowerBI; media knowledge is a plus.
  • Other info: We celebrate diversity and support fair assessment processes for all applicants.

The predicted salary is between 28800 - 42000 £ per year.

Publicis Groupe is one of the world’s largest communications holding companies, present in over 110 countries and employing about 100,000 professionals. The Groupe is positioned at every step of the value chain, from consulting to execution, combining marketing transformation and digital business transformation.

The Data Analyst reports into the Head of Analytics and is responsible for collecting, aggregating, and reporting business investment data (client, supplier and Publicis product investment). The Data Analyst will be successful and enjoy the role if he/she has an inquisitive problem-solving mind, excellent attention to detail, and can build strong working relationships with stakeholders. PMX’s reporting continually evolves and improves so there is significant creative scope to develop new skills and apply new tools.

Responsibilities:
  • Managing business investment data across a multi-market remit
  • Ensuring that local market contacts deliver a range of reports on time and to a sufficient standard
  • Using Alteryx to aggregate and clean data on a periodic basis
  • Updating multiple PowerBI dashboards
  • Responding to requests for data and inquiries into the figures from all areas of the business
Qualifications:
  • Excellent Excel skills: The candidate must be comfortable with large datasets, formulas, and pivot tables.
  • Experience using reporting and dashboarding tools for example PowerBI
  • An understanding of the media and advertising space would be advantageous to this role

Publicis Groupe operates a hybrid working pattern with full time employees being office-based three days during the working week. We are supportive of all candidates and are committed to providing a fair assessment process. If you have any circumstances (such as neurodiversity, physical or mental impairments or a medical condition) that may affect your assessment, please inform your Talent Acquisition Partner. We will discuss possible adjustments to ensure fairness. Rest assured, disclosing this information will not impact your treatment in our process.

Data Analyst (PowerBi/Excel) employer: Publicis Groupe UK

Publicis Groupe is an exceptional employer that fosters a vibrant work culture rooted in diversity and innovation. With a commitment to employee growth, the company offers extensive learning opportunities through its AI-driven platform, Marcel, and encourages collaboration across its global network. Located in a dynamic environment, employees benefit from a hybrid working model that promotes work-life balance while engaging in meaningful projects that drive transformation in the marketing and advertising landscape.
P

Contact Detail:

Publicis Groupe UK Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Analyst (PowerBi/Excel)

✨Tip Number 1

Familiarise yourself with PowerBI and Excel by working on personal projects or online courses. This hands-on experience will not only boost your confidence but also give you practical examples to discuss during interviews.

✨Tip Number 2

Network with professionals in the media and advertising space. Attend industry events or join relevant online forums to gain insights and make connections that could lead to referrals or insider information about the role.

✨Tip Number 3

Stay updated on the latest trends in data analytics and the advertising industry. Being knowledgeable about current developments will help you demonstrate your passion and understanding of the field during discussions with potential employers.

✨Tip Number 4

Prepare to showcase your problem-solving skills by thinking of specific examples where you've successfully tackled data-related challenges. This will help you stand out as a candidate who can add value to the team at Publicis Groupe.

We think you need these skills to ace Data Analyst (PowerBi/Excel)

Advanced Excel Skills
Power BI Proficiency
Data Aggregation and Cleaning
Strong Analytical Skills
Attention to Detail
Problem-Solving Skills
Stakeholder Management
Reporting and Dashboarding
Understanding of Media and Advertising
Data Visualisation Techniques
Communication Skills
Time Management
Adaptability to Evolving Reporting Needs
Experience with Alteryx

Some tips for your application 🫡

Understand the Role: Before applying, make sure you fully understand the responsibilities and qualifications required for the Data Analyst position. Familiarise yourself with tools like PowerBI and Excel, as well as the media and advertising space.

Tailor Your CV: Customise your CV to highlight relevant experience and skills that align with the job description. Emphasise your proficiency in Excel, experience with data aggregation, and any familiarity with reporting tools like PowerBI.

Craft a Compelling Cover Letter: Write a cover letter that showcases your problem-solving mindset and attention to detail. Mention specific examples of how you've successfully managed data projects or collaborated with stakeholders in the past.

Proofread Your Application: Before submitting, carefully proofread your application materials. Check for any spelling or grammatical errors, and ensure that all information is accurate and clearly presented.

How to prepare for a job interview at Publicis Groupe UK

✨Showcase Your Excel Skills

Since the role requires excellent Excel skills, be prepared to discuss your experience with large datasets, formulas, and pivot tables. You might even want to bring examples of your previous work or projects where you effectively used these skills.

✨Familiarise Yourself with PowerBI

As PowerBI is a key tool for this position, ensure you understand its functionalities and can discuss how you've used it in past roles. Consider preparing a brief overview of a dashboard you've created or improved, highlighting the impact it had on decision-making.

✨Understand the Media and Advertising Landscape

Having a grasp of the media and advertising space will give you an edge. Research current trends and challenges in the industry, and be ready to discuss how data analysis can drive growth and innovation in this field.

✨Demonstrate Your Problem-Solving Mindset

The job description mentions an inquisitive problem-solving mind as a key trait. Prepare to share examples of how you've tackled complex data challenges in the past, focusing on your analytical approach and the solutions you implemented.

Data Analyst (PowerBi/Excel)
Publicis Groupe UK
P
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>