We are looking for an Analyst, Product Information Management – Co-op Student to join our PC Express Digital Merchandising Team, which is responsible for the online store experience. Specifically, the Product Information Management team ensures online information for all types of products we sell is accurate, complete and relevant to help customers make a purchase decision. This includes product names, descriptions, nutritional facts, and dozens of other customer-facing and backend attributes. 

In this role the Analyst, Product Information Management – Co-op Student will support analytical projects and initiatives with the goal of increasing efficiencies, reducing errors, and ensuring optimal product information on site. 

The successful candidate will use analytical tools and approaches to extract, manipulate, cleanse, and standardize product information data; create insights, reporting for internal/external stakeholders. 

What you'll do: 

• Analyze a broad range of data sources to generate insights about product enrichment, product availability, and sale offers. 

• Build processes to extract, transform, cleanse, standardize and consolidate product data 

• Prepare reports, and presentations on the performance of the PC Express product catalog with a focus on progress against objectives and key results (OKRs) 

• Work with cross-functional teams to align with business requirements and opportunities 

What you’ll need: 

• Strong proficiency in SQL (e.g. aggregate functions, window functions, different join types) and MS Excel or Google Sheets (e.g. pivot tables, VLOOKUP formulas) 

• Strong analytical skills with attention to detail and the capability to present analysis and 

opportunities to stakeholders 

• Strong written and verbal communication skills