About

About Us Newark Auto is a specialty automotive parts company focused on classic and vintage vehicles across multiple makes and models. We manufacture custom interior components (carpets, seat covers, upholstery) made to order based on specific vehicle configurations and customer material selections. We pride ourselves on precision craftsmanship and helping classic car enthusiasts restore their vehicles to original or better-than-original condition. The Challenge We need to finalize and implement a sophisticated Product Information Management (PIM) database system that handles: - Complex vehicle fitment data (year, make, model, body type, transmission, drive side, etc.) - Conditional product options based on vehicle configuration and material selection - Dynamic pricing based on base part + material combinations - Bill of Materials (BOM) relationships and manufacturing data - Easy-to-use internal tools that allow our customer service team to quickly find product information, check fitments, and generate quotes Important: We are automotive and business logic experts. You will be the technical expert implementing our database vision. You don't need automotive experience - we'll guide you on all the fitment logic and business requirements. Required Technical Skills Must Have: - 3-5+ years professional database administration or data engineering experience - Expert-level PostgreSQL knowledge (data modeling, optimization, indexing) - Retool experience building user-friendly internal applications for non-technical users - Strong understanding of relational database design and normalization - Experience with complex data relationships and conditional logic - SQL query optimization and performance tuning - Data migration experience - UX mindset: Can design interfaces that are simple and intuitive for non-technical users - Git/version control proficiency Highly Desirable: - Supabase experience - Experience with product catalog or configurator databases - Understanding of manufacturing/BOM systems - Experience with e-commerce or inventory systems - Python or Node.js for scripting/automation - Experience building customer service or sales tools Required Soft Skills - Strong communicator: Can explain database concepts in plain language - Collaborative: Comfortable working closely with domain experts - Problem solver: Can translate business requirements into database structures - Detail-oriented: Data integrity is critical for manufacturing - Self-directed: Can work independently with regular check-ins - Documentation mindset: Creates clear documentation as you build Languages - English: Professional proficiency required for technical documentation - Spanish: We're fluent in Spanish - we can work in Spanish, English, or both! Tech Stack - Database: PostgreSQL / Supabase - Internal Tools: Retool - Scripting: Python or Node.js (optional but helpful) - Version Control: Git / GitHub - Data Migration: Your choice of tools What Makes This Opportunity Unique - Work on genuinely complex data modeling (not another simple CRUD app) - Strong database foundation already exists (70% complete) - you'll complete and refine - Direct collaboration with business owners - fast decisions, no bureaucracy - Automotive industry exposure without needing prior experience - Potential for long-term relationship (Phase 2: Shopify integration and customer-facing tools) - Build the foundation that will power the entire business How to Apply Please include: 1. Resume/CV with relevant project experience 2. Portfolio showing: - Complex database schemas you've designed - Retool applications you've built (screenshots or descriptions) - especially tools for non-technical users - Examples of data modeling for complex systems 3. Brief cover letter (3-5 sentences) answering: - What's the most complex database schema you've designed? - Do you have experience building Retool tools for non-technical users? Describe what you've built. - Are you comfortable working in Spanish, English, or both? 4. Availability: Start date and hours per week