System Analyst- Product Information Management

Role Summary

You will work in a fast-paced environment on an online platform that serves 500+ web & mobile sites globally. Your role will have you working on all aspects of the digital customer experience with Client's range of brands, from engaging customers via digital marketing channels, searching and browsing for products in the online shop and other sales channels, all the way to the customer receiving their order.

The Product Information, Systems Analyst is responsible for the maintenance of product data analysis, attribute mapping, consolidating and generalization of data structure, and identify the outliers of data attributes of our Product Information Management System (PIM). You will work closely with technical, product management and marketing/merchandizing staff across the company, so strong communication and task coordination skills are essential.

Success criteria

• Experience analyzing large sets of data to glean insights around Product Information and product data structure
• Experience in working with relational databases and normalization of non-relational data
• Ability to validate data integrity, completeness and relevance to the business requirements
• Support technical and architectural changes in transforming Product Information while maintaining the data integrity and hierarchy structure.
• Exhibit curiosity and the desire to learn new tools and technologies; Tech savviness with an initiative to learn new software systems quickly
• Thrive in a fast-past, dynamic environment and prioritize work and time effectively
• Must be able to understand current and future state data models, recommend changes based on the outcome of analysis performed
• Must be able to work independently
• Must have keen eye for details

Key responsibilities

• Perform analysis on existing relational and non-relational structures from various sources and business groups
• Consolidate and Normalize the data and map to the destination data model
• Identify new attributes, build technical requirements while mapping to the business context and usage of the attribute
• Recommend incremental updates to data model accommodating additional data attributes and entities
• Work with technical team implementing changes to data model
• Evaluate the data for integrity and accuracy; feedback and work with business and technical teams to backfill gaps, if any
• Leverage in-depth master data management and PIM knowledge combined with technical data analysis to gain significant insights to maintain and improve the master data.
• Support content syndication to all retail partners & channels ( Brand.com , Retailer.com , TR, 3rd party product feeds)including basic product content, retailer attributes, images, 360 spins, videos and enhanced/A+ content, etc.
• Identify, track and report new data attributes across brands
• Summarize and report the work progress on daily basis

Skills Preferred

• Strong knowledge relational databases like Oracle, MySQL or Microsoft SQL Server
• Experience in working with data interchange formats like JSON and bulk data formats like CSV and Excel.
• Good written and verbal communication skills required
• Experience in business analytics tools like PowerBI is preferred.
• Knowledge of InRiver and/or Adobe Creative Suite is a plus.
• Knowledge in eCommerce testing is added advantage

Skills required (provided by HM):
Data Ingestion
Excel
Data structure
Taxonomy experience nice to have
Ability to multi-task
Excellent communication skills
Experience with Jira/Confluence
Mapping syndication templates
Retailer requirements implementation
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.