Description

Responsibilities

• Perform data extraction & data analysis from CRM systems for support investigation & projects

• Using ETL tool, facilitate data extraction, transform, load, verification in data migration projects in both production & testing environment

• Help support vendor to investigate data quality problems, arrange patching & formulate data related SOPs (unmerge, deactivate, reactivate) in Global CRM, APAC CRM, & local touchpoints

• Build daily data monitoring & reconciliation reports between middleware, source systems and destination systems to find data loss & data issues

• Build monitoring reports for business to show data quality in CRM such as registration speed report, merge reports, active customer report...

• Work with project & support team to enable daily schedulers to synchronize data between systems such as CASS, product, staff & customer data for BI reporting

Qualifications and Skills

Academic / Professional Qualifications

• Undergraduate in Engineering, Computer Science, Information Technology or related technical field

• Certification in Salesforce.com or marketing cloud is a bonus

Work Experience

• At least 3 years work experience as data analyst with strong SQL & ETL experience

• Solid experience in working with CRM systems preferably with Salesforce.com or Reltio

• Experience working in the retail industry is preferable

Functional/Technical Expertise

• Knowledge of SQL, experience with DB like Oracle, SQL server, and proficiency with ETL is a must

• Experience with Alteryx, or other ETL tool is an advantage

• Experience in supporting or working with data in the following systems will be preferred: SFDC, SFMC, Heroku, Logic Apps, Biztalk, Reltio, Hybris & Power BI

• Understanding on Python, SQL, SOQL to write scripts or schedulers will be needed

Required Competencies

• Solid understanding of databases and system data models

• Ability to communicate in fluent English. Chinese, Korean, French is a bonus.

• Solid experience with data visualization and ETL tools, strong analytical ability, good judgment, and good business/domain knowledge

• Strong team player who proactively collaborate with team members