LJ Inc. provides comprehensive solutions in construction, engineering, and project management.
Manage NetSuite item imports, ensure data accuracy, support inventory accounting.
1 months ago ago
Intermediate (4-7 years), Junior (1-3 years)
Full Time
Swartz Creek, MI
Office Full-Time
Company Size
500 Employees
Service Specialisms
Construction services
Project Management
Consulting
Engineering
Architecture
Property Development
Design
Technical Services
Sector Specialisms
Electrical Services
Generator Services
Heating and Cooling
Industrial Turn-Key Services
Automation and Robotic Solutions
Underground Utility
Rigging
Machine Repair
Role
Description
netsuite import
netsuite customization
data validation
excel tools
user training
inventory management
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
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
Information not given or found
Interview process
Information not given or found
Visa Sponsorship
Information not given or found
Security clearance
Information not given or found
Company
Overview
Early 2000s Founded
Year of Establishment
The company was established during the early years of the 21st century.
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.
Culture + Values
Customer Focused: We strive to exceed customer expectations in all that we do.
Innovation: We embrace change and strive to continuously improve.
Integrity: We hold ourselves to the highest ethical standards in all interactions.
Collaboration: We believe teamwork fosters greater creativity and innovation.
Excellence: We are committed to delivering outstanding results.
Environment + Sustainability
By 2035
Net-Zero Target
Targeting net-zero carbon emissions by 2035.
Committed to reducing environmental impact through sustainable practices.
Investing in energy-efficient technologies across all operations.
Continuously evaluating and improving waste management systems.
Committed to reducing water consumption and promoting recycling.
Inclusion & Diversity
50% Female Leadership
Gender Balance Target
Aiming for gender balance in leadership roles with a target of 50% female representation.
Promote a culture of respect and inclusion across all levels of the organization.
Implementing mentorship programs for underrepresented groups in the workforce.
Focus on building an inclusive environment that values diverse perspectives.