Staff Data Engineer, Merchandising Catalog & Taxonomy (IC)

About The Role Attachments King is an eCommerce startup in the Heavy Equipment Industry developing proprietary software that flexibly discovers compatibility between equipment and host machine components. Were hiring a Staff Data Engineer in an Individual Contributor role (no direct reports) to build and operate the

single source of truth

for a high?SKU construction equipment catalog: taxonomy, product ingestion, price/availability pipelines from messy non?API sources, and the automation layer that scales SKU count, price discovery, and data quality with for a small team with lean headcount. This role is based in San Francisco, CA. This will be an in-office role and will extend past the standard 40 hours / week of many 9-5 jobs. We have long hours, weekend work sessions, and prioritize a results-driven culture. Salary, Equity, and Benefits Base Pay:

$245,000

/ year Equity Offered:

2.00%

(Options, 1yr Cliff, 4yr vest) No Funding Raised, Most Recent 409A FMV is $10M. Total Compensation:

$295,000

/ year TC excludes potential refreshes; equity valued at 409A on grant date, amortized over 4 years Employer-provided Health Insurance Employer-provided 401k Plan Day?to?day scope Taxonomy & PIM modeling:

Own category trees, attributes, variants, compatibility metadata, and normalization rules (GS1/UNSPSC awareness; custom facets for consumer browse paths). Data ingestion (messy source formats):

Build resilient pipelines for CSV/Excel, email attachments, SFTP, scraped HTML, PDFs, and images. Transform & validate:

Typed, idempotent ETL/ELT with schema evolution and contract-based QA. Pricing & availability:

Schedulers/agents to detect deltas, reconcile conflicts, discover competing listings, and publish to Shopify with guardrails for margin protection. Images:

Automation for background removal, resizing, deduping, and attribute extraction (e.g., dimensions, metadata). Analytics:

Build merchandising dashboards (assortment growth, price competitiveness, availability, metadata quality). Operations & SRE:

Observability, alerting, backfills, SLAs/SLOs, rollback strategies, and cost control. Current Platforms AWS (native-first):

S3, DynamoDB, Neptune, Lambda, Step Functions, ECS/Fargate, EventBridge, SQS/SNS, CloudWatch, SSM Parameter Store. IaC:

AWS CDK v2 (Python / TypeScript) ECommerce Platform:

Shopify Plus Analytics : Power BI / Microsoft Fabric AI Tooling: Cursor, Devin, Graphite, Personal ChatGPT Pro / Claude Max plans Requests for, and use of, additional AI tools is heavily encouraged Core outcomes 30 days: Ship a production

ingestion ? normalization ? enrichment ? publish

pipeline for all existing SKUs (2,200); stand up initial

PIM

data model with faceted attributes optimized for search/browse; wire

price & availability watchers

for all current vendors (files, web pages, emails, competitor websites). Baseline data quality with automated

contracts & tests ; initial

operational dashboards

(latency, freshness, fill rates, failure rates). 90 days: SKU count increased by 500% (11,000), coverage expanded to support top 100 product families and machine categories rank-ordered by search traffic demand; image set completeness >

95%

for top movers; pricing latency

15 minutes

for tracked vendors; vendor onboarding time

48 hours

from first file to live SKUs. AI/agent workflows auto?extract attributes from PDFs/images; continuous taxonomy evolution with zero-downtime migrations. 365 days: Deliver $9.27M in annual revenue, 100% attributable to zero-touch online orders of managed SKUs. Must?have requirements 7+ years

building production data systems (or commensurate impact): Python (pandas/polars), SQL (Postgres/Redshift/Snowflake/BigQuery),

orchestration

(Step Functions/Airflow/Prefect), eventing (SQS/Kafka), object storage (S3), CI/CD, containerization. Ecommerce catalog expertise:

PIM concepts (attribute schemas, variants/SKU creation, canonicalization, dedup), Shopify Admin/GraphQL, metafields, collections, feed health. Non?API data wrangling at scale:

Selenium/Playwright for scraping (with robots/legal etiquette, rotation, backoff), email/SFTP ingestion, PDF OCR, document parsing. Data quality & contracts:

Great Expectations, Pydantic (typed models), versioned schemas, migration plans, data diffing, idempotency as a base case. Image processing:

PIL/Pillow, OpenCV, ImageMagick; batch pipelines and basic color/contrast/compositing. Analytics:

Power BI and/or Tableau; metric design for merchandising (coverage, freshness, price index, conversion lift). AI/agentic workflows:

Retrieval + tool?use agents to extract attributes, reconcile conflicts, propose taxonomy changes; prompt chaining; evaluation harnesses; safe?ops patterns for deterministic fallbacks. Search relevance & indexing: Search relevance for catalogs (Meilisearch/Elastic/OpenSearch) and faceted navigation tuning. AWS:

S3, Lambda, Glue/Athena, Step Functions, ECS/Fargate, CloudWatch; IaC via the CDK; strong cost/performance instincts. Nice?to?haves Experience with homegrown PIMs Vendor EDI familiarity; GS1 barcoding; UNSPSC mapping. You Might Thrive Here If... You are incredibly ambitious You are a self-starter and intensely curious You are hard-working and relentless, frequently going above and beyond in previous or current roles You are driven by achievement and energized by big, industry-disrupting challenges You want a "hardcore" work environment You want to leave a positive impact on the world About Attachments King Attachments King is E-Commerce for Heavy Machinery Attachments. We're pushing the boundaries of the construction industry with innovative proprietary technology that drastically improves the customer experience when purchasing heavy equipment. We firmly prioritize a hard-working, results-driven culture. Our bar for talent is high, and we do not discriminate on the basis of race, religion, national origin, gender, sexual orientation, age, veteran status, disability or any other legally protected status. If you are remarkably good at what you do, you belong on our team. For US Based Candidates: Pursuant to the San Francisco Fair Chance Ordinance, we will consider qualified applicants with arrest and conviction records. This is the most important time to be alive in human history. Join us, and be a part of something incredible.