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
- To conduct routine reporting : By campaign / Weekly / Monthly / Quarterly / Yearly
- 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 in Business, Statistics, Engineering, Economics, or Math major
- 5-8 years of experience in CRM data analyst or Loyalty card management
- Good 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