PART MAPPING ANALYST

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Full Time

SALARY

$600-$900/month

HOURS PER WEEK

40

DATE UPDATED

Nov 30, 2024

JOB OVERVIEW

REQUIRED SKILLS
· English fluency in both written and verbal communication
· Advanced MS Excel
· Advanced MS Access – Tables and Queries
· High Level of Automotive Aftermarket Parts and Application Data Knowledge
· Highly skilled ability to produce required deliverables in an environment requiring ownership, critical thinking, and self-motivation.
· Associate or Bachelor Degree

PREFERRED SKILLS
· Advanced GMCCA IMS (ERAPA) Knowledge
· Advanced PartSmart or PIM experience
· Advanced knowledge of ACES and PIES (Auto Care Association Data Standards)
· Experience with 3D parts prints
· Cognos
· Associate or bachelor’s degree preferred

PLEASE FILL OUT THIS FORM:
----------

SKILL REQUIREMENT
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0010
Controller Execution Time ( Jobseekers / Job )  0.0158
Total Execution Time  0.0176
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,495,992 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/PART-MAPPING-ANALYST-1267028
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0072 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0004   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1267028
 LIMIT 1 
0.0003   SELECT *
FROM `employers`
WHERE `employer_id` = 306366
 LIMIT 1 
0.0003   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1267028
AND `misc`.`idIS NULL 
0.0013   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-04-19',ej.date_added) duration_daysDATEDIFF('2026-04-19',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_jobs ej WHERE e.employer_id ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-04-19',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1267028' 
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1267028 
0.0022   UPDATE employer_jobs SET hit_counts '***Nov-20-2024=5***Nov-21-2024=18***Nov-22-2024=35***Nov-23-2024=7***Nov-24-2024=2***Nov-25-2024=5***Nov-26-2024=3***Nov-27-2024=2***Nov-28-2024=1***Nov-29-2024=1***Nov-30-2024=135***Dec-01-2024=31***Dec-02-2024=25***Dec-03-2024=7***Dec-04-2024=6***Dec-05-2024=1***Dec-06-2024=2***Dec-07-2024=5***Dec-08-2024=2***Dec-09-2024=5***Dec-10-2024=4***Dec-11-2024=4***Dec-12-2024=3***Dec-13-2024=1***Dec-16-2024=3***Dec-17-2024=1***Dec-19-2024=1***Dec-20-2024=1***Dec-22-2024=1***Dec-23-2024=1***Dec-24-2024=1***Dec-25-2024=2***Dec-26-2024=3***Dec-27-2024=2***Dec-29-2024=1***Jan-03-2025=1***Jan-08-2025=1***Jan-09-2025=2***Jan-10-2025=2***Jan-11-2025=1***Jan-13-2025=2***Jan-15-2025=1***Jan-17-2025=1***Jan-18-2025=1***Jan-20-2025=2***Jan-22-2025=1***Jan-24-2025=2***Jan-25-2025=1***Jan-29-2025=2***Jan-30-2025=1***Feb-03-2025=2***Feb-04-2025=1***Feb-06-2025=3***Feb-07-2025=2***Feb-08-2025=1***Feb-12-2025=2***Feb-13-2025=1***Feb-18-2025=2***Feb-20-2025=2***Feb-21-2025=1***Feb-23-2025=1***Feb-25-2025=2***Mar-03-2025=1***Mar-04-2025=1***Mar-05-2025=1***Mar-20-2025=1***Mar-22-2025=2***Mar-23-2025=1***Mar-24-2025=2***Mar-25-2025=1***Mar-27-2025=5***Apr-08-2025=2***Apr-09-2025=2***Apr-10-2025=1***Apr-11-2025=1***Apr-21-2025=1***Apr-22-2025=1***Apr-29-2025=3***May-02-2025=1***May-03-2025=1***May-07-2025=2***May-15-2025=3***May-20-2025=1***May-26-2025=2***May-27-2025=1***Jun-01-2025=1***Jun-08-2025=1***Jun-12-2025=1***Jun-22-2025=3***Jun-25-2025=1***Jun-28-2025=1***Jul-04-2025=1***Jul-06-2025=1***Jul-09-2025=1***Jul-13-2025=1***Jul-14-2025=1***Jul-27-2025=1***Aug-03-2025=2***Aug-04-2025=3***Aug-05-2025=1***Aug-26-2025=1***Aug-27-2025=1***Aug-28-2025=1***Sep-07-2025=1***Sep-11-2025=2***Sep-15-2025=1***Sep-18-2025=1***Sep-19-2025=2***Sep-26-2025=1***Sep-28-2025=1***Oct-03-2025=1***Oct-06-2025=1***Oct-08-2025=1***Oct-15-2025=1***Oct-21-2025=1***Oct-23-2025=1***Oct-27-2025=1***Nov-04-2025=4***Nov-06-2025=1***Nov-08-2025=1***Nov-20-2025=1***Nov-21-2025=1***Nov-25-2025=1***Nov-26-2025=1***Nov-27-2025=1***Nov-28-2025=1***Dec-02-2025=3***Dec-10-2025=1***Dec-13-2025=1***Dec-20-2025=1***Dec-23-2025=1***Dec-26-2025=1***Jan-01-2026=1***Jan-08-2026=1***Jan-21-2026=1***Feb-23-2026=1***Mar-08-2026=1***Apr-02-2026=1***Apr-17-2026=1***Apr-19-2026=1' WHERE job_id'1267028'  
0.0006   UPDATE employer_jobs SET monthly_hits '***Nov-2024=214***Dec-2024=113***Jan-2025=21***Feb-2025=20***Mar-2025=15***Apr-2025=11***May-2025=11***Jun-2025=7***Jul-2025=6***Aug-2025=9***Sep-2025=9***Oct-2025=7***Nov-2025=12***Dec-2025=8***Jan-2026=3***Feb-2026=1***Mar-2026=1***Apr-2026=3' WHERE job_id'1267028'  
0.0003   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1267028' AND status LIKE 'sent%' ORDER BY id DESC  
0.0002   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1267028 
0.0004   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '306366'
AND `date_added` >= '2022-06-08' 
0.0003   select from teasers 
0.0002   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)