ERP Systems Coordinator-NetSuite

Overview

Manage NetSuite item imports, ensure data accuracy, support inventory accounting.

Key Responsibilities

• netsuite import
• netsuite customization
• data validation
• excel tools
• user training
• inventory management

Tasks

-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

• power query
• sql
• netsuite
• excel
• data cleaning
• inventory

What You Bring

-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.

People Also Searched For

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

About Lj Inc.

-A trusted partner in various sectors, specializing in construction, engineering, and project management. -Built a reputation for excellence with complex projects in both the private and public sectors. -Expertise in a wide array of construction disciplines, including roads, bridges, residential, and commercial buildings. -Notable projects include the revitalization of major urban thoroughfares, high-rise residential complexes, and large-scale transport hubs. -Seasoned professionals combine technical expertise with innovative solutions to complete projects on time and within budget. -Committed to improving communities through sustainable development and long-term value creation.

Sector Specialisms