Data Analyst

Publicis Groupe Malaysia; Kuala Lumpur; On-site; MYR 60,000 - 80,000; Full time

Job summary

Publicis Groupe Malaysia is seeking a skilled Data Intelligence Analyst to join their team in Kuala Lumpur. The successful candidate will possess strong data literacy and project management skills and will work on developing and managing reporting solutions using tools like Looker Studio, Tableau, and Power BI.

In this role, you will analyze campaign performance and generate actionable insights while collaborating with cross-functional teams. Ideal applicants will have hands-on experience in SQL, Python, and various media research systems, as well as advanced capabilities in Excel and PowerPoint.

Qualifications

• Minimum 1 year of experience in data processing and data engineering using SQL.
• Hands-on experience in SQL and BigQuery; familiarity with GCP is a plus.
• Advanced level user in Excel and PowerPoint.

Responsibilities

• Develop and manage reporting solutions using data dashboards and reports.
• Analyze campaign performance and audience data to generate actionable insights.
• Assist in managing and prioritizing multiple projects.

Skills

Data literacy

Project management

Communication skills

SQL

Python

Data visualization tools (Looker Studio, Tableau, Power BI)

Google BigQuery

Excel

PowerPoint

Tools

Google Looker Studio

Tableau

Power BI

BigQuery

GCP

Media research systems (NetBase, Brandwatch, etc.)

Job description

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, and will be a key member of a high‑profile team working on cutting‑edge solutions.

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 and 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.
• Actively manage client requirements, maintain SLAs & SOWs documentation, and team deliverables.

Qualifications

• Minimum 1 year of experience in data processing, data engineering, and ETL using SQL.
• Experience in BI technologies like Google Looker Studio, Tableau, and Power BI; intermediate‑level skills.
• Hands‑on experience in data integration and manipulation using SQL and BigQuery; familiarity with GCP is a plus.
• Knowledge of scripting and programming in Python, JavaScript, or TypeScript.
• Familiarity with media research systems such as NetBase, Brandwatch, SimilarWeb, and Semrush.
• Advanced level user in Excel and PowerPoint: pivot tables, charts, V‑lookups, and dashboard creation.
• Basic understanding of statistical analysis and research.
• Familiarity with media performance analytics and reporting.
• Self‑starter, highly motivated.
• Highly organized, able to multi‑task, and set.
• Desire to work for a high‑profile, dynamic, and results‑based environment.