Logistics Data Analyst I: Drive Efficiency & Insights

Canadian Solar Inc.; Mesquite (TX); On-site; USD 65,000 - 90,000; Full time

Job summary

CS Power Systems, a division of Canadian Solar, seeks a Logistics Data Specialist in Texas to manage logistics master data and create analytics for transportation planning, warehousing, and freight settlement. You’ll partner with Operations, Procurement, Trade Compliance, and Finance to ensure reliable information and actionable reporting.

Responsibilities include maintaining master data, auditing shipments, building dashboards, and providing KPI packs.

Qualifications

• Bachelor’s degree in Supply Chain, Logistics, Business Analytics, or related discipline.
• 2+ years in logistics, transportation analytics, or supply chain systems.
• Experience with freight invoices, carrier data, or brokerage information is highly valued.
• Advanced Excel (pivot tables, power query, xlookups).
• SQL or similar database querying.
• BI tools such as Power BI, Tableau, or Looker.
• Familiarity with SAP/TMS/WMS environments (e.g., SAP, Oracle, MercuryGate, etc.).
• Strong analytical reasoning.
• High attention to detail.
• Comfortable in fast-moving, build-phase environments.

Responsibilities

• Maintain carriers, lanes, rates, BOMs, HTS, and partner master data in TMS/WMS/SAP.
• Perform audits on shipments tracking milestones, POD, cost allocation, and accrual triggers.
• Identify root causes of data discrepancies and implement corrective actions.
• Build SOPs for data entry, validation logic, and exception handling
• Develop dashboards for OTIF, GIT, transit time, freight spend, accessorial, claims, and capacity utilization.
• Provide weekly/monthly KPI packs to operations leadership.
• Support budget vs. actual analysis and PR forecast modeling.
• Translate business requirements into SQL/BI outputs.
• Validate rating, fuel, and accessorial charges.
• Support three-way match among PO, shipment, and invoice.
• Prepare accrual and variance reports.
• Assist audit requests from Finance
• Act as super-user for TMS/WMS modules.
• Drive automation to reduce manual work
• Work with transportation, warehouse, procurement, and customs teams to improve data transparency.
• Provide data analysis for RFPs, network optimization, and vendor reviews
• All other duties as assigned

Skills

2+ years logistics analytics

Strong analytical reasoning

High attention to detail

Excel (pivot, Power Query, XLOOKUP)

SQL or similar querying

BI tools (Power BI, Tableau, Looker)

SAP/TMS/WMS environments

Education

Bachelor’s degree in Supply Chain, Logistics, Business Analytics, or related discipline

Tools

Excel

SQL

Power BI

Tableau

Looker

SAP/TMS/WMS

Job description

CS Power Systems, a division of Canadian Solar, seeks a Logistics Data Specialist in Texas to manage logistics master data and create analytics for transportation planning, warehousing, and freight settlement. You’ll partner with Operations, Procurement, Trade Compliance, and Finance to ensure reliable information and actionable reporting.

Responsibilities include maintaining master data, auditing shipments, building dashboards, and providing KPI packs.