A

ABB

Electrification, automation, and robotics solutions

Sales Administrator

Data EntryPosted on Nov 10
Full-timeShanghai, ChinaNo salary listedIn-person

About the Job

Requirements

  • Advanced Excel skills, including VLOOKUP and XLOOKUP, PivotTable, filtering, deduplication, conditional formatting, and basic data validation; bulk data processing capability is a plus.
  • Meticulous and rigorous data handling, with high attention to codes, material numbers, and serial numbers and a low error tolerance.
  • Ability to read basic commercial documents, including purchase orders and delivery slips, and familiarity with basic technical English terms.
  • Ability to communicate effectively and proactively escalate ambiguities rather than guess or fill in data without confirmation.

Responsibilities

  • Clean, complete, standardize, enter, and update the install-base master database, including power plant master data (owner name, plant name, location, unit number, installed capacity, and commissioning date) and equipment records (model, material number, serial number, supply scope, and excitation or control system type).
  • Reconcile data across sources by extracting information from emails and inputting information from different sales sources.
  • Maintain the master file by updating the central Excel sheet using the standard template and applying consistent Chinese and English naming conventions to support filtering and PivotTable analysis.
  • Generate filtered install-base lists by owner, region, or equipment model upon sales request; the role does not involve quotation work or direct customer interface.
  • Track progress, highlight blockers, and conduct regular quality check-ins.
  • Deliver a standardized install-base master Excel ledger aligned to field definitions, an exception log documenting missing or conflicting data for sales and customer validation, and a well-structured archive folder with properly named supporting documents.

Desired Qualifications

  • Experience in industrial equipment, power or automation, or spare parts ledger management.
  • Bulk data processing capability.

About the Company

ABB

Electrification, automation, and robotics solutions

ABB provides electrification and automation technologies for industry and infrastructure. Its products include smart building systems, electric vehicle charging, robotics, motors and drives, and factory automation software, delivered as integrated hardware and software that manage energy and automate tasks. ABB differentiates itself with a long history in power and automation, a broad global footprint, and a focused portfolio around electrification, motion, process automation, and robotics, complemented by digital services. Its goal is to help customers use energy more efficiently and work more productively, enabling sustainable and resource-efficient operations and transportation.

Company size
10,001+
Company stage
IPO
Headquarters
Zurich, Switzerland
Founded
2007

Recently Posted Jobs

Explore more opportunities at ABB

See more jobs