Product Data Analyst

Loloi Rugs is a leading textile brand that designs and crafts rugs, pillows, and throws for the thoughtfully layered home. Family-owned and led since 2004, Loloi is growing more quickly than ever. To date, we’ve expanded our diverse team to hundreds of employees, invested in multiple distribution facilities, introduced thousands of products, and earned the respect and business of retailers and designers worldwide.

A testament to our products and our team, Loloi has earned the ARTS Award for “Best Rug Manufacturer” in 2010, 2011, 2015, 2016, 2018, 2023, and 2025.

Security Advisory: Beware of FraudsProtect yourself from potential fraud and verify the authenticity of any job offer you receive from Loloi. Rest assured that we never request payment or demand any sensitive personal information, such as bank details or social security numbers, at any stage of the recruiting process.

To ensure genuine communication, our recruiters will solely reach out to applicants using an @loloirugs.com email address. Your security is of paramount importance to us at Loloi, and we are committed to maintaining a safe and trustworthy hiring experience for all candidates.

We are building a Business Operations Center of Excellence, and we need a Jr. Product Data Analyst to serve as the "Guardian of the Golden Record." In this role, you are the absolute owner of product data integrity as it relates to the digital customer experience. You ensure that every item we sell is accurately represented across every touchpoint—from our ERP and PIM to our website storefront and marketing feeds.

This is not a data entry role; it is a high-impact technical logic and investigation role. You will work directly with our Data Platform and Software Engineering teams to define business rules, audit data health via complex SQL, and troubleshoot data transmission errors before they impact the customer.

Responsibilities

• Storefront Governance: Serve as the absolute owner of product data integrity within the PIM. Ensure that all storefront-critical attributes (pricing, dimensions, weights, image links) are accurate and standardized for a seamless customer experience.
• Technical Data Auditing: Write and run complex SQL queries against our centralized database to identify anomalies, "orphan" records, and data hygiene issues that need resolution.
• You will be expected to query across multiple schemas to validate data consistency between systems.
• Feed Logic & Mapping: You will manage the logic of how data translates from our PIM to external endpoints.
• You will ensure that our products appear correctly on Google Shopping, Meta, Amazon, and other marketplaces by managing feed rules and mapping definitions.API Payload Analysis: You will act as the first line of defense for data transmission errors.
• If a product isn't showing up on the site, you will review the JSON/XML response bodies to determine if it is a data payload error or a software code bug.
• Cross-Functional Impact Analysis: You will act as the gatekeeper for data changes, predicting downstream impacts (e.g., "If Merchandising changes this Category Name, it will break the Finance reporting filter").
• Hygiene Logic Definition: You will partner with our IT/Database team to define automated health checks.
• You identify the "rot" (bad data patterns), and they implement the database constraints to stop it.
• What You Will NOT Do (The Boundaries)
• No Web Development: You are not a Front-End Developer.
• You do not write HTML, CSS, or React code.
• You ensure the data powering those components is 100% accurate.
• No Manual Data Entry: Your job is not to copy-paste descriptions.
• You build the systems, bulk processes, and logic that ensure data quality at scale.
• No Database Administration: You do not manage server uptime or schema changes (IT owns this). You own the quality of the records inside the database.
• Intersection with Technical Teams
• With IT (Database Mgmt): IT owns the infrastructure and schema; you own the quality of the data within it. When you identify a systemic issue (e.g., "5,000 orphan records"), you partner with IT to implement the technical fix (scripts/constraints).
• With Software Engineering (Commerce): If a product is missing from the site, you check the data payload.
• If the data is correct, you hand off to Engineering, confirming it is a code/caching bug rather than a data error.
• Experience, Skills, & Ability

Requirements

• 1-3+ years of experience in Data Management, PIM Administration, or technical eCommerce Operations.SQL Proficiency: You are comfortable writing queries beyond simple SELECT *. You should be proficient with CTEs (Common Table Expressions), Window Functions (e.g., Rank, Lead/Lag), Subqueries, and complex Joins to act as a forensic data investigator.API Fluency: You can read and understand JSON and XML. You know what a valid payload looks like and can spot formatting errors or missing keys.

Data Manipulation: You are an expert at handling large datasets (CSVs, Excel) and understand data types, formatting standards, and normalization concepts.

You love hunting down the root cause of an error. You don't just fix the wrong price; you find out why the price was wrong and build a rule to stop it from happening again.

You have high standards for accuracy. You understand that a wrong weight in the system means a financial loss on shipping for the business.

Bonus Points (Nice-to-Haves)Familiarity with Visio/Lucidchart to visualize data flows.

Ability to build simple dashboards in Tableau to track data health scores.

Basic familiarity with Python or R for data manipulation.

What We Offer

• Health, dental, and vision benefits
• Paid parental leave401(k) with employer match
• A culture of meritocracy that fosters ongoing growth opportunities
• A stable, growing family-owned company that looks after its employees
• Loloi Rugs does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits.
• We seek a diverse pool of applicants and consider all qualified candidates regardless of race, ancestry, color, gender identity or expression, sexual orientation, religion, national origin, citizenship, disability, Veteran status, marital status, or any other protected status.
• If you have a special need or disability that requires accommodation, please let us know.