Senior Retail System Analyst

About The Role

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.

Key Responsibilities

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

Required Skills & Qualifications

• 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 allocationProduct lifecycle managementPricing and promotionsInventory 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.

Preferred Qualifications

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