Junior Data Analyst with IF statements and Pivot table experience to produce data mapping templates, extracting product data from various product information systems- 25780

Our large retail client is looking for a Junior Data Analyst with IF statements and Pivot table experience to produce data mapping templates, extracting product data from various product information systems

Duration: 10 months to start
Location: Mississauga (2 days on site)

Scope: The role is responsible for ensuring back-end product data for the online product catalogue is configured correctly to achieve business users’ desired front-end treatment.

• The Analyst will work heavily in Microsoft Excel to cross reference and compare different data extracts for consistency and commonalities. The role primarily involves producing mapping templates extracting mass amount of product data from various product information systems, converting to a user friendly format (optimize for end user readability and clarity) for analysis (largely in Excel)

Must Haves:

• Excel skills
  • Lookup Functions
  • If Functions
  • Pivot Tables
  • Formatting data
  • IF statements (COUNTIF etc.)
  • Filter formulas

Nice to Have

• PIM (Product information Management) Systems