Eternity Consultants

Data Analyst- Using SQL/VBA

Eternity Consultants
Full Time
Intermediate (3-6 years)
Non-specified
English

Job Description

Data Analyst- Using SQL/VBA

Location: Hong Kong

l          4 – 6 years in Data analyst in Trading or buying office

l          To initiate and run weekly/monthly reports

l          To maintain and improve the integrity of product database

l          To gather, analyse, organise and present data and information in a meaningful way to support better decisions by merchandising managers and procurement.

l          To interpret data requests and derive clear specifications for the execution and delivery of outputs.

l          Managing and developing SQL Server databases

l          Creating Excel and Access files (Front end for SQL Server)

l          Creating complex reports based on various data sources

l          Maintain integrity and health of data

l          Develop ways to articulate meaningful outputs from complex data streams

l          Identify and highlight insights and trends developed from data

l          Manage timings and set realistic expectations with internal customers for the completion of data analysis activities

l          Maintain data gathered in an accessible and meaningful file structures

l          Advanced level of skills in using VBA (Excel and Access)

l          Advanced level of skills in using SQL (T-SQL, MS SQL Server: ability to write procedures and manage databases)

l          Able to work code in fast paced and changing environment

l          Good level of skill in using Microsoft Powerpoint

l          Strong analytical capabilities

l          Time management and planning of work/projects

l          High degree of organisational skills and time management


Technical Skills

  • Microsoft Access
  • Microsoft Excel
  • Microsoft Powerpoint
  • Microsoft SQL Server
  • SQL
  • Visual Basic for Applications (VBA)