ERP Systems Coordinator-NetSuite

Description

• Ensure all required fields (Item Name, Unit of Measure, Cost, Price, Categories, Accounts, etc.) are complete, accurate, and aligned with the Chart of Accounts and GL structure.
• Follow company naming conventions, categorization standards, and item configuration best practices within NetSuite.
• Identify and resolve discrepancies or incomplete records; troubleshoot import and configuration errors as needed.
• Train new hires and internal stakeholders on inventory item setup, usage, and NetSuite best practices following implementation.
• Assist with or perform NetSuite customizations such as saved searches, workflows, custom fields, and forms to support item and inventory management.
• Prepare and format spreadsheets for NetSuite item imports using CSV templates.
• Collaborate with internal teams (Accounting, Operations, Procurement, IT) to clarify missing, inconsistent, or conflicting data.
• Maintain documentation of data sources, assumptions, naming conventions, and import procedures.
• Manage item and inventory records across multiple companies and subsidiaries, including handling intercompany logic and classifications.
• Apply accounting principles when assigning Revenue, COGS, Inventory, and Asset accounts to item records.
• Validate data for accuracy, consistency, and formatting before import using advanced Excel tools (formulas, conditional formatting, data validation, Power Query).

Requirements

• Knowledge of Power Query, Smartsheet, or SQL for data transformation and reporting (a plus).
• Ability to work independently, manage time effectively, and meet tight deadlines.
• Experience with mass data imports, structured templates, and large data cleaning/normalization tasks.
• Experience in creating and managing NetSuite customizations (saved searches, workflows, forms).
• High attention to detail, strong organizational skills, and commitment to data accuracy.
• Basic knowledge of Chart of Accounts structure (Revenue, COGS, Inventory, etc.) and how item setup impacts financials.
• Proven ability to identify and resolve import or data integrity issues independently.
• Strong Microsoft Excel skills (VLOOKUP/XLOOKUP, pivot tables, formulas, conditional formatting, data validation).
• Comfortable working in a dynamic, growing organization.
• Familiarity with Units of Measure, item categories, assemblies, and intercompany item usage.
• Commitment to confidentiality and adherence to best practices in data security.
• Excellent written and verbal communication skills.
• Understanding of NetSuite item structure and standards or ability to learn them quickly.
• Prior experience working with NetSuite ERP, including inventory, item records, purchasing, and multi-entity management.
• Strong accounting knowledge, especially around inventory valuation, GL impacts, and financial reporting.
• Familiarity with CSV file formats and mass data uploads into NetSuite.

Benefits

• 100% company-paid health insurance for employee and dependents
• 401(k) with 3% company match
• Opportunities for training, development, and growth
• Overtime pay after 8 hours/day
• Competitive compensation
• PTO and vacation time
• 100% company-paid dental and vision for employee and dependents

Training + Development

Interview process

Visa Sponsorship

Security clearance