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.
Things to know before you apply
- Work authorization: Cognizant will only consider applicants for this position who are legally authorized to work in Canada without requiring employer sponsorship, now or at any time in the future.
- Accommodations: If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
- AI in hiring: We use artificial intelligence (AI) tools to help us screen and assess applications more efficiently. Our team performs additional human review and ultimately decides who moves forward in our hiring process.
- Open position: Unless otherwise stated, this job posting is for an open position on our team.
- Language proficiency: We ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you’ll deliver services to and collaborate with stakeholders outside the province who may not speak French.
- Inclusion: 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, provincial or local laws.
