Product Information Analyst - PIM

Our client, is seeking an analytical, detail-oriented Product Information Analyst (PIM / L1 Technical Support) to serve as a Subject Matter Expert (SME) for their Next-Gen Product Information Management (PIM) platform implementation.

In this critical technical support and data analysis role, you will act as the primary guardian of the digital product catalog, bridging the gap between back-end system configurations and front-end customer experiences. You will provide Tier-1 technical support for internal business associates, triaging tickets, troubleshooting data visibility issues, and executing root-cause diagnostics. Leveraging advanced Excel formulas and SQL database querying, you will analyze ticket trends, perform User Acceptance Testing (UAT) for system enhancements, and train internal teams to ensure catalog data accuracy, scalability, and integrity across a massive digital retail ecosystem.

Duration: 6-Month Contract (with high potential for extension)

Advantages
Enterprise Retail Scope: Impact the digital product catalog and search experience for millions of online e-commerce customers.

Next-Gen Platform Modernization: Serve as a core technical SME during a high-visibility, next-generation PIM system rollout.

Data-Driven Problem Solving: Move beyond basic ticket management by conducting periodic data analysis and identifying systemic process improvements.

High-Velocity E-Commerce Exposure: Gain valuable experience managing cross-functional workstreams spanning UAT, technical support, and user enablement.

Responsibilities
Tier-1 Technical Support & Triage: Act as the first point of contact for internal business associates, diagnosing root causes, replicating technical issues, and resolving product data visibility gaps.

L2 Collaboration & Escalation: Partner closely with Level-2 engineering teams to escalate complex technical bugs, prioritize system fixes, and track resolution lifecycles.

Data Querying & Analysis: Write SQL queries to extract, validate, and audit product data directly from back-end databases, using advanced Excel functions to organize and analyze system metrics.

UAT & Quality Governance: Participate actively in User Acceptance Testing (UAT) for new platform features and enhancements, ensuring system updates solve core business user pain points.

Process Improvement & Reporting: Compile support metrics to identify recurring data issues, presenting proactive action plans to streamline ongoing catalog management.

User Training & Empowerment: Lead 1:1 coaching and group workshops to educate internal associates on item setup best practices and data quality standards.

Qualifications
Advanced Excel Proficiency: 2+ years of hands-on mastery in Microsoft Excel, including VLOOKUPs, Macros, complex IF statements, Pivot Tables, and data hygiene.

SQL Querying Skills: 1 to 3 years of practical experience writing SQL queries to extract, filter, and validate relational database records.

PIM & Catalog Knowledge: Demonstrated experience working with Product Information Management (PIM) platforms or large-scale retail/e-commerce catalog data structures.

UAT & Testing Experience: Practical background conducting User Acceptance Testing (UAT) and providing feedback on system configurations.

Troubleshooting & Analytical Thinking: Proven capability to dissect technical workflows, trace data inputs, and identify root causes behind system discrepancies.

Communication & Support: Strong interpersonal skills with the ability to translate technical concepts into clear instructions for non-technical business users.

Preferred Assets & Nice-to-Haves
Experience using enterprise service desk and workflow tools such as ServiceNow or JIRA.

Background in large-scale omnichannel retail, e-commerce merchandising, or supply chain data operations.

Summary
If you are a tech-savvy Product Information Analyst who pairs strong logical troubleshooting skills with advanced Excel, SQL database querying, and PIM system experience, this 6-month contract opportunity is an ideal next step. Bring your data precision, analytical mindset, and support expertise to our client's e-commerce technology team today!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [email protected] to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies.