ACES/PIES Data Developer — Build Automotive Kit-Assembly Pipeline

Posted 3 weeks ago

Worldwide

Summary

Looking for a data developer who actually knows ACES/PIES — not someone who just read about it. I sell automotive repair-part kits and need a pipeline that turns my kit templates into real, vehicle-specific kits from my ACES/PIES data. THE JOB Take my kit templates (e.g. brake kit = rotors + pads + hardware) and output the actual part numbers for every vehicle each kit fits — correct fitment, backup parts, and a flag list for anything questionable. I ALREADY HAVE ~29 kit templates with each part mapped to its PCdb PartTerminologyID, my ACES/PIES data, VCdb/PCdb/Qdb, and a live availability feed. I import to my store myself. DELIVERABLES - Python pipeline: for each kit x vehicle, pull part numbers reconciled to the SAME vehicle config — not just the same base vehicle. - Backups ranked by availability, but each must re-pass ACES fitment, not just be a PIES interchange. - Supersession resolved (no dead part numbers). - Clean kit CSV + an exception list. Re-runnable, not a throwaway script. MUST HAVE Real ACES/PIES + VCdb/PCdb/Qdb experience, strong Python/SQL, fitment reconciliation. We start with a small PAID PILOT — a few kits across a few platforms — before the full catalog. Tell me how you'd run the pilot. Answer the screening questions or I'll skip the proposal.

  • $10,000.00

    Fixed-price
  • Expert
    Experience Level
  • Remote Job
  • Complex project
    Project Type
Skills and Expertise
Mandatory skills
SQL
ETL Pipeline
Data Integration
Activity on this job
  • Proposals:50+
  • Last viewed by client:3 weeks ago
  • Interviewing:
    4
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Jan 3, 2013
  • United States
    Crosby8:55 AM
  • $482K total spent
    112 hires, 13 active
  • 20,316 hours
  • Automotive
    Small company (2-9 people)

Explore similar jobs on Upwork

Database University AssignmentsHourly‐ Posted 9 months ago
SQL
Database
Microsoft Excel
Database Design
Database Management
SQL Server Integration Services
Excel Macros
Excel Formula
Microsoft Power BI
Microsoft Excel PowerPivot
Power Query
Data Entry
Data Cleaning
Data Analytics
Data Extraction
AWS Glue
Apache Kafka
Python
HubSpot
Salesforce CRM
REST API
Node.js

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo