Data Analyst (1-year Contract)

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 80,000 brilliant minds with expertise in data, technology, media, strategy, creativity and business transformation, all literally at your fingertips.

 

Go ahead, the world is waiting.

 

Publicis Groupe is the third 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. Two of its biggest solution hubs in Singapore - Publicis Communications and Publicis Media & Digital.

 

Publicis Communications, the creative communications hub of the Publicis Groupe, is a collective of the most passionate, purposeful, and progressive creative agencies in Singapore. They are Publicis Worldwide, Leo Burnett, Saatchi & Saatchi, Prodigious, and MSL.

 

Publicis Media & Digital, which is comprised of global media agency brands Starcom, Zenith, Spark Foundry, and Performics, is powered by digital-first, data-driven global practices that together, help our clients navigate the modern media landscape.

 

Our two other solution hubs, Publicis Sapient and Publicis Commerce, empower businesses to embrace digital transformation and equip them with a total commerce experience.

Overview

We are seeking a skilled Data Intelligence Analyst to join our team. The ideal candidate should have solid data literacy, project management, and communication skills. This exciting role will be a key member of a motivated and high-profile team working on cutting-edge solutions. The candidate should possess strong data processing skills and technical capability. Additionally, the role will eventually manage projects/Deliverables for major multinational clients around the world, for which a knowledge of the digital media industry is an advantage. The candidate should also be comfortable with working with both internal and external stakeholders, including the ability to liaise and present to non-technical stakeholders.

Responsibilities

Data Literacy & Expertise: 

• Develop and Manage Reporting Solutions - Design, build, and maintain data dashboards and reports using Looker Studio, Tableau, or Power BI, leveraging Google BigQuery to extract and visualize marketing data. 

• Data Transformation and Analysis - Use Google BigQuery to load, clean, and transform large datasets, supporting digital marketing initiatives by ensuring data accuracy and reliability for campaign tracking and performance measurement. 

• Insights Generation - Analyze campaign performance, audience data, and digital channels to generate actionable insights that inform marketing strategies, targeting, and media optimization efforts. 

• Proposal and Report Building - Collaborate with cross-functional teams to develop data-driven proposals, presentations, and reports for internal stakeholders/clients. 

• SQL and Python Data Manipulation - Write and optimize SQL queries to extract data from BigQuery, apply Python to automate workflows and conduct advanced analytics. 

• Performance Optimization - Monitor and refine BigQuery workflows and queries to improve reporting efficiency and reduce processing time and costs. 

• Data Governance and Compliance - Ensure marketing data complies with privacy regulations and data governance policies while maintaining high standards of data integrity and security.  

Project Management 

• Actively participate in competitive intelligence roadmap discussions and prioritize analysis. 

• Create and deliver data outputs, customized reports, ad hoc analyses, and data visualizations to support new business pitches across the region. 

• Assist in managing and prioritizing multiple projects while maintaining necessary process documents and procedures to ensure data accuracy. 

• Organized, detail-oriented, and QA-focused approach. 

Networking 

• Build strong working relationships with clients, vendors, and internal stakeholders across the region. 

• Should actively participate in managing client requirements, maintaining SLAs & SOWs documentation, and team deliverables. 

• One should be self-motivated to opportunities to improve existing client relationships.

Qualifications

• Minimum 1 year of experience in data processing, data engineering, ETL using SQL. 

• Experience in BI technologies like Google Looker Studio, Tableau, and Power BI is a must, with intermediate-level skills. 

• Hands-on experience in data integration and manipulation using SQL, and BigQuery. Familiarity with GCP is an added plus. 

• Knowledge of scripting and programming in Python, JavaScript or Typescript is an added. 

• Familiarity with media research systems such as Netbase, Brandwatch, SimilarWeb, and SemRush is preferred. 

• Advanced level user in Excel and PowerPoint: pivot tables, charts, v-lookups, and dashboard creation. 

• A basic understanding of statistical analysis and research. 

• Familiarity with media performance analytics and reporting would be an added. 

• Self-starter, highly motivated, and  

• Highly organized, able to multi-task, and set. 

• Possess a desire to work for a high-profile, dynamic & results-based.