Data Architect-Investment Data warehouse ( IBOR )
友邦资讯科技（广州）有限公司
- 公司规模：500-1000人
- 公司性质：外资(欧美)
- 公司行业：计算机软件
职位信息
- 发布日期：2020-03-18
- 工作地点：广州
- 工作经验：8-9年经验
- 学历要求：本科
- 语言要求：英语熟练
- 职位月薪：2-3万/月
- 职位类别：大数据开发工程师 数据库工程师(DBA)
职位描述
Position Objective:
? IBOR database ( Eagle PACE, STAR, Datamart, MicroStrategy ) design and governance
? Vendor deliverables quality supervision
? Data asset discovery and access
? Database performance monitoring and tuning
Roles and Responsibilities:
? Database design (50 %)
o Gather and analyze data requirement, propose technical design solution and data model
o Fine-tune current design to improve system performance and remove data redundancy
o Prepare IT documentation
o Review design to ensure it meet AIA business requirement and adhere to AIA IT standard
o Work closely with report development team to advise data usage and trouble shooting
? Data governance (10 %)
o Define and maintain database change control procedure. Maintain related manual and procedures
o Define framework to govern new data point creation on every data base used in IBOR, such as STAR, PACE, OLAP report field
attributes, DataMart, MicroStrategy fields etc.
? Supervise quality of vendor deliverables (10 %)
? Data asset discovery and access (20%)
o Prepare and design data dictionary and database knowledge base to help business users understand data and how to discover available data point in the systems for reporting
o Drive knowledge sharing among AIA IT support team as well as business users to improve knowledge of data point available in IBOR
? Database Performance monitoring and tuning (10%)
o Co-ordinate with vendor to monitor the database performance and gather SLA reports
o Work with vendor to trouble shoot database related issues and
provide recommendation when needed
o Co-ordinate with vendor on database related patches and upgrade
Minimum Job Requirements:
Education
？ University / College graduate in computer science or other relevant discipline
Experience
？ 5-year experience as a data architect
Technical skills
？ Strong SQL skill is a must
？ Oracle
？ Knowledge on ODBC, API
？ Knowledge of OLAP cube or datacube
？ Experience on Knowledge Base software
？ Microsoft Office
？ Experience on Eagle STAR/PACE data base is a plus
？ Experience on MicroStrategy is a plus
？ Experience with TeamTrack is a plus
？ Experience with Service Now is a plus
Soft skills
？ A good team player
？ Result oriented
？ SLA familiarity and performance driven work culture
？ Positive attitude
？ Good communication
？ Good problem solving and analytical skills
？ Basic investment knowledge
Language skills
？ Fluent in spoken and written English is a must
？ Fluent in spoken Cantonese is a plus
？ Fluent in spoken Putonghua is a plus
? IBOR database ( Eagle PACE, STAR, Datamart, MicroStrategy ) design and governance
? Vendor deliverables quality supervision
? Data asset discovery and access
? Database performance monitoring and tuning
Roles and Responsibilities:
? Database design (50 %)
o Gather and analyze data requirement, propose technical design solution and data model
o Fine-tune current design to improve system performance and remove data redundancy
o Prepare IT documentation
o Review design to ensure it meet AIA business requirement and adhere to AIA IT standard
o Work closely with report development team to advise data usage and trouble shooting
? Data governance (10 %)
o Define and maintain database change control procedure. Maintain related manual and procedures
o Define framework to govern new data point creation on every data base used in IBOR, such as STAR, PACE, OLAP report field
attributes, DataMart, MicroStrategy fields etc.
? Supervise quality of vendor deliverables (10 %)
? Data asset discovery and access (20%)
o Prepare and design data dictionary and database knowledge base to help business users understand data and how to discover available data point in the systems for reporting
o Drive knowledge sharing among AIA IT support team as well as business users to improve knowledge of data point available in IBOR
? Database Performance monitoring and tuning (10%)
o Co-ordinate with vendor to monitor the database performance and gather SLA reports
o Work with vendor to trouble shoot database related issues and
provide recommendation when needed
o Co-ordinate with vendor on database related patches and upgrade
Minimum Job Requirements:
Education
？ University / College graduate in computer science or other relevant discipline
Experience
？ 5-year experience as a data architect
Technical skills
？ Strong SQL skill is a must
？ Oracle
？ Knowledge on ODBC, API
？ Knowledge of OLAP cube or datacube
？ Experience on Knowledge Base software
？ Microsoft Office
？ Experience on Eagle STAR/PACE data base is a plus
？ Experience on MicroStrategy is a plus
？ Experience with TeamTrack is a plus
？ Experience with Service Now is a plus
Soft skills
？ A good team player
？ Result oriented
？ SLA familiarity and performance driven work culture
？ Positive attitude
？ Good communication
？ Good problem solving and analytical skills
？ Basic investment knowledge
Language skills
？ Fluent in spoken and written English is a must
？ Fluent in spoken Cantonese is a plus
？ Fluent in spoken Putonghua is a plus
公司介绍
About AIA
AIA Group Limited and its subsidiaries (collectively “AIA” or “the Group”) comprise the largest independent publicly listed pan-Asian life insurance group. It has operations in 16 markets in Asia-Pacific – wholly-owned branches and subsidiaries in Hong Kong, Thailand, Singapore, Malaysia, China, Korea, the Philippines, Australia, Indonesia, Taiwan, Vietnam, New Zealand, Macau, Brunei, a 92 per cent subsidiary in Sri Lanka and a 26 per cent joint-venture in India.
The business that is now AIA was first established in Shanghai over 90 years ago. It is a market leader in the Asia-Pacific region (ex-Japan) based on life insurance premiums and holds leading positions across the majority of its markets. It had total assets of US$134,439 million as of 30 November 2012.
AIA meets the savings and protection needs of individuals by offering a range of products and services including retirement savings plans, life insurance and accident and health insurance. The Group also provides employee benefits, credit life and pension services to corporate clients. Through an extensive network of agents and employees across Asia-Pacific, AIA serves the holders of more than 25 million individual policies and over 13 million participating members of group insurance schemes.
AIA Group Limited is listed on the Main Board of The Stock Exchange of Hong Kong Limited under the stock code “1299” with American Depositary Receipts (Level 1) traded on the over-the-counter market (ticker symbol: “AAGIY”).
友邦保险简介
友邦保险控股有限公司及其附属公司（统称「友邦保险」或「本集团」）是***的泛亚地区独立上市人寿保险集团，在亚太区16个市场营运，包括在中国香港、泰国、新加坡、马来西亚、中国大陆、韩国、菲律宾、澳大利亚、印度尼西亚、中国台湾、越南、新西兰、中国澳门和文莱拥有全资的分公司及附属公司、斯里兰卡附属公司的92%权益，以及印度合资公司的26%权益。
友邦保险今日的业务成就可追溯逾90年前于上海的发源地。按寿险保费计算，集团在亚太地区（日本除外）领先同业，并于大部分市场稳占领导地位。截至2012年11月30日，集团总资产值为1,344.39亿美元。
友邦保险提供一系列的产品及服务，涵盖退休储蓄计划、寿险和意外及医疗保险，以满足个人客户在储蓄及保障方面的需要。此外，集团亦为企业客户提供雇员福利、信贷保险和退休保障服务。集团透过遍布亚太区的庞大专属营销员及员工网络，为超过2,500万份个人保单的持有人及逾1,300万名团体保险计划的参与成员提供服务。
友邦保险控股有限公司于香港联合交易所有限公司主板上市（股份代号为「1299」）；其美国预托证券（一级）于场外交易市场进行买卖（交易编号为「AAGIY」）。
AIA Group Limited and its subsidiaries (collectively “AIA” or “the Group”) comprise the largest independent publicly listed pan-Asian life insurance group. It has operations in 16 markets in Asia-Pacific – wholly-owned branches and subsidiaries in Hong Kong, Thailand, Singapore, Malaysia, China, Korea, the Philippines, Australia, Indonesia, Taiwan, Vietnam, New Zealand, Macau, Brunei, a 92 per cent subsidiary in Sri Lanka and a 26 per cent joint-venture in India.
The business that is now AIA was first established in Shanghai over 90 years ago. It is a market leader in the Asia-Pacific region (ex-Japan) based on life insurance premiums and holds leading positions across the majority of its markets. It had total assets of US$134,439 million as of 30 November 2012.
AIA meets the savings and protection needs of individuals by offering a range of products and services including retirement savings plans, life insurance and accident and health insurance. The Group also provides employee benefits, credit life and pension services to corporate clients. Through an extensive network of agents and employees across Asia-Pacific, AIA serves the holders of more than 25 million individual policies and over 13 million participating members of group insurance schemes.
AIA Group Limited is listed on the Main Board of The Stock Exchange of Hong Kong Limited under the stock code “1299” with American Depositary Receipts (Level 1) traded on the over-the-counter market (ticker symbol: “AAGIY”).
友邦保险简介
友邦保险控股有限公司及其附属公司（统称「友邦保险」或「本集团」）是***的泛亚地区独立上市人寿保险集团，在亚太区16个市场营运，包括在中国香港、泰国、新加坡、马来西亚、中国大陆、韩国、菲律宾、澳大利亚、印度尼西亚、中国台湾、越南、新西兰、中国澳门和文莱拥有全资的分公司及附属公司、斯里兰卡附属公司的92%权益，以及印度合资公司的26%权益。
友邦保险今日的业务成就可追溯逾90年前于上海的发源地。按寿险保费计算，集团在亚太地区（日本除外）领先同业，并于大部分市场稳占领导地位。截至2012年11月30日，集团总资产值为1,344.39亿美元。
友邦保险提供一系列的产品及服务，涵盖退休储蓄计划、寿险和意外及医疗保险，以满足个人客户在储蓄及保障方面的需要。此外，集团亦为企业客户提供雇员福利、信贷保险和退休保障服务。集团透过遍布亚太区的庞大专属营销员及员工网络，为超过2,500万份个人保单的持有人及逾1,300万名团体保险计划的参与成员提供服务。
友邦保险控股有限公司于香港联合交易所有限公司主板上市（股份代号为「1299」）；其美国预托证券（一级）于场外交易市场进行买卖（交易编号为「AAGIY」）。
联系方式
- 公司地址：广州市东风东路767号东宝大厦24楼 (邮编：510600)