You may also like

Business Analyst – CRM (REF:CT-IT-BA)

I.T Apparels
  • Analytics
  • Change Management
  • +13 skills
  • +14 skills

Senior Officer / Assistant Manager – Agency Project

China Life Insurance
  • Budgets
  • Business Analytics
  • +5 skills
  • +6 skills

Senior Officer / Assistant Manager – Agency Project

China Life Insurance
  • Budgets
  • Business Analytics
  • +5 skills
  • +6 skills

Business Improvement Leader

Hong Kong Aircraft Engineering (HAECO)
  • Microsoft Excel
  • Microsoft Powerpoint
  • +5 skills
  • +6 skills

Business Analyst

Chong Hing Bank
  • Compliance
  • Data Analysis
  • +6 skills
  • +7 skills

Data Architect

Full-time
Intermediate (3-6 years)

Posted 

Technical Skills

  • Business Analytics
  • Cognos
  • Data Management
  • Data Mining
  • Data Warehousing
  • Database Administration
  • Futures
  • Microsoft Excel
  • Microsoft SQL Server
  • SAS (Statistical Software)

Job Description

Data Architect

Location: North Point

As the leading financial advisory firm in Hong Kong, Convoy upholds its core values of Passion, Integrity and Professionalism in providing the best advices and service to help customers investing in their future.

Due to our business expansion, we are looking for high calibre candidates to share our vision and venture our success.

Responsibilities:

  • Design & develop database solutions to store and retrieve company information
  • Design conceptual and logical data models and flowcharts
  • Design & develop Extract, Transform & Load process
  • Analyze structural requirements for new software and applications
  • Work with business users and data analysts to build analysis solutions
  • Communicate with developers and analysts to build business analysis reports and dashboards
  • Prepare and maintain data dictionary
  • Install and configure data warehouse & analysis service features to ensure functionality
  • Improve system performance by conducting tests, troubleshooting and integrating new elements
  • Systems, Storage, Usage, connectivity review, monitoring and support
  • Responsible for database administrator role such as define security and backup procedures
  • Coordinate with the data analyst to identify future needs and requirements
  • Provide operational support
  • Migrate data from legacy systems to new solutions

Requirements:

  • Degree holder in Computer Science/Information Technology or related disciplines, candidaqte with MSc in computer science preferred
  • 3 - 5 years working experience in experience as a Data Architect, Database Developer, DBA or similar role
  • Proven work experience as a Data Architect, Data Analyst, DBA or similar role
  • In-depth understanding of database structure principles
  • In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
  • Proven analytical skills and problem-solving attitude with strong logical reasoning
  • Experience gathering and analyzing system requirements
  • Knowledge of data mining and segmentation techniques
  • Expertise in MSSQL, Stored Procedure, SSIS, SSAS, MDX
  • Proficiency in MS Excel, PowerPivot, DAX
  • Familiarity with data visualization tools (e.g. PowerBI, Tableau, SAS, Cognos and R)
  • Experience in Azure Data Warehouse is an advantage
  • Knowledge in insurance and financial products an advantage
  • Excellent verbal and written communication skills and good interpersonal skills
  • Good command of both spoken and written English and Chinese
  • Experience team leader, self-motivated, quality and detail oriented

We offer competitive remuneration including career prospects to the right candidate. Interested parties please send detailed resume with availability, current and expected salaries to Human Resources Department, Convoy Global Holdings Limited, 39/F @CONVOY, 169 Electric Road, North Point, Hong Kong or by clicking Apply Now and upload your CV and cover letter.

(All applications will be treated in strict confidence and used for recruitment purpose within Convoy Global Holdings Limited only)

Employment TypeFull-time
Career LevelIntermediate (3-6 years)
Education LevelBachelor
LanguageEnglish, Cantonese