Job description:

• Extract and transform customer and transaction data in preparation for campaigns implementations from start to end of analysis in a timely and accurate.
• Utilize analytical tools (SQL, MS Excel, MS Access) to perform basic data manipulation and analysis

1. To conduct routine reporting : By campaign / Weekly / Monthly / Quarterly / Yearly
2. To create targeted customer lists for marketing campaigns, promotions, or activities, which increase customer relevance and get most effectiveness of variable marketing budget spending.

• Develop campaigns forecasts for individual campaigns to estimate campaign performance and analysis and develop campaign reporting and translate to actionable insights.
• Able to conduct other ad hoc campaigns requests, analysis and tests as required for CRM or marketing department
• Work cross-functionally with other teams and departments to understand requirement and gather insights which will improve targeting efforts and generate buy-in for targeting decisionsใ
• Manage customer’s campaigns feedback in order to increase customer satisfaction.

Qualification:

• Bachelor's Degree - Business, statistics, engineering, economics, or math major
• 3 years of experience in CRM data analyst or loyalty card management
• Fair English skills: Writing / Reading / Speaking
• Computer skills: MS Access / MS Excel / MS PowerPoint / SQL / others (FB / LINE / mobile app)
• Have good service mind and customer competency