Data Analyst

Salary: RM 4,000 – RM 6,000 per month

PRIZM Group is a global agency with specialisation in digital marketing, social media, big data, and eCommerce with over 200 staff in 5 offices including Hong Kong and Singapore. The group’s expertise lies beyond a mere digital solution but synchronizing MarTech and Creativity to empower the formation of seamless digital experience. In 2022, PRIZM Group was crowned the prestige overall Agency of the Year hosted by Marketing Interactive.

To support our rapid growth at HQ, we are establishing a new team in Malaysia. We are seeking high-caliber candidates to join our innovative and exciting IT solutions company.

Responsibilities

• Reporting & Data Processing: Develop and maintain SQL queries and Python workflows to generate recurring business reports, customer data extracts, and performance analyses accurately and efficiently.

• Data Logic & Business Understanding: Understand end-to-end data flows, identify appropriate data sources, and apply the correct business logic and metric definitions to meet reporting and CRM requirements.

• Workflow Automation & Customer Tagging: Develop, schedule, and maintain automated customer tagging and segmentation workflows to support daily CRM operations, reduce manual work, and improve operational efficiency.

• Dashboard Development & Visualization: Develop and maintain BI dashboards using Power BI or similar tools to monitor business performance, customer behavior, sales trends, and campaign effectiveness, translating business requirements into meaningful visualizations.

• Customer Journey & Campaign Automation: Support the development and optimization of customer journeys using CRM engagement platforms, leveraging customer segmentation and behavioral patterns to improve targeting and campaign effectiveness.

• Data Analysis & Insights: Query and analyze large-scale datasets using SQL to identify trends, anomalies, customer behavior patterns, and business opportunities, providing actionable recommendations to support decision-making.

• Data Quality & Process Improvement: Monitor automated workflows, validate report accuracy, investigate data discrepancies, troubleshoot operational issues, and continuously improve reporting and data processing processes.

• Data Storytelling & Communication: Communicate analytical findings through clear, data-driven narratives, explaining key trends, potential root causes, business implications, and recommended actions.

• Cross-functional Collaboration: Work with internal teams and clients to clarify business requirements, align on reporting logic and metric definitions, and translate business needs into practical data solutions.

Requirements

• Bachelor's degree in Data Analytics, Data Science, Computer Science, Information Systems, or a related field.

• At least 2 years of relevant experience in data analytics, business intelligence, CRM analytics, or data operations, preferably in CRM, e-commerce, retail, or digital marketing environments.

• Strong SQL proficiency, including writing complex queries, joining and transforming large datasets, performing aggregations, and investigating data discrepancies.

• Practical Python experience in data processing, report generation, workflow automation, and API integration.

• Hands-on experience with Power BI or other BI and data visualization tools, including dashboard development, data modeling, and metric definition. Familiarity with DAX is an advantage.

• Strong understanding of data structures, data flows, and the business logic behind metrics, reports, and analytical outputs.

• Strong analytical and problem-solving skills, with the ability to identify meaningful patterns, investigate anomalies, and translate findings into actionable business insights.

• Ability to work independently, manage recurring deliverables, prioritize multiple tasks, and take ownership of assigned workflows with minimal supervision.

• Strong attention to detail and a structured approach to data validation, documentation, troubleshooting, and operational quality control.

• Proficiency in reading and writing in English and Mandarin. Candidates fluent in Cantonese and Mandarin are preferred.

• Experience with cloud platforms, data warehouses, scheduled data pipelines, or API integrations is a plus.
  
  We offer attractive compensation package to suitable candidates. Interested parties, please click "Apply Now" to submit your application including your present & expected salary.
  
  Office Location : KL Eco City

(Personal data collected will be used for recruitment purposes only.)