Marketing Data Analysis & Reporting, Executive (Power BI & SQL)

Watson's Personal Care Stores; Kuala Lumpur; On-site; MYR 48,000 - 60,000; Full time

Job summary

A leading health and beauty retailer in Malaysia seeks a Marketing Data Analysis & Reporting Executive. The role involves analyzing customer data, monitoring campaign performance, and ensuring data integrity. Ideal candidates should have a strong analytical background and experience in marketing analytics.

Qualifications

• 2–3 years of experience in CRM, marketing analytics, or data analysis.
• Familiarity with CRM platforms is a plus.

Responsibilities

• Analyze customer database and segment users based on behavior.
• Monitor and evaluate marketing campaign effectiveness across channels.
• Support ad-hoc analysis into customer behavior and marketing performance.

Skills

Analytical Skills

Data Visualization

Detail-oriented

Education

Bachelor’s Degree in Science, Mathematics, Statistics, Data Science

Tools

Excel

SQL

Power BI

Tableau

Job description

Marketing Data Analysis & Reporting, Executive (Power BI & SQL)

Add expected salary to your profile for insights.

Key Responsibilities:

1. Customer Data Analysis
   • Analyze customer database and segment users based on behavior, demographics, and lifecycle stage.
   • Track and report customer retention, churn, reactivation, and LTV (lifetime value) trends.
   • Support personalization and targeting strategies through data-driven segmentation.
2. Campaign Performance Reporting
   • Monitor and evaluate marketing campaign effectiveness across channels (EDM, WhatsApp, SMS, Social, Paid Ads, etc.).
   • Build and maintain dashboards to track KPIs such as open rate, click-through rate, conversion rate, and ROI.
   • Provide actionable insights and recommendations to improve campaign performance.
3. Marketing Automation Support
   • Collaborate with the CRM & Performance team to set up automated journeys and triggers based on customer data and behavior.
   • Analyze journey performance and suggest optimization points.
4. Business Intelligence
   • Support ad-hoc analysis and deep dives into customer behavior, marketing performance, and sales trends.
   • Work closely with cross-functional teams (e.g., Online Business & Trading) to align insights with business goals.
5. Data Governance & Integrity
   • Ensure accuracy and integrity of data used in reporting.
   • Collaborate with IT/Regional teams to maintain data hygiene and resolve discrepancies.

Requirements:

• Bachelor’s Degree in Science, Mathematics, Statistics, Data Science, or a related field.
• 2–3 years of experience in CRM, marketing analytics, or data analysis.
• Strong analytical skills with proficiency in Excel, SQL, and data visualization tools (e.g., Power BI, Tableau).
• Familiarity with CRM platforms (e.g., Salesforce, Adobe Campaign, etc.) is a plus.
• Detail-oriented with ability to translate complex data into clear and concise insights.
• Comfortable working in a fast-paced, collaborative environment.
• Knowledge of RFM analysis, predictive modeling, or A/B testing.
• Basic understanding of digital marketing metrics and tools (e.g., AppsFlyer, Google Analytics, Meta Ads Manager).

How do your skills match this job?

Sign in and update your profile to get insights.

Your application will include the following questions:

• Which of the following statements best describes your right to work in Malaysia?
• What's your expected monthly basic salary?
• How much notice are you required to give your current employer?

Retail & Consumer Products, 5,001-10,000 employees

About Watsons Malaysia

Watsons Malaysia is the leading health and beauty retailer with more than 700 Watsons stores and growing in the country, serving the needs of all Malaysians.

Watsons continues to inspire our customers to enjoy life to the fullest and set the standards in the health, wellness, and beauty market, providing personalized advice in health, beauty, and personal care, alongside its market-leading product ranges, making customers LOOK GOOD, DO GOOD, FEEL GREAT every day.

Watsons Malaysia won the Platinum Award for the Best in Retail Category 2023 by Putra Brands Award, a premier and only brand award in Malaysia voted by Malaysian consumers.