Oracle Retail Systems Analyst: Data, Debug & Deploy

Acestack; Boston (MA); On-site; USD 95,000 - 140,000; Full time

Job summary

Acestack in Boston seeks an Oracle Retail Product Analyst to provide expert RMS support (v16.x+), troubleshoot production issues, and analyze item setup, purchasing, pricing, inventory and invoice reconciliation.

Responsibilities include managing RMS modules (RMS, RPM, ReIM, ReSA, Allocation, RWMS, SIM), root-cause analysis, data accuracy across POS/Finance/Warehouse, and coordination with Oracle Support. Strong SQL/PLSQL, testing, and documentation skills required.

Qualifications

• Experience with Oracle Retail RMS and related modules.
• Strong data analysis and SQL scripting skills.
• Experience with system testing, UAT, and documentation.

Responsibilities

• Provide expert support for Oracle Retail RMS (v16.x or later), including troubleshooting and resolving production issues.
• Analyze, debug, and fix issues related to item setup, purchasing, pricing, inventory, and invoice reconciliation.
• Manage and support core Oracle Retail modules: RMS, RPM, ReIM, ReSA, Allocation, RWMS, and SIM.
• Perform root cause analysis for recurring system issues and implement preventive measures.
• Ensure data accuracy and consistency across integrated retail systems (POS, Finance, Warehouse, etc.).
• Monitor interfaces and data transfers, resolving integration failures (SOA, OIC, flat files).
• Coordinate with Oracle Support and integration partners for product defects, patches, and upgrades.
• Develop and execute SQL/PLSQL scripts for data correction and mass updates in collaboration with DBAs.
• Support system patching, upgrades, deployments, and functional testing activities.
• Create and maintain documentation on configurations, data mappings, and system interfaces.
• Participate in change requests, release management, and deployment processes.
• Conduct and document functional, regression, and integration testing for new releases and patches.
• Collaborate with business teams for UAT, system validation, and enhancements.
• Ensure compliance with IT governance, audit, and security standards for all system changes.
• Liaise with Merchandising, Finance, Supply Chain, and IT Operations to resolve business process and system issues.
• Provide ad-hoc data analysis and reporting support using SQL and standard RMS reports.
• Document known issues, workarounds, and SOPs to improve team efficiency.

Skills

SQL

PL/SQL

Data analysis

Job description

Acestack in Boston seeks an Oracle Retail Product Analyst to provide expert RMS support (v16.x+), troubleshoot production issues, and analyze item setup, purchasing, pricing, inventory and invoice reconciliation.

Responsibilities include managing RMS modules (RMS, RPM, ReIM, ReSA, Allocation, RWMS, SIM), root-cause analysis, data accuracy across POS/Finance/Warehouse, and coordination with Oracle Support. Strong SQL/PLSQL, testing, and documentation skills required.