Data Analyst

ADM Group
Full Time
Junior (less than 3 years)
Bachelor
English

Job Description

Data Analyst

Location: Hunghom

Reports to: Adm promotions Governance Manager

Department: Adm strategic sourcing

Location: Hong Kong

Responsible for: General provision of data and analysis to support Procurement

1. JOB PURPOSE

  • To initiate and run weekly/monthly reports
  • To maintain and improve the integrity of adm product database
  • To gather, analyse, organise and present data and information in a meaningful way to support better decisions by adm category managers and procurement.
  • To interpret data requests and derive clear specifications for the execution and delivery of outputs.

2. PRINCIPAL ACCOUNTABILITIES

  • Managing and developing SQL Server databases
  • Creating Excel and Access files (Front end for SQL Server)
  • Creating complex reports based on various data sources
  • Maintain integrity and health of data
  • Develop ways to articulate meaningful outputs from complex data streams
  • Identify and highlight insights and trends developed from data
  • Manage timings and set realistic expectations with internal customers for the completion of data analysis activities
  • Maintain data gathered in an accessible and meaningful file structures

3. DIMENSIONS

  • Position reports to Governance Manager

4. INTERNAL AND EXTERNAL RELATIONSHIPS

Key internal stakeholders:

  • Category Managers
  • CSR Manager
  • QA/QC Manager
  • Accounts teams
  • IT team
  • Finance team
  • Suppliers and external providers of information to adm

5. QUALIFICATIONS/EXPERIENCE/SKILLS

Essential

  • Advanced level of skills in using VBA (Excel and Access)
  • Advanced level of skills in using SQL (T-SQL, MS SQL Server: ability to write procedures and manage databases)
  • Able to work code in fast paced and changing environment
  • Good level of skill in using Microsoft Powerpoint
  • Strong analytical capabilities
  • Time management and planning of work/projects
  • High degree of organisational skills and time management

Highly Desirable

  • University degree or equivalent
  • Experience of data analysis, models methodologies and techniques

6. BEHAVIOURS

  • Fast learner
  • Self-motivated
  • Cultural sensitivity
  • Accomplished written, numeric and presentation skills
  • Ability to reconcile, prioritise and effectively manage workload
  • Work effectively, and communicate in a timely manner any time or delivery issues throughout projects

Interested parties should send full resume with expected salary, availability and portfolio to

ADM Promotions Hong Kong Limited 
The Human Resources and Administration Department,
Unit G, 4/F., Kaiser Estate, Phase 2,
No. 51 Man Yue Street, Hung Hom, 
Kowloon, Hong Kong.

OR by email at [email redacted, apply via Jobable]

For more information about us, please visit our website at: www.admgroup.com
All applications will be used for the purpose of recruitment only. Applicants not invited for interview within 4 weeks may consider their applications unsuccessful. We will retain the applications for a maximum period of six months and may refer them to suitable openings within our Group.
 


Professional Qualifications

  • Advanced Level

Technical Skills

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