Hong Kong Express Airways

Analyst (Officer), Data Warehouse

Hong Kong Express Airways
Full Time
Junior (less than 3 years)
English, Cantonese

Job Description

Analyst (Officer), Data Warehouse

Location: Hong Kong

Role and Responsibilities:

  • Develop plans to gather all business requirements for enterprise and translate into technical specifications;
  • Design and execute an innovative reporting system for processes;
  • Monitor efficient transition of business requirements to technical specifications;
  • Coordinate with various work groups and design improvements to various enterprise management plans and prepare reports for same;
  • Analyze system requirements and gather all business information for same;
  • Prepare all training and administration documents;
  • Assist departments to prepare data mining processes and develop designs for metadata;
  • Monitor compatibility of all data delivery tools and warehouse and ensure effective resolution for same;
  • Evaluate all training programs for end users and provide support for same;
  • Design and implement various reports and prepare dashboards;
  • Administer backup recovery processes for all SQL Server;
  • Install all SQL Server and perform upgrades;
  • Provide technical support in database implementation and deployment;
  • Analyze and recommend improvements to processes;
  • Participate in various project meetings and prepare applications for database;
  • Assign in ad-hoc duties assigned.


  • Degree holder or above;
  • Written and verbal communication, including technical writing skills;
  • A methodical and structured approach to problem solving;
  • Good interpersonal and communication skills in both spoken and written English and Chinese;
  • Aviation experience is a plus.

Desirable Qualities:

  • Certified Business Intelligence Professional credentials;
  • Highly motivated by success but a team player;
  • Self-starter with multi-tasking capability and able to meet tight deadline;
  • Energetic and seeking a career building position.

Technical Skills

  • Data Mining
  • Microsoft SQL Server
  • SQL
  • Technical Support
  • Training
  • Translation