Join to apply for the ERP Systems Coordinator-NetSuite role at LJ Inc.
LJ Inc. is a leader in providing cutting-edge industrial, commercial, and residential turn-key solutions and is dedicated to delivering exceptional services to our valued customers. With a strong commitment to innovation, quality, and customer satisfaction, we have established ourselves as a trusted name in the industry.
Our team is comprised of talented professionals who are passionate about what they do. We believe in providing our employees with the necessary tools, resources, and support to excel in their roles and reach their full potential.
At LJ Inc., we strive for excellence in everything we do. We embrace new technologies, methodologies, and industry trends to stay ahead of the curve. Our commitment to continuous improvement and customer satisfaction sets us apart and drives our success.
Join our team and become part of a company that values your skills, knowledge, and contribution.
Position : NetSuite Item & Inventory Analyst (Accounting-Focused)
Responsibilities
- Prepare and format spreadsheets for NetSuite item imports using CSV templates.
- 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.
- Manage item and inventory records across multiple companies and subsidiaries, including handling intercompany logic and classifications.
- Follow company naming conventions, categorization standards, and item configuration best practices within NetSuite.
- Validate data for accuracy, consistency, and formatting before import using advanced Excel tools (formulas, conditional formatting, data validation, Power Query).
- Identify and resolve discrepancies or incomplete records; troubleshoot import and configuration errors as needed.
- Apply accounting principles when assigning Revenue, COGS, Inventory, and Asset accounts to item records.
- Maintain documentation of data sources, assumptions, naming conventions, and import procedures.
- Collaborate with internal teams (Accounting, Operations, Procurement, IT) to clarify missing, inconsistent, or conflicting data.
- Assist with or perform NetSuite customizations such as saved searches, workflows, custom fields, and forms to support item and inventory management.
- Train new hires and internal stakeholders on inventory item setup, usage, and NetSuite best practices following implementation.
Qualifications
Strong Microsoft Excel skills (VLOOKUP / XLOOKUP, pivot tables, formulas, conditional formatting, data validation).High attention to detail, strong organizational skills, and commitment to data accuracy.Familiarity with CSV file formats and mass data uploads into NetSuite.Understanding of NetSuite item structure and standards or ability to learn them quickly.Basic knowledge of Chart of Accounts structure (Revenue, COGS, Inventory, etc.) and how item setup impacts financials.Excellent written and verbal communication skills.Ability to work independently, manage time effectively, and meet tight deadlines.Comfortable working in a dynamic, growing organization.Preferred Qualifications
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.Experience with mass data imports, structured templates, and large data cleaning / normalization tasks.Familiarity with Units of Measure, item categories, assemblies, and intercompany item usage.Knowledge of Power Query, Smartsheet, or SQL for data transformation and reporting (a plus).Experience in creating and managing NetSuite customizations (saved searches, workflows, forms).Proven ability to identify and resolve import or data integrity issues independently.Commitment to confidentiality and adherence to best practices in data security.What We Offer
Competitive compensation100% company-paid health insurance for employee and dependents100% company-paid dental and vision for employee and dependents401(k) with 3% company matchOvertime pay after 8 hours / dayPTO and vacation timeOpportunities for training, development, and growthA dynamic, mission-driven work culture that values your contributions and supports your successSeniority level
Entry levelEmployment type
Full-timeJob function
Information TechnologyIndustries
IT Services and IT ConsultingJ-18808-Ljbffr