What are the responsibilities and job description for the Senior Retail System Analyst position at Ashley Stewart, Inc.?
We are seeking a Senior Retail Systems Analyst with deep experience supporting enterprise retail systems and business processes across stores and ecommerce. The ideal candidate has a strong background in JDA/MMS Merchandising and Sales Audit, SQL scripting, RoboFTP, and Power BI, as well as hands-on ERP experience with NetSuite, preferably including participation in a NetSuite implementation. This role will serve as a key partner to IT, merchandising, operations, and finance teams to optimize system performance, ensure data accuracy, and drive process efficiencies in a dynamic retail environment.
Configure, support, and maintain JDA/MMS (Merchandise Management & Sales Audit) to ensure operational continuity across merchandising, pricing, and inventory functions.
Support Sales Audit processes that update MMS to maintain financial integrity between ecommerce, store sales, and ERP data and payment settlement.
Develop and maintain complex SQL scripts and stored procedures for data extraction, transformation, and reporting for numerous integrations and also including Power BI.
Automate data workflows and secure file transfers using RoboFTP, ensuring timely communication between retail platforms, vendors, and internal systems including our operational data store and enterprise data warehouse.
Manage scheduled system jobs via Robot Job Scheduling, including setup, monitoring, and recovery from job failures.
Work closely with stakeholders in merchandising, planning, finance, and store operations to gather requirements and deliver scalable system solutions.
Support and troubleshoot integrations between systems such as MMS, POS, Shopify, and ERP (MMS/JDA and NetSuite).
Maintain clear and up-to-date documentation for job schedules, system configurations, process flows, and integration points.
Participate in application upgrades, patches, testing, and the rollout of new retail technology initiatives.
Provide critical support during major retail events (promotions, seasonal launches, inventory counts, sales audit transaction updates, payment settlement, etc.).
Support and maintain NetSuite ERP, especially within order management, financials, inventory, and procurement.
Actively participate in the NetSuite implementation, including data migration, configuration, UAT, training, and post-go-live stabilization.
5 years of experience working with JDA/MMS in a retail environment.
Strong SQL Server skills, including performance tuning and complex query development.
Hands-on experience with RoboFTP for retail file transfers and automation.
Proficient in Power BI, particularly using stored procedures and data modeling for retail KPIs and dashboards.
2 years of NetSuite ERP experience, with exposure to core retail modules such as inventory, orders, and financials.
Demonstrated involvement in at least one NetSuite implementation project in a retail context.
Deep understanding of retail business processes, including:
- Merchandise planning and allocation
- Product lifecycle management
- Pricing and promotions
- Inventory reconciliation
Order fulfillment (Store, Ecommerce, BOPIS, etc.) including invoicing and credit memo processing
Strong documentation, communication, and cross-functional collaboration skills.
Ability to manage priorities across fast-paced retail cycles and deadlines.
Experience integrating NetSuite with retail systems (e.g., POS, ecommerce, WMS, PLM).
Familiarity with ETL/integration tools like Celigo, Boomi, or MuleSoft.
Scripting experience in SQL, PowerShell, Python, or similar for process automation.
Background supporting retail data governance, financial close processes, or sales audit reconciliation.