About HCLTechHCLTech is a global technology company, spread across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. We re powered by our people a global, diverse, multi-generational talent - representing 161 nationalities whose unique spark, perspective and boundless passion drive our culture of proactive value creation and problem-solving.To learn more about how we can supercharge progress for you, visitOverall Responsibilities: The Transportation Specialist will be responsible for supporting our e-Commerce Transportation Operation for North America. The specialist will work with carriers, customers, and internal stakeholders to execute daily transportation management functions following documented SOPs and providing status updates to the hiring manager.Core Responsibilities1. Data Analysis & Shipment Integrity (Primary Focus)Proactive Monitoring: Query large datasets to identify lagging or \"\"at-risk\"\" shipments across sales, returns, and trade-in flows.Performance Reporting: Maintain and update centralized KPI boards and dashboards to ensure real-time visibility for internal stakeholders.SQL Management: Execute minor SQL queries to extract, filter, and audit transportation data from internal databases.Root Cause Analysis: Perform deep-dive investigations into weekly and monthly On-Time Delivery (OTD) fluctuations to identify systemic carrier or lane issues.2. Transportation Operations Support (Secondary Focus)Escalation Management: Resolve complex shipment status inquiries by collaborating with carriers (UPS, FedEx, DHL), 3PL partners, and Fulfillment teams.Master Data Maintenance: Support the Transportation Operations Manager in configuring and troubleshooting master data within the Transportation Management System (TMS).Cross-Functional Collaboration: Act as the data subject matter expert (SME) for ongoing logistics projects and process improvement initiatives.Technical Requirements:Data Handling: 4-5 years of professional experience in data analysis, business intelligence, or a data-intensive operations role.SQL Proficiency: Ability to write and execute basic SQL queries for data extraction and manipulation.Advanced Tooling: Expert-level proficiency in Google Sheets and Microsoft Excel (Pivot Tables, complex formulas, data cleaning).Visualization: Experience maintaining or updating dashboards (e.g., Tableau, Looker, or Data Studio).Operational Requirements:Industry Knowledge: Foundational understanding of parcel transportation or warehouse operations.Analytical Thinking: Proven ability to navigate ambiguity, identify trends in \"\"noisy\"\" data, and propose actionable solutions.Communication: Strong ability to present data findings in a clear, concise manner to both technical and non-technical audiences.Outstanding follow-through, time management and planning skills to deliver results.Able to work in a dynamic, fast-paced environment as the market develops in unpredictable ways, producing high quality work and projecting a positive attitude.Preferred Skills/Qualifications:Experience operating within a Transportation Management System (TMS).Prior experience working with major parcel carriers, such as DHL Express, UPS, and FedEx.Intermediate to Advanced proficiency in Microsoft Excel (or Google Workspace), with working knowledge of SQL and Tableau.Prior Forecasting experienceLocation: LATAM (Brazil) (Must align with US PST Time Zone)Advanced EnglishWhy choose us?We are one of the largest and fastest growing technology companies in the world, with offices in over 60 countries and 224,000 employeesOur company is extremely diverse with 165 nationalities representedWe offer the opportunity to work with colleagues from all over the worldWe offer a virtual-first work environment, promoting a good integration between your work and personal life, with real flexibilityWe are committed to your growth, offering learning and career development opportunities at all levels to help you find your unique brilliance.Equality & Opportunity for AllRepresenting 165 nationalities worldwide, we are proud to be an equal opportunity employer committed to providing equal employment opportunities to all applicants and employees without regard to race, religion, sex, color, age, national origin, pregnancy, sexual orientation, disability or genetic information, or any other protected classification, in accordance with federal, state and/or local laws