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
About Cognizant:
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, bridging the gap between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, drive tangible outcomes and keep global enterprises ahead in a fast-changing world. See how at cognizant.ai or @cognizant.
Additional employment information
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws.
