Data Intelligence Analyst - Marketing Analytics & Dashboards

Starcom Worldwide, Inc.; Kuala Lumpur; On-site; MYR 90,000 - 150,000; Full time

Job summary

Publicis Groupe in Malaysia is seeking a Data Intelligence Analyst to join our regional team in Kuala Lumpur. You will design dashboards, perform data transformations, and generate actionable insights for digital marketing across multinational clients.

The role requires hands-on skills with BigQuery, Looker Studio/Tableau/Power BI, SQL, and Python, plus strong communication with internal and external stakeholders.

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.

Responsibilities

• 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.
• Networking - Build strong working relationships with clients, vendors, and internal stakeholders across the region.

Skills

Data processing

SQL

Python

BigQuery

Looker Studio

Tableau

Power BI

Excel

PowerPoint

JavaScript

Typescript

Tools

Netbase

Brandwatch

SimilarWeb

SemRush

Google Cloud Platform

Job description

Publicis Groupe in Malaysia is seeking a Data Intelligence Analyst to join our regional team in Kuala Lumpur. You will design dashboards, perform data transformations, and generate actionable insights for digital marketing across multinational clients.

The role requires hands-on skills with BigQuery, Looker Studio/Tableau/Power BI, SQL, and Python, plus strong communication with internal and external stakeholders.