Title: Catalog Data Specialist (Excel / Python / SQL)
Company Name: InfoLoom Systems LLC
Vacancy: 2
Age: Na
Job Location: Dhaka (Vatara)
Salary: Tk. 20000 - 35000 (Monthly)
Experience:
Experience Requirements:
Skills & Competencies (must-have):
Job Context
Infoloom Systems LLC is a U.S.-based software/IT service provider serving furniture retailers across the USA. We are building a multi-tenant SaaS platform and supporting applications to replace our existing system (catalog management, e-commerce integrations, retailer services). We’re setting up a full-time on-site team in Vatara, Dhaka and seeking a detail-oriented Catalog Data Specialist to help structure and scale large product catalogs.
Job Responsibilities:
Lead large-scale data cleansing & processing in Excel (Power Query, XLOOKUP/INDEX-MATCH, TEXTSPLIT/TEXTJOIN, FILTER, array formulas, data validation) to standardize vendor files into import-ready templates.
Ingest, normalize, and enrich product data from diverse sources (web pages, PDFs/spec sheets, vendor CSV/XLSX); standardize units, dimensions, materials, and key attributes.
Map products to taxonomy (categories → subcategories → attributes); maintain attribute dictionaries; resolve duplicates/SKU conflicts and handle variant groupings.
Build dependable Excel workflows with robust checks/error logs to generate importer-ready files.
Write lightweight Python utilities (pandas; requests/BeautifulSoup/Playwright) to automate extraction, parsing, and transformation.
Use SQL for QA: joins/lookups, de-duplication, referential-integrity checks, and pre-import audit reports.
Prepare and maintain image/link inventories; verify URLs, file sizes, aspect ratios, naming conventions, and broken links.
Collaborate with engineering to improve ETL/import pipelines; document SOPs/checklists and continuously harden data quality gates.
Support multi-tenant SaaS needs (tenant-aware exports/imports, roles/permissions/plan constraints, audit trails and change logs).