Digitechlabs
Data Analyst 1
Digitechlabs, Oklahoma City, Oklahoma, United States,
We have below role with one of our direct customers.Top 3 Skills:
Data Analysis, Excel, Report CreationSummary:The main function of the Data Analyst is to provide business intelligence support and supporting areas by means of both repeatable and ad hoc reporting delivery reports (charts, graphs, tables, etc) that enable informed business decisions.Roles and Responsibilities:IQC Panel Return Claims Process:∙ Claim and submit RA Credit based PO for inbound received defective panels from SAMEX∙ Dispatch repairable panels to local RB center (AMKO) and process back-to-stock @GPCA∙ Consolidate non-repairable defects from (4) TX, IL, NJ, TOR IQC facilities to CA W/H∙ Process newly received RA credit upon vendor’s claim process completionIQC (Inbound Quality Check):∙ Data compiling, analyze panel inbound inspection result from (4) IQC facilities– Test Jig Maintenance∙ Obtain or Procure Test Jig required for Inspection purposes including Vendor Inquiry, Stock Allocation per facility– Internal Data Management∙ Report and share to SAMEX QC Team for analysis and root-cause evaluationReturns Inspection Data Management:∙ Data compiling, analyze panel return inspection result from (4) IQC facilities∙ Report and share to SAMEX QC Team for analysis and root-cause evaluationPackaging Material Order Management:∙ Procure Panel internal packaging and outer box for back-to-stock panel∙ Submit PO and process Invoice payment w/ APQuality Report(s) DA/VD:∙ Defect/damage Returns Data Extraction∙ Query data management weekly, monthly, annual∙ Data Analysis of returns across 2,000 accountsVendor PO creation:∙ Internal supply, operation, equipment, misc service∙ For Panel Inspection W/H only (process owned by GPCA)Carrier Performance Dashboard:∙ Data analysis of Carrier Defect, Damage rate performance, LTL vs. MR comparisonWorst Carrier Route Dashboard:∙ Data analysis of worst delivery route by customer, zip code, ship-typeCore Parts Pricing:∙ Pricing data extraction and determine Core Pricing for new parts registration∙ Fixed Pricing update, Core-A Pricing update, Distributor Pricing Adjustment, Net Value ErrorField Service Support:∙ Support FS VOC inquiries related to Pricing error, delayed Returns, Shipment delay etc.∙ Update/Adjust PNN Cap allowance per systemExperience:
1 to 3 YearsBilingual:
English and KoreanJob Category:
TechnologyJob Type:
Full TimeApply for this position
Full Name *Email *Phone *Upload CV/Resume * Allowed Type(s): .pdf, .doc, .docxBy using this form you agree with the storage and handling of your data by this website.
#J-18808-Ljbffr
Data Analysis, Excel, Report CreationSummary:The main function of the Data Analyst is to provide business intelligence support and supporting areas by means of both repeatable and ad hoc reporting delivery reports (charts, graphs, tables, etc) that enable informed business decisions.Roles and Responsibilities:IQC Panel Return Claims Process:∙ Claim and submit RA Credit based PO for inbound received defective panels from SAMEX∙ Dispatch repairable panels to local RB center (AMKO) and process back-to-stock @GPCA∙ Consolidate non-repairable defects from (4) TX, IL, NJ, TOR IQC facilities to CA W/H∙ Process newly received RA credit upon vendor’s claim process completionIQC (Inbound Quality Check):∙ Data compiling, analyze panel inbound inspection result from (4) IQC facilities– Test Jig Maintenance∙ Obtain or Procure Test Jig required for Inspection purposes including Vendor Inquiry, Stock Allocation per facility– Internal Data Management∙ Report and share to SAMEX QC Team for analysis and root-cause evaluationReturns Inspection Data Management:∙ Data compiling, analyze panel return inspection result from (4) IQC facilities∙ Report and share to SAMEX QC Team for analysis and root-cause evaluationPackaging Material Order Management:∙ Procure Panel internal packaging and outer box for back-to-stock panel∙ Submit PO and process Invoice payment w/ APQuality Report(s) DA/VD:∙ Defect/damage Returns Data Extraction∙ Query data management weekly, monthly, annual∙ Data Analysis of returns across 2,000 accountsVendor PO creation:∙ Internal supply, operation, equipment, misc service∙ For Panel Inspection W/H only (process owned by GPCA)Carrier Performance Dashboard:∙ Data analysis of Carrier Defect, Damage rate performance, LTL vs. MR comparisonWorst Carrier Route Dashboard:∙ Data analysis of worst delivery route by customer, zip code, ship-typeCore Parts Pricing:∙ Pricing data extraction and determine Core Pricing for new parts registration∙ Fixed Pricing update, Core-A Pricing update, Distributor Pricing Adjustment, Net Value ErrorField Service Support:∙ Support FS VOC inquiries related to Pricing error, delayed Returns, Shipment delay etc.∙ Update/Adjust PNN Cap allowance per systemExperience:
1 to 3 YearsBilingual:
English and KoreanJob Category:
TechnologyJob Type:
Full TimeApply for this position
Full Name *Email *Phone *Upload CV/Resume * Allowed Type(s): .pdf, .doc, .docxBy using this form you agree with the storage and handling of your data by this website.
#J-18808-Ljbffr