Job Title

Company DescriptionAustralian Business Awards - Employer of Choice 2023, 2022 & 2021 HR Awards - Excellence Awardee, Employer of Choice 2022 AFR BOSS Best Places to Work - 2022 HRD Employer of Choice - 2021Welcome to Publicis Groupe ANZ.Here you will get an inside look at life within our network, including the brilliant people working across our agency brands. Publicis Groupe is a world leader in marketing communication and digital business transformation, driven through the alchemy of data, creativity, media, and technology.Our connected platform of companies and capabilities is more than an operational framework.Its a cultural model we''ve built to unite our people in a collaborative way of thinking and working. Publicis Groupe offers its clients seamless access to the expertise of its 80,000 talents across 100 countries globally.In Australia, our powerhouse of marketing capabilities stretches across creative agencies (Saatchi & Saatchi, Leo, Publicis Worldwide), media agencies (Starcom, Zenith, Spark Foundry, Performics, Atomic 212), Razorfish, Digitas, Epsilon, Arc, Prodigious, PXP, PMX, and PR (Herd MSL). We also have Publicis Sapient driving digital business transformation for our clients.Job DescriptionWe are seeking a motivated and detail-oriented Data Analyst to join our intelligence team in Melbourne.More than just number crunching, in this role, youll assist in gathering, processing, and analysing data to help make informed decisions for our clients. Working closely with the Analytics Manager and Strategy Director, youll generate actionable insights that directly influence high-profile marketing campaigns and business strategies. Youll 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.ResponsibilitiesDay to day youll:Assist in collecting, organizing 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 dataCreate and maintain data visualizations, 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.QualificationsThe 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 visualization 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 runBonus points for experience with:Python, R, or other programming languages used for data analysis.Data warehousing and ETL processes.Salesforce CRM and marketing cloudData cleaning and transformation toolsCloud platforms like AWS or Google Cloud.Additional InformationPublicis 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: 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.#LI-LJ2 #J-18808-Ljbffr