Senior Merchandising Systems Analyst

Overview :Senior Merchandising Systems Analyst (Quincy, MA)Jill Acquisition LLC seeks a Senior Merchandising Systems Analyst (Quincy, MA) to play an active and critical role in the successful implementation of high-impact, strategic, enterprise projects determined by J. Jill’s governance process. Serve as subject matter expert in architecting, designing, building, and maintaining two or more of J. JILL Retail Merchandising and Planning suite of applications including Oracle RMS (Retail Merchandising System), Oracle RESA (Retail Sales Audit), Oracle RTM (Retail Trade Management), Oracle REIM (Retail Invoice Match), Oracle SIM (Store Inventory Management), Oracle RPM (Retail Price Management), Oracle RIB (Retail Integration Bus), BY Allocation, and BY Enterprise planning. Lead business requirement analysis with the business partners, conduct design sessions with the cross-functional teams to implement new system enhancements or tools. Apply engineering techniques to troubleshoot and maintain WebLogic Application server for RESA, REIM, SIM, RPM and RIB application. Work closely with the Merchandising operations, Store Operations, Finance, Internal Audits, Sourcing compliance, Planning, Allocation teams to diagnose system related issues and identify systemic process gaps. Implement systemic solutions to resolve these issues. Debug and develop new Oracle software code components in computer programming languages Java, SQL, PL/SQL, Oracle ADF, Oracle Forms, Unix shell scripts, Microsoft batch scripts. Resolve application performance issues by tuning SQL queries, PL/SQL programs, reorganize Oracle RMS/SIM tables/indexes to enhance performance of batch/application/interface programs. Deploy critical system/security patch release from Oracle onto JJill Oracle application instances and run validation exercises using computer engineering methodologies. Retrofit new Oracle Patches (written in PL/SQL, Java, Unix scripts, Oracle forms and Pro*C) onto current version of the Oracle code in J. Jill production to ensure system upgrade will not break business functions. Monitor Retail integration bus (RIB) and address errors by utilizing diagnostics and monitoring tools. Liaison and collaborate very closely with IS cross functional teams such as Enterprise systems integration, technology Infrastructure, database administration, server administration, Retail systems, Enterprise data warehouse, business intelligence systems, supply chain systems, IT helpdesk for the day-to-day system-related issues. Participate in inventory, financial balance reconciliations across Enterprise applications like RMS, EP, General ledger, Warehouse Management system. Analyze the root cause of variances and work with business partners to take corrective action. Work with the sourcing compliance, finance, and planning team to ensure open to buy cost accuracy and implement systemic fixes for the identified issues. Develop process and Interfaces to upload business data files into JDA EP, JDA Allocations and Oracle Retail systems using system upload processes. Lead effort to perform impact analysis, design and implement systemic changes tied to new business initiatives. Supervise production deployment by participating in change approval exercise and ensure the validity of deployments. Local telecommuting permitted up to 3 days per week.

Responsibilities :Job Requirements:Requires a Bachelor’s degree in Computer Science, Computer Information Systems, Information Systems Engineering, or a related field and 1 year of experience in IS merchandising systems. Must have the following experience: ERP and planning software packages; defect management tools including Bugzilla and JIRA; collaboration tools including Confluence and Visio; writing SQL queries, programming in PL/SQL, Unix shell scripts; retail enterprise applications, including Oracle Retail Merchandising operations system, Oracle SIM (Store Inventory Management), Oracle RPM (Retail Price Management), Oracle RIB (Retail Integration Bus), Oracle RESA (Retail Sales Audit), Enterprise Planning (Oracle or JDA), and Allocation and Replenishment (Oracle or JDA); queue-based message integration like Oracle AQ, IBM WebSphere; and secure file transfer protocol (SFTP).THIS POSITION IS ELIGIBLE FOR THE EMPLOYEE REFERRAL PROGRAM.To apply, email resume to

Justine.MacDonald@jjill.com

. Reference code: SMSAJM.

#J-18808-Ljbffr