Back to jobs

Regional Data Analyst - SQL/ETL - Contract

Job description

Regional Data Analyst - SQL/ETL - 12-month contract

Key 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
Work Experience
  • At least 2 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
  • Fluency in English

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