Data Operations Specialist (Mid level, higher)

Truck Beast

  • Львов
  • Постоянная работа
  • Полная занятость
  • 27 д. назад
Опис вакансіїJob Summary We are Landstar representative in Lviv. A trucking company which is working around US since 2007.We are looking for a meticulous and Excel-savvyData Operations Specialist to support our growing supply chain and transportation operations. You will play a key role in ensuring accurate, timely, and well-formatted data that powers shipping decisions, inventory planning, carrier performance tracking, and more. This position requires a sharp eye for detail, proficiency in Excel, and a passion for turning data into actionable logistics insights.Key ResponsibilitiesData Entry & FormattingAccurately input and format data related to shipments, freight costs, delivery timelines, and inventory using cell styles, custom number formats, and validation rules.Formulas & FunctionsUse advanced Excel functions (IF, VLOOKUP/XLOOKUP, CONCAT, TEXT, DATE) to streamline data tracking across supply chain and freight records.Data AnalysisBuild and maintain PivotTables and charts to summarize carrier performance, transit times, warehouse metrics, and order fulfillment KPIs.VisualizationCreate dashboards and visual summaries using combo charts, sparklines, and conditional formatting to highlight trends and anomalies in logistics performance.AutomationRecord and implement macros to automate repetitive tasks such as daily shipment logs, freight invoice comparisons, and order reconciliation.Data IntegrationConsolidate data from multiple Excel workbooks, warehouse logs, and CSV files received from vendors, carriers, and third-party logistics (3PL) partners.Problem SolvingUse Excel's Goal Seek and What-If Analysis tools to model inventory targets, simulate cost changes, or evaluate route efficiency.CollaborationWork with cross-functional teams using shared workbooks and OneDrive to ensure seamless communication between logistics, inventory, and customer service teams.Error HandlingApply IFERROR functions and validation techniques to identify and prevent common data issues that may impact orders or delivery SLAs.Requirements2+ years of experience in data operationsProficiency in Microsoft Excel (Intermediate to Advanced)Familiarity with freight data, inventory systems, or order management workflowsExcellent organizational and problem-solving skillsKnowledge of OneDrive, SharePoint, or similar collaboration toolsStrong communication skills and attention to detailPreferred QualificationsExperience with Transportation Management Systems (TMS) or Warehouse Management Systems (WMS)Microsoft Excel certification or equivalent trainingFamiliarity with Power BI or Tableau is a plusWhy Work With Us?Join a fast-paced and supportive logistics teamMake a measurable impact on supply chain efficiency and customer satisfactionNon-bureaucracy culture: questions are resolved quickly, opportunities to influence the processes, new ideas and proposals are always welcomedCorporate events and team buildings where we celebrate our team and company's victories and achievements;Competitive salary according to the qualificationsTo find out more about this opportunity and learn about our perks, please send your CV with phone number, so we can get in touch with you!ВідгукнутисяТранспорт, логістика, 50-250 співробітників

work.ua