ERP & SQL Specialist: Data-Driven Ops Support

Sonance; San Clemente (CA); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Sonance is seeking an ERP Support Specialist to maintain and support our PeopleSoft ERP environment. You will use SQL skills to strengthen data-driven decision making and support day-to-day user needs across the company.

This is a hands-on role at the intersection of data, systems, and people. You will write and optimize SQL, troubleshoot PeopleSoft and ERP issues for users, and partner with supply chain, inventory, and procurement teams to keep operational workflows running smoothly.

Qualifications

• Experience developing and optimizing queries and stored procedures in SQL.
• Exposure to ERP support, including familiarity with supply chain and inventory management modules.
• Foundational experience creating and managing stored procedures that support business processes and data automation.
• Strong analytical and problem-solving ability with attention to detail.
• Excellent communication, able to work with technical and non-technical stakeholders.

Responsibilities

• Develop and optimize SQL queries, functions, and stored procedures to support data analysis, reporting, and process automation.
• Provide ERP user support, addressing functional issues, troubleshooting errors, and keeping workflows running across ERP modules.
• Collaborate with supply chain, inventory, and procurement teams to understand requirements and implement ERP solutions that improve efficiency.
• Maintain data quality, security, and accuracy within ERP and inventory systems.
• Support system maintenance, upgrades, and patches for ERP and inventory systems to sustain performance and user satisfaction.
• Provide ongoing support to ERP users, ensuring they understand system functionality and can perform tasks efficiently.
• Stay current on SQL and ERP best practices, and growth in ERP/data platforms.

Skills

SQL Development

ERP Support

Stored Procedures

Analytical Skills

Communication

Education

Bachelor's degree or equivalent

Tools

PeopleSoft

Job description

Sonance is seeking an ERP Support Specialist to maintain and support our PeopleSoft ERP environment. You will use SQL skills to strengthen data-driven decision making and support day-to-day user needs across the company.

This is a hands-on role at the intersection of data, systems, and people. You will write and optimize SQL, troubleshoot PeopleSoft and ERP issues for users, and partner with supply chain, inventory, and procurement teams to keep operational workflows running smoothly.