PIM Engineering Lead

Lakefusion; United States; Remote; USD 150,000 - 210,000; Full time

Benefits offered by this job

Fully remote (USA)

Job summary

Lakefusion is seeking a senior technical leader to drive the implementation of a PIM product atop an MDM platform. The role blends hands-on coding with architecture design, mentoring a distributed team, and guiding data modeling for taxonomy-driven attributes.

You will design schemas, build backend services in Python, and collaborate with an offshore team in India, delivering a scalable catalog system with complex hierarchies and provenance tracking.

Qualifications

• 8+ years of software or data engineering with hands-on leadership.
• Deep data modeling for complex relational, hierarchical, and EAV-style structures.
• Experience managing large taxonomies, ontologies, or graph-backed data in production.
• Strong Python backend development experience with SQLAlchemy or similar ORM.
• Production SQL expertise with indexing, optimization, and transactional patterns.
• Familiarity with Databricks or Apache Spark and lakehouse integrations.

Responsibilities

• Own end-to-end technical architecture for the PIM product within the MDM core.
• Write production code daily for backend services and data pipelines.
• Set technical direction, review designs, and unblock engineers.
• Design data structures for large, nested taxonomies and governance systems.
• Mentor engineers, including offshore team members in India.
• Collaborate with product management to scope features for enterprise catalogs.

Skills

Python

SQL

Data modeling

Graph data structures

Leadership

Mentoring

Architecture design

Tools

Databricks

Apache Spark

SQLAlchemy

FastAPI

Node.js

Job description

Role overview

Lead the technical implementation of a Product Information Management (PIM) product that extends a Master Data Management platform with governed product data. The role blends hands‑on coding with engineering leadership: designing architecture, writing production code, setting direction, and mentoring a distributed team. The product centers on a taxonomy-driven attribute system with inheritance, provenance tracking, and complex hierarchical relationships, making strong data modeling and graph data experience essential.

Responsibilities

• Own end-to-end technical architecture for the PIM product, including schema design, taxonomy data structures, attribute inheritance, provenance tracking, and integration with the broader MDM core.
• Write production code daily, building core PIM backend services, data models, and critical pipelines.
• Set technical direction for the engineering team, review designs, unblock engineers, and ensure alignment with the broader platform architecture.
• Design and evolve data structures for large, deeply nested product taxonomies, category hierarchies, attribute inheritance chains, and governed attribute systems.
• Mentor engineers through code reviews, design sessions, and pairing, particularly with an offshore engineering team based in India.
• Partner with product management to scope features, weigh tradeoffs, and deliver a PIM product that handles real-world enterprise product catalogs.

Requirements

• 8+ years of software or data engineering experience with a strong track record of hands‑on technical leadership at the senior or principal level.
• Deep data modeling expertise, including production experience designing complex relational schemas, hierarchical data structures, and EAV-style patterns.
• Experience managing large product taxonomies, ontologies, or similar graph-backed data structures in production.
• Strong Python skills for backend service development, with SQLAlchemy or comparable ORM experience.
• Production SQL expertise, including query optimization, indexing strategy, and transactional design.
• Familiarity with Databricks or Apache Spark, and the ability to reason about large-scale data operations and lakehouse integration.

Nice to have

• Direct experience building PIM, MDM, PLM, or catalog management systems.
• Background in retail, manufacturing, CPG, or other industries with complex product data.
• Experience with FastAPI, modern Python async patterns, or Node.js.

Benefits and work setup

• Full-time role based in the USA, fully remote, with regular collaboration alongside an offshore engineering team.