Database Marketing Analyst (96334)

Full-time

Posted 

Technical Skills

  • Analytics
  • Campaign Tracking
  • Data Analysis
  • Data Mining
  • Marketing
  • Marketing Campaigns
  • Microsoft Excel
  • Microsoft Powerpoint
  • Microsoft Word
  • SAS (Statistical Software)
  • SQL
  • Translation

Job Description

Database Marketing Analyst (96334)

Shangri-La International Hotel Management Ltd.

ARE YOU HAPPY WITH OK?

OR PERFECTION?

It takes a special kind of person to work at Shangri-La:

someone with an eye for details and the skills to perform;

someone with an attitude to deliver and a passion to delight.

Are you Shangri-La? 

PURPOSE 

The Database Marketing Analyst’s key responsibilities will be assisting in the execution of database marketing campaigns, day-to-day customer data queries / extractions, statistical modeling. He/she will assist with data mining and segmentation through in-depth data analysis to acquire new customers and drive repeat customers.

DUTIES & RESPONSIBILITIES

Reports

  • To identify, collect, manipulate and analyse data in complex data sets
  • To prepare reports in either table or in the form of visualisations such as graphs, charts and dashboards, highlighting the significant results
  • Deliver BAU reports within requested timeline consistently

Campaign Tracking & Analysis

  • Anaylse customer base and identify revenue generating opportunities
  • Perform extracting, importing, and exporting of data in various database applications
  • Understand the data flow of processes, technology and system, to collect data properly for campaign tracking and data analysis and generate meaningful insights
  • Perform data mining and assist with segmentation recommendation in order to optimize marketing effort
  • Track and analyse campaigns’ results and identify opportunities
  • Develop reporting and metrics to understand overall customer retention/repeat behavior across key segments
  • To present data in charts, graphs, or tables of statistical results in a meaningful way

Generate Campaign List

  • To prepare outbound marketing campaign list and upload to vendor via ftp or other requested channels
  • To perform standard data deduplication and data cleansing
  • To validate data after the list is extracted

Others

  • To provide support to other team members on data request
  • Perform other related duties as assigned by supervisor

 POSITION QUALIFICATIONS

  • Has solid experience in writing SQL commands in either Oracle or Microsoft database
  • Ability to write queries/programmes is an advantage
  • Experience with SAS Campaign, Visual Analytics, Enterprise Guide and Miner is a plus
  • Ability to translate general inquiries into specific analysis questions and tasks
  • Good time management, attention to details and strong organisational skills
  • Ability to multi-task to meet tight timelines
  • Experience with MS Office, Word, Excel, PowerPoint with strong excel and data mining skills
  • Team player
Employment TypeFull-time
Education LevelNon-specified
LanguageEnglish
Shangri-La HotelsHospitality, Food and Beverage

Supreme Ct Rd, Central

directions_walk12 mins walk from Admiralty Station