What are the responsibilities and job description for the Data Engineer position at PineQ Lab Technology?
Role :- Data Architect with strong Retail and AWS Experience
Location :- Plano, TX(Hybrid) (once in a 2 week or occasional basis)
Hire Type : Contract
Project Duration : 12 months, with extension
Job Description :-
What you'll do:
Design and enforce the canonical domain model (Product, Order, Customer, Cart, Inventory, Price, Payment) that all brands conform to
Design the data pipelines connecting enterprise systems (ERP, OMS, Inventory, CRM, Pricing, payments) to the platform
Design the data infrastructure to support future AI/ML workloads — tenant-partitioned feature stores, clickstream capture, entity resolution, data lineage, and PII governance
Lead brand migration. Facilitate workshops with brand teams and upstream system owners to map existing data to the canonical model, identify gaps, and agree the migration path & data migration automation
Present data architecture decisions as formal ADRs to the Architecture Review Board
Partner with the Platform Architecture Lead as the data domain expert — drive the data workstream independently
Tech stack:
AWS, AWS (RDS PostgreSQL, ElastiCache, S3, EventBridge, Glue, DMS), Datastax Astra, Neptune, SageMaker Feature Store, EMR, Snowflake
What you bring:
Multi-tenant data isolation at scale
Event-driven architecture and change data capture pipeline engineering
Ecommerce domain modeling across order management, inventory, and pricing
Snowflake or equivalent data warehouse/lakehouse technologies . schema design, partitioning strategies, and query optimization
PCI-DSS and GDPR data compliance . classification, encryption, access controls, and audit trails for cardholder data and customer PII
Java and Python proficiency
AI/ML foundational knowledge . understanding of feature engineering, data pipelines for model training, and how data architecture decisions enable or constrain ML workloads