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 Business Intelligence Intern to join our team. This exciting role will be a key member of a motivated and high-profile team working on cutting-edge solutions. The candidate should possess data processing skills, training will be provided on the job for the specific solution they require to deliver.
Responsibilities
- Set up reporting solutions - 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.
- SQL and Python Data Manipulation - Write and optimize SQL queries to extract data from BigQuery.
Qualifications
- Hands-on experience in data integration and manipulation using SQL, BigQuery, and Python. Familiarity with GCP is an added plus.
- Experience in BI technologies like Google Looker Studio, Tableau, and Power BI is a must, with intermediate-level skills.
- Advanced level user in Excel and PowerPoint: pivot tables, charts, v-lookups, and dashboard creation.
- A basic understanding of statistical analysis and research methodologies.
- Self-starter, highly motivated, and proactive and solutions-driven.
- Highly organized, able to multi-task, and set priorities.
- Thrives in a fast-paced environment.