🎁 Before you apply, rehearse this interview. Create your free WorkMundi account and get an Interview Training on HelpsYouSpeak — no cost, no card. I want my training →
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 #LI-AL1