This website uses cookies to ensure you get the best experience on our website. MORE INFO

Data Management Analyst

  • Hong Kong
  • Marketing and Communications
  • 30 Jun 2019
  • Job reference no. : 2/DMA/5SPL

We are now looking for a talented Data Management Analyst to be part of our dynamic team. The incumbent will support the Head of CRM to develop a centralized data warehouse for customer data management across different portfolios, in both China and HKSAR of the company.  He/ She will be accountable for the ETL programming development, data warehouse maintenance, data attributes readiness for BI analytics, etc.  The Data Management Analyst will work closely with internal IT, business stakeholders and vendors on planning, management, execution & delivery of data management and ultimately the enablement for data-driven business model for the company by developing a single source of truth of customer data across different portfolios.

Key Responsibilities:

  • Design and develop ETL programming for data integration and management in Data Warehouse (SQL based) with data extracted form diversified data source systems
  • Design, develop, test, adapt ETL code & jobs to accommodate changes in source data and new business requirements
  • Ensure data quality throughout entire ETL process, including audits and feedback loops to sources of truth
  • Document all ETL and data warehouse schema, entity relationship diagrams, processes and flows, create and/or update technical documentation
  • Design rules and develop maintenance work flow for data cleansing and validation with Informatica Data Quality engine to conduct data quality assessment
  • Design rules and logics for data de-duplication with Informatica Data Quality engine for effective formation of single view of customer
  • Analyse and implement effective data work flows and data logic to facilitate efficient and accurate cross-platform data exchange and integration
  • Manage vendors to design and build data integration API for automated data exchange and replications to data warehouse
  •  Design and develop necessary logics and/or tools for data privacy compliance

Together with analytical skills, integrity and passion, our ideal staff should be:

  • Degree in Computer Sciences / Information Technology or related discipline
  • At least 3 -5 years in-depth experience in SQL programming
  • Knowledge in data cleansing and data warehouse maintenance
  • Experience in data relationship and data schema design and analysis
  • Proficiency in data integration tools and development of API
  • Hands-on experience in Informatica Data Quality operation and development would be an advantage
  • Knowledge in cloud data platform and data lake applications is a plus

Interested parties are invited to send their applications with a cover letter quoting job reference number, and full resumes stating career history, qualifications, present and expected salary and contact numbers through one of the following means:

 

Postal address:

Human Resources & Administration Department

Swire Properties Limited

64/F, One Island East, Taikoo Place, 18 Westlands Road, Quarry Bay, Hong Kong

Fax number: (852) 2880 8300

Email address: recruit2@swireproperties.com

 

Application deadline is 30 June 2019.  If we have not contacted you within six weeks of the date above, please consider your application be unsuccessful this time.  The personal data of unsuccessful candidates collected for this recruitment exercise will be kept for 12 months from its completion and thereafter destroyed.  Information provided will be used for recruitment and appointment purpose only.  The Company will handle all personal data confidentially in accordance with the principles laid down in the Personal Data (Privacy) Ordinance. 

Apply

or

 

Related Jobs