Data Integrator

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

TYPE OF WORK

Full Time

SALARY

$900-$1300/month

HOURS PER WEEK

40

DATE UPDATED

Nov 30, 2024

JOB OVERVIEW

Preferred Skills
-Advanced GMCCA IMS (ERAPA) Knowledge
-Advanced PartSmart or PIM experience
-Advanced knowledge of ACES and PIES (Auto Care Association Data Standards)
-Associate or bachelor’s degree preferred

-Support the PartSmart PIM Team.
-Support the PIM tool improvements with tracking bugs, creating enhancement requests, user acceptance testing, working with the COTS vendor, etc.
-Import, export, and deliver cataloging data.
-Assist cataloging team in auditing data and identifying ways to make systematic improvements.
-Analyze/map part and vehicle data using various tools such as Microsoft Access, VBA, SQL, KNIME, Dremio, Hue, Python, C#, EUC, Cognos, Regex, etc.
-Maintain current Power BI (PowerAutomate) and SharePoints used in the cataloging space.
-Run metrics reports.
-Maintain and update database for cataloging team to easily audit parts outside of PartSmart.
-Identify and execute process/system improvements.
-Support battery application mapping.
-Load Auto Care tables (including the Pseudo tables).
-Maintain Firebird processes.
-Coordinate with Data Mapping team to deploy system improvements and new functionality (for Firebird and VIN/vehicle mapping).
-Complete Special Projects as required.



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

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0032
Controller Execution Time ( Jobseekers / Job )  0.0320
Total Execution Time  0.0362
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,502,688 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Data-Integrator-1267024
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0246 seconds)  (Hide)
0.0007   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0003   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1267024
 LIMIT 1 
0.0009   SELECT *
FROM `employers`
WHERE `employer_id` = 306366
 LIMIT 1 
