Data Analyst

Company Description

Consumer habits are anything but linear and attention must be earned. At Digitas, we understand that to break through, brands must be surprising, entertaining, and authentic.

Driven by imagination and fueled by deep cultural, consumer, and business insights, we craft impactful creative experiences across every medium — from integrated campaigns, gaming, and physical experiences to full-length feature films.

We earn the right for brands to be part of their customers’ networks. We drive growth with our amazing clients through our capabilities in Consulting, Products & Platforms, Customer Engagement, and Digital Media.

Part of Publicis Groupe and a Leader in Gartner’s Magic Quadrant for Global Marketing Agencies, we’re proud to work with some of the world’s leading brands.

Overview

Digitas — The Networked Experience Agency.

We are seeking a motivated and detail-oriented Data Analyst to join our intelligence team in Sydney.

More than just number crunching, in this role, you’ll assist in gathering, processing, and analysing data to help make informed decisions for our clients. Working closely with the Analytics Manager and Strategy Director, you’ll generate actionable insights that directly influence high-profile marketing campaigns and business strategies. You’ll work with diverse data sets and develop a well-rounded analytical skill set.

Hungry to learn and grow in the field of data analytics? Read on.

Responsibilities

Day to day you’ll:

• Assist in collecting, organising and visualising data from various sources (internal systems, databases, and external data providers).
• Clean, preprocess, and structure raw data to ensure it is accurate and usable for analysis.
• Perform basic data analysis using statistical methods and tools to identify trends, patterns, and insights using various campaign and other data
• Create and maintain data visualisations, reports, and dashboards to present findings.
• Help design and run queries to extract data from databases using SQL or other data tools.
• Support senior team members in preparing data for reports, presentations, and meetings.
• Collaborate with cross-functional teams to understand data requirements and contribute to projects.
• Ensure data integrity and consistency across various platforms and tools.

Qualifications

The person we are looking for has:

• Proficiency in Microsoft Excel, including advanced functions (VLOOKUP, Pivot Tables, etc.).
• Advanced knowledge of SQL , ( MYSQL, T-SQL), and experience querying databases, (eg; SQL Server Management Studio).
• Proficiency with data visualisation tools like Power BI, Tableau, or similar.
• Understanding of statistical analysis methods.
• Strong analytical and problem-solving skills.
• Ability to communicate data insights clearly to both technical and non-technical teams.
• Understanding of campaign analytics, minimum knowledge of how a campaign is run

Bonus Points For Experience With

• Python, R, or other programming languages used for data analysis.
• Data warehousing and ETL processes.
• Salesforce CRM and marketing cloud
• Data cleaning and transformation tools
• Cloud platforms like AWS or Google Cloud.

Additional Information

Publicis Groupe benefits: Be a part of the Publicis Groupe family, recent winner of the Employer of Choice Awards and one of the world's most progressive and dynamic modern communications businesses. You can learn more about us at www.publicisgroupeanz.com.

Enjoy all the perks that come with our network offering:

• A comprehensive Wholeself program supporting physical, mindful, and financial wellbeing.
• A creative, lively, and rewarding office environment where people love working with each other, supported by our Publicis Liberté flexibility approach — 'working your way with us.'
• Access to our Global AI Platform Marcel, connecting Publicis Groupe employees with opportunities for career mobility and collaboration across our global network.
• Extensive Learning & Development opportunities including more than 15,000 learning programs via our online learning platform, Marcel Classes.
• A culture of open feedback and support to reach your goals through our Career Conversations program.
• A committed Diversity, Equality, and Inclusion strategy driven through our Viva Women, Égalité, enABLE, EmbRACE, and Écologique committees.
• Leave benefits including Birthday Leave, Flexible Public Holidays, and an additional 5 days of leave after 2 years of service.
• Work Your World program enabling employees the flexibility to work from anywhere in the world for up to 6 weeks per year.
• Parental leave policy with up to 18 weeks based on tenure, paid primary carer leave, secondary carer swap, and Cub Care leave.
• Access to counsellors, psychologists, and professionals through Sonder, an all-in-one digital wellbeing technology platform designed to support psychological, medical & safety needs.
• A workplace that stands together to provide a more open, supportive, and recovery-forward culture for all employees with life-threatening illnesses. Read more about our Working With Cancer Pledge: https://workingwithcancerpledge.com/
• Proud partners of Diversity Council Australia, Pride in Diversity, Family Friendly Workplaces, Supply Nation, and the Australian Disability Network.

If you don't tick every box in this ad, please don't rule yourself out. Research suggests that women and other people in underrepresented groups tend to only apply if they meet every requirement. We focus on hiring people who share our values of inclusion, collaboration, adaptability, fearlessness, and integrity rather than ticking boxes — so if this role resonates with you, please apply.

Diversity. Inclusion. Equity. More than just words; these are part of our DNA. At Publicis Groupe, we are committed to the inclusion and recognition of all people regardless of race, age, culture, ability, ethnicity, gender identity or expression, sexual orientation, marital status, and religious affiliation. We believe that to deliver the best solutions to our clients, our people need to reflect the diverse communities in which our clients operate. We value diversity and the skills, knowledge, and experience that difference brings to our culture and solutions.

Uniqueness is powerful; without it, we wouldn't be where we are today. So be you — we like it that way.

We are committed to providing reasonable adjustments for people with disability or those that require additional support throughout the application process. If you need any assistance or adjustments, please contact us via recruitment@publicisgroupe.com; your personal information will be kept confidential.

Key skills/competency

• Data analysis
• SQL
• Microsoft Excel
• Data visualization
• Campaign analytics
• Statistical analysis
• Problem-solving
• Data integrity
• Reporting
• Cross-functional collaboration