ERP Systems Analyst: Sage 300, SQL & Data Migration

George J. Igel & Co; Columbus (OH); On-site; USD 70,000 - 90,000; Full time

Job summary

George J. Igel & Co, Inc. is seeking an ERP Systems Analyst to support and optimize our Sage 300 ERP environment and data architecture in Columbus, OH. You will partner with Accounting, IT, and operations to ensure accurate reporting and smooth data flows.

The role emphasizes ERP administration, SQL reporting, data migration readiness, and collaboration with vendors and internal teams. This is a full-time, in-office position with no remote option.

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Business Analytics, Accounting Information Systems, or a related field; equivalent professional experience may be considered.
• Three (3) or more years of experience supporting ERP, financial, accounting, or enterprise business systems preferred.
• Hands-on experience with Sage 300 strongly preferred.
• Experience working with Microsoft SQL Server and writing SQL queries required.
• Experience with relational databases, database schemas, tables, views, stored procedures, indexing, and query optimization.
• Experience developing or supporting reports using Crystal Reports, Sage Intelligence, Power BI, SQL-based reporting tools, or similar technologies.
• Experience supporting integrations between ERP systems and third-party applications.
• Experience with ETL, data conversion, data migration, or large-scale data transformation strongly preferred.
• ERP implementation or ERP migration experience preferred.
• Experience working with ERP vendors, consultants, or implementation partners preferred.
• Must be able and willing to work 100% in person at the Company’s Columbus, Ohio office. This position is not eligible for remote or hybrid work.

Responsibilities

• Serve as a primary technical resource for Sage 300 ERP environment and related applications.
• Support Sage 300 modules including GL, AR, AP, IC, and other modules utilized by the Company.
• Maintain SQL Server databases supporting Sage 300 and related business applications.
• Write, review, and optimize SQL queries, stored procedures, views, and other database objects used for reporting, integrations, troubleshooting, and data analysis.
• Monitor and improve database performance through indexing, query optimization, database maintenance, and performance troubleshooting.
• Investigate and resolve ERP-related issues involving application functionality, data, database performance, interfaces, reports, and user workflows.
• Assist with maintaining ERP security, user access, roles, permissions, and system controls.
• Maintain accurate documentation of ERP configurations, customizations, integrations, databases, reports, interfaces, and business processes.
• Coordinate with software vendors and third-party support providers to diagnose and resolve system issues.

Skills

Sage 300

SQL Server

Data analysis

Reporting

ETL

Education

Bachelor’s degree in Information Systems, CS, or related field

Tools

Crystal Reports

Power BI

Sage Intelligence

SQL Server

Job description

George J. Igel & Co, Inc. is seeking an ERP Systems Analyst to support and optimize our Sage 300 ERP environment and data architecture in Columbus, OH. You will partner with Accounting, IT, and operations to ensure accurate reporting and smooth data flows.

The role emphasizes ERP administration, SQL reporting, data migration readiness, and collaboration with vendors and internal teams. This is a full-time, in-office position with no remote option.