0.0007   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1267024
AND `misc`.`idIS NULL 
0.0004   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 '1267024' 
0.0004   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1267024 
0.0022   UPDATE employer_jobs SET hit_counts '***Nov-20-2024=15***Nov-21-2024=48***Nov-22-2024=10***Nov-23-2024=7***Nov-24-2024=8***Nov-25-2024=6***Nov-29-2024=3***Nov-30-2024=163***Dec-01-2024=28***Dec-02-2024=27***Dec-03-2024=5***Dec-04-2024=6***Dec-05-2024=1***Dec-06-2024=4***Dec-09-2024=2***Dec-10-2024=1***Dec-11-2024=2***Dec-12-2024=2***Dec-14-2024=2***Dec-16-2024=1***Dec-18-2024=1***Dec-19-2024=2***Dec-20-2024=3***Dec-21-2024=2***Dec-22-2024=3***Dec-23-2024=6***Dec-24-2024=2***Dec-25-2024=1***Dec-28-2024=1***Dec-29-2024=1***Dec-30-2024=4***Dec-31-2024=3***Jan-03-2025=2***Jan-05-2025=1***Jan-06-2025=3***Jan-08-2025=2***Jan-10-2025=4***Jan-11-2025=2***Jan-12-2025=1***Jan-13-2025=1***Jan-15-2025=2***Jan-16-2025=2***Jan-18-2025=1***Jan-23-2025=1***Jan-24-2025=1***Jan-25-2025=1***Jan-27-2025=2***Jan-28-2025=2***Jan-29-2025=2***Jan-31-2025=1***Feb-03-2025=2***Feb-04-2025=1***Feb-05-2025=1***Feb-07-2025=2***Feb-08-2025=1***Feb-09-2025=1***Feb-13-2025=2***Feb-14-2025=1***Feb-16-2025=4***Feb-17-2025=2***Feb-18-2025=2***Feb-19-2025=2***Feb-20-2025=2***Feb-21-2025=5***Feb-22-2025=2***Feb-24-2025=2***Feb-25-2025=2***Feb-26-2025=1***Feb-28-2025=1***Mar-01-2025=2***Mar-06-2025=1***Mar-15-2025=1***Mar-17-2025=1***Mar-20-2025=1***Mar-22-2025=2***Mar-25-2025=1***Mar-27-2025=2***Mar-31-2025=1***Apr-02-2025=1***Apr-04-2025=1***Apr-07-2025=1***Apr-08-2025=2***Apr-10-2025=1***Apr-29-2025=2***May-04-2025=1***May-07-2025=1***May-24-2025=1***May-25-2025=1***May-26-2025=1***May-28-2025=4***May-31-2025=1***Jun-01-2025=3***Jun-03-2025=1***Jun-14-2025=1***Jun-18-2025=1***Jun-19-2025=1***Jun-21-2025=1***Jun-22-2025=2***Jun-25-2025=1***Jun-26-2025=2***Jun-28-2025=1***Jul-03-2025=1***Jul-08-2025=1***Jul-10-2025=1***Jul-11-2025=1***Jul-13-2025=1***Jul-14-2025=1***Jul-16-2025=3***Jul-18-2025=4***Jul-22-2025=1***Jul-23-2025=1***Jul-24-2025=4***Jul-29-2025=1***Jul-30-2025=1***Aug-01-2025=1***Aug-02-2025=2***Aug-04-2025=1***Aug-05-2025=2***Aug-07-2025=1***Aug-15-2025=2***Aug-17-2025=1***Aug-18-2025=2***Aug-19-2025=2***Aug-21-2025=2***Aug-23-2025=2***Aug-25-2025=1***Aug-27-2025=1***Sep-05-2025=1***Sep-06-2025=1***Sep-09-2025=1***Sep-13-2025=1***Sep-15-2025=1***Sep-19-2025=1***Sep-21-2025=1***Sep-24-2025=1***Sep-28-2025=1***Sep-30-2025=1***Oct-01-2025=1***Oct-03-2025=1***Oct-04-2025=1***Oct-07-2025=1***Oct-08-2025=1***Oct-12-2025=1***Oct-15-2025=3***Oct-16-2025=1***Oct-25-2025=1***Oct-28-2025=1***Nov-01-2025=2***Nov-04-2025=1***Nov-06-2025=3***Nov-07-2025=1***Nov-15-2025=1***Nov-19-2025=1***Nov-26-2025=1***Nov-29-2025=1***Nov-30-2025=1***Dec-02-2025=3***Dec-09-2025=5***Dec-10-2025=1***Dec-11-2025=1***Dec-12-2025=1***Dec-23-2025=1***Dec-26-2025=2***Dec-28-2025=1***Dec-31-2025=1***Jan-01-2026=1***Jan-05-2026=1***Jan-09-2026=1***Jan-10-2026=1***Jan-21-2026=1***Jan-27-2026=1***Jan-30-2026=1***Jan-31-2026=1***Feb-03-2026=2***Feb-04-2026=2***Feb-07-2026=1***Feb-08-2026=1***Feb-11-2026=1***Feb-18-2026=1***Feb-19-2026=1***Feb-23-2026=1***Mar-07-2026=1***Mar-10-2026=1***Mar-16-2026=1***Mar-17-2026=1***Mar-28-2026=1***Apr-02-2026=2***Apr-06-2026=2***Apr-07-2026=2***Apr-08-2026=2***Apr-09-2026=2***Apr-14-2026=1***Apr-16-2026=4***Apr-19-2026=1' WHERE job_id'1267024'  
0.0012   UPDATE employer_jobs SET monthly_hits '***Nov-2024=260***Dec-2024=110***Jan-2025=31***Feb-2025=36***Mar-2025=12***Apr-2025=8***May-2025=10***Jun-2025=14***Jul-2025=21***Aug-2025=20***Sep-2025=10***Oct-2025=12***Nov-2025=12***Dec-2025=16***Jan-2026=8***Feb-2026=10***Mar-2026=5***Apr-2026=16' WHERE job_id'1267024'  
0.0040   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1267024' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1267024 
0.0124   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '306366'
AND `date_added` >= '2022-06-08' 
0.0007   select from teasers 
0.0003   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)