ERP Analyst: SQL Reporting & Systems Administration

DataMasters; Springfield (MO); On-site; USD 70,000 - 90,000; Full time

Job summary

DataMasters seeks an ERP Analyst to maintain and operate the ERP system, including installation, patching, upgrades, and security administration. You will plan change management for integrated third‑party systems and develop user reports using SQL.

You’ll support users, coordinate training, and ensure scheduled Robot jobs run on time, while maintaining documentation and security across LX/MES/Touchpath environments.

Qualifications

• Bachelor’s degree or 4-5 years IT experience in a related field.
• Functional knowledge of ERP-LX and ability to support user requirements.
• Experience using SQL to develop reports and analyze data.
• Excellent interpersonal and written communication skills with end-users and consultants.
• Business acumen to interact with IT service providers for contracts and licensing.
• Strong problem solving, independent or team work ability, and learning aptitude.
• RPG programming is a plus.

Responsibilities

• Support Users’ requests and provide guidance on software functionality.
• Identify and schedule software training; coordinate with software support.
• Create ad hoc reports using SQL and extract data for validation.
• Maintain and refresh test environments; manage data elements like BOMs/pricing.
• Create and maintain LX/MES/Touchpath dashboard data and views.
• Maintain IDF objects, views, subsets, and sorts; back up IBM iSeries data.
• Schedule and monitor Robot jobs (daily, weekly, monthly, yearly) and distribute reports.
• Document procedures, data points, and scripts; coordinate off-hours support.

Skills

SQL reporting

Interpersonal communication

Critical thinking

Troubleshooting

Aptitude to learn

RPG programming

Education

Bachelor’s degree in computer science or related IT field

4-5 years of applicable IT experience

Tools

Infor LX 8.4.0

Crossroads MES

Touchpath WMS

ACT CRM

Compleo

Robot Scheduler

TL Ashford Barcode

Job description

DataMasters seeks an ERP Analyst to maintain and operate the ERP system, including installation, patching, upgrades, and security administration. You will plan change management for integrated third‑party systems and develop user reports using SQL.

You’ll support users, coordinate training, and ensure scheduled Robot jobs run on time, while maintaining documentation and security across LX/MES/Touchpath environments.