Commerce Operations Coordinator

Aquent; New York (NY); On-site; USD 42,000 - 54,000; Full time

Benefits offered by this job

subsidized health

vision

dental plans

paid sick leave

retirement plans with a match

free online training through AquentGym

Job summary

Aquent is seeking an Administrative & Data Entry Consultant to join its Commerce team. You will manage data flow, reporting, and allocation processes with meticulous attention to detail, enabling faster product launches and stronger partner relationships.

Ideal candidates bring 1–3 years of related experience, advanced Excel skills, and a proactive, autonomous work style. This role focuses on accuracy, efficiency, and clear communication in a fast-paced environment.

Qualifications

• Proven proficiency in Microsoft Excel with advanced functions used for data accuracy.
• Experience with VLOOKUPs, PivotTables, and data integrity across large spreadsheets.
• Strong data-entry skills and meticulous attention to detail for high-volume tasks.
• Excellent organizational and time-management abilities with clear written/verbal communication.

Responsibilities

• Prepare, update, and maintain Excel files using advanced functions and precise data entry.
• Transfer and reconcile data between files and templates for IT uploads.
• Learn and master allocation entry and setup processes via training materials.
• Prepare critical allocation upload files by brand, retailer, and quantity for launches.
• Manage Future Launch Order Form files with cross-functional partners to ensure readiness.
• Collect No Cost allocation files for samples and GWPs and prepare templates.
• Review order form files for completeness and drive on-time processing.
• Communicate updates to the Commerce team and maintain tracking files for visibility.
• Provide administrative support including scheduling, meetings, data analysis, and file management.

Skills

Excel proficiency

VLOOKUPs

PivotTables

Formulas

Data entry

Attention to detail

Organization

Communication

Autonomy

MS Office

Job description

Aquent is partnering with a leading global consumer goods company renowned for its innovative and diverse product portfolio. This dynamic organization is at the forefront of its industry, constantly evolving to meet consumer demands and deliver exceptional experiences. Joining this team means contributing to a vibrant environment where precision and efficiency drive success in bringing beloved products to market.

Are you a highly organized, detail-oriented professional with a passion for data and operational excellence? We are seeking an enthusiastic Administrative & Data Entry Consultant to become an integral part of a fast-paced Commerce team. In this pivotal role, you won't just be processing data; you'll be the backbone of critical operations, ensuring seamless data flow, accurate reporting, and efficient allocation processes. Your meticulous work will directly empower the team to make informed decisions, streamline product launches, and maintain strong partnerships, making a tangible impact on the company’s market presence and customer satisfaction.

What You’ll Do:

• Prepare, update, and maintain essential Excel files utilizing advanced functions such as VLOOKUPs, PivotTables, and complex formulas, alongside precise data entry.
• Transfer and meticulously reconcile data between various existing files and standardized templates, preparing them for seamless IT system uploads.
• Master the allocation entry and setup process through dedicated training sessions and recorded materials, becoming a go-to expert.
• Proactively prepare critical allocation upload files, segmented by brand, retailer, and quantity, for key initiatives including holiday sets, yearly collections, and exciting future product launches.
• Manage vital Future Launch Order Form files, collaborating with Marketing, DP/SP, and other cross‑functional partners to ensure all information is complete and ready for processing.
• Collect No Cost allocation files for samples and GWPs, preparing standardized templates for efficient system entry across diverse brands and retailers.
• Rigorously review order form files, proactively identifying missing information, incomplete submissions, and outstanding actions to prevent delays.
• Communicate timely updates to the Commerce team regarding newly published forms and the real‑time status of various files.
• Maintain accurate tracking files that reflect the latest status, progress, and outstanding items, providing clear visibility to stakeholders.
• Review the daily compliance report and collaborate with Customer Care on prompt follow‑up and resolution of any issues.
• Provide comprehensive administrative and operational support to team members, encompassing scheduling, meeting coordination, data analysis, data entry, and meticulous file creation and management.
• Proactively communicate your workload, project status, and completed assignments to the team, fostering transparency and collaboration.
• Identify and champion opportunities to enhance file organization, accuracy, and overall operational efficiency, driving continuous improvement.

What You’ll Bring:

• 1-3 years of hands‑on administrative, data entry, operations, or directly related experience.
• Exceptional proficiency in Microsoft Excel, including:
  • Expertise in VLOOKUPs and PivotTables.
  • Strong command of basic formulas and their application.
  • Proven ability to manage and efficiently update multiple complex spreadsheets.
  • Skill in copying/duplicating formulas while meticulously maintaining data integrity.
• Impeccable attention to detail and a commitment to accuracy, especially when handling large volumes of data.
• Excellent organizational and time‑management skills, with a demonstrated ability to effectively prioritize and juggle multiple tasks simultaneously.
• Strong written and verbal communication skills, enabling clear and concise interactions.
• The ability to work autonomously, maintain high motivation, and proactively seek out additional work upon completion of assignments.
• A natural comfort with learning new systems and processes, leveraging both formal training and self‑guided resources.
• Proficiency across the entire Microsoft Office Suite.

Bonus Points For:

• Experience within supply chain or operations environments.
• Background in retail or consumer products industries.
• Familiarity with product management processes.
• Knowledge of inventory management.
• Prior experience with allocation or order management systems and processes.
• Experience collaborating with Commerce, Marketing, Customer Care, or other cross‑functional teams.
• Familiarity with inventory terminology and allocation processes.

About Aquent Talent:

Aquent Talent connects the best talent in marketing, creative, and design with the world’s biggest brands. Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium. More information on our awesome benefits!

• subsidized health
• vision
• dental plans
• paid sick leave
• retirement plans with a match
• free online training through Aquent Gymnasium

Aquent is an equal‑opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We’re about creating an inclusive environment-one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive.