Business Systems Data Analyst

Jem Accessories; Port Reading (NJ); On-site; USD 75,000 - 115,000; Full time

Benefits offered by this job

401(k) matching

Dental insurance

Flexible spending account

Health insurance

Health savings account

Life insurance

Paid time off

Vision insurance

Healthcare and 401(k)

Job summary

Jem Accessories is building modern data systems to support better decision-making across finance, operations, and the business. You’ll be a Business Systems Data Analyst (onsite in Woodbridge, NJ) helping lead ERP migration work, improve internal tools, and automate workflows so reporting stays accurate and current.

You will turn operational and financial data into actionable views to support investment, pricing, and cost decisions, collaborating with finance, operations, and sourcing to

Qualifications

• BA/BS in a technical, analytical, or finance-related field or equivalent experience.
• 0–3 years in data analysis, financial analysis, or data engineering (internships count).
• Strong SQL Server / T-SQL skills and Python for data work.
• Understanding of relational databases and data modeling.
• Familiar with revenue, cost of goods, gross margin, and P&L concepts.

Responsibilities

• Learn Sage data structures and map data to NetSuite during migration.
• Document data definitions and business rules for consistent reporting.
• Build profitability views by entity, channel, customer, and product.
• Collaborate with finance to reconcile data to the books and explain variances.
• Create automated data feeds to Microsoft SQL Server and ensure up-to-date reporting.
• Analyze performance across business entities and channels, including ecommerce and B2B wholesale.
• Translate financial results into actionable insights for leadership decisions.

Skills

SQL Server

T-SQL

Python

Data modeling

Relational databases

P&L

Financial concepts

Education

Bachelor’s degree in technical/analytical/finance field

Tools

SSIS

SSMS

SQL Server Agent

Sage

NetSuite

EDI

TrueCommerce

Google BigQuery

Job description

Jem Accessories is building modern data systems to support better decision-making across finance, operations, and the business. As a Business Systems Data Analyst (onsite in Woodbridge, NJ), you will help lead ERP migration work, improve internal tools, and automate workflows so reporting stays accurate and current. You will turn operational and financial data into actionable views that support investment, pricing, and cost decisions.

What you’ll do

• Learn how our data is structured in Sage (items, costs, orders, inventory, customers, and financials) and how those pieces connect
• Support the migration to NetSuite by mapping data between systems, cleaning it, and validating results after the move
• Document data definitions and business rules so teams work from the same numbers
• Analyze performance across business entities and sales channels, including B2B wholesale and ecommerce
• Build profitability views by entity, channel, customer, and product, including revenue, cost of goods, margin, and key cost drivers
• Partner with finance to reconcile operational data to the books and explain variances
• Convert financial results into clear insights that help leadership decide where to invest, adjust pricing, or cut costs
• Map end-to-end order flow, from EDI purchase orders received through TrueCommerce through fulfillment, shipment, and invoicing
• Track warehouse inventory flows (receipts, transfers, on-hand balances, and shipments) and identify issues early
• Build reporting to show where orders and inventory stand and flag delays, gaps, or mismatches
• Create automated data feeds into Microsoft SQL Server to reduce manual exports and keep reporting up to date
• Set up data quality checks to keep numbers consistent across systems and support internal tools and automated workflows
• Collaborate with finance, operations, supply chain, sales, product development, and sourcing to translate questions into reliable data
• Learn the business behind the data, including product development and costing, order fulfillment, and how each channel makes money

What you bring

• Bachelor’s degree in a technical, analytical, or finance-related field (or equivalent experience)
• 0–3 years of experience in data analysis, financial analysis, or data engineering (internships and projects count)
• Strong Microsoft SQL Server / T-SQL skills, including joins, CTEs, window functions, stored procedures, and views
• Working knowledge of Python for data work
• Understanding of relational databases and data modeling
• Comfort with core financial concepts such as revenue, cost of goods, gross margin, and the P&L
• Strong attention to detail and the ability to explain work clearly to non-technical partners
• Interest in learning the business, not only the tools

Technologies you’ll work with

• SQL Server, T-SQL, Python, SSIS, SSMS, SQL Server Agent
• Sage, NetSuite
• Centric PLM, EDI, TrueCommerce
• APIs, Google BigQuery

Benefits

• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance
• Healthcare and 401(k)

Nice to have

• SSIS, SSMS, or SQL Server Agent jobs
• Google BigQuery
• ERP or PLM experience (Sage, NetSuite, Centric)
• EDI experience (TrueCommerce), including documents like purchase orders, advance ship notices, and invoices
• Experience with warehouse or inventory data
• Financial modeling, multi-entity reporting, or general ledger data experience
• Experience with ecommerce or marketplace data
• Experience working with APIs
• Background in consumer products, retail, or supply chain