ERP Systems Analyst
- Compensation
- Not disclosed
- Location
- Columbus, Ohio, United States
- Work setup
- Onsite
- Seniority
- Not specified
- Employment
- Full time
- Experience
- Not specified
- Category
- Business analysis
- Posted
Skills
Must have
- 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, construction management, or enterprise business systems preferred.
- Hands-on experience supporting Sage 300 Construction and Real Estate (Sage 300 CRE) strongly preferred.
- Demonstrated experience developing, modifying, and troubleshooting Crystal Reports required.
- Ability to develop complex Crystal Reports utilizing relational databases and multiple data sources required.
- 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 financial, accounting, operational, or project-management reports strongly preferred.
- Experience with Power BI, Sage Intelligence, or other business intelligence platforms is beneficial but secondary to strong Crystal Reports experience.
- 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.
- Candidates outside the Columbus area may be considered. Relocation assistance is not guaranteed but may be considered for a highly qualified candidate.
- Must successfully pass a pre-employment drug screening in accordance with Company requirements.
- Must be at least 18 years old.
Full description
George J. Igel & Co., Inc.
ERP Systems Analyst
Reports to: IT Director
FLSA Status: Exempt
Hours: 7:00 a.m. to 4:00 p.m. (One (1) Hour Lunch); occasional work outside normal business hours may be required for system maintenance, upgrades, or implementations
Job Location: 3500 Alum Creek Drive, Columbus, OH 43207. This is a 100% in-office position. Remote and hybrid work arrangements are not available for this role. Candidates must be able to regularly report to the Columbus, Ohio office. George J. Igel & Co., Inc. does not provide relocation assistance for this position.
General Overview:
The ERP Systems Analyst is responsible for supporting, maintaining, and improving the Company’s enterprise resource planning systems, with an immediate focus on Sage 300 Construction and Real Estate (Sage 300 CRE) and our supporting Microsoft SQL Server environment. This position serves as a technical resource for ERP administration, Crystal Reports development and support, reporting, data analysis, system integrations, troubleshooting, and data integrity.
A significant responsibility of this position is developing, maintaining, troubleshooting, and improving the Company’s Crystal Reports environment. The ERP Systems Analyst will work closely with business users to understand reporting requirements, develop accurate financial and operational reports, troubleshoot existing reports, and ensure reporting data can be reconciled to source systems.
In addition to supporting the Company’s current ERP environment, the ERP Systems Analyst will play a key role in preparing for and supporting the Company’s eventual transition to a modern ERP platform. Responsibilities will include data extraction and cleansing, data mapping, integration planning, migration support, testing, documentation, and coordination with ERP vendors and implementation partners.
This position works closely with Accounting, Operations, Estimating, Project Management, Human Resources, IT, and other business functions to understand system requirements, resolve issues, improve processes, and ensure that enterprise systems effectively support the Company’s business needs.
This position requires regular, full-time, in-person attendance at the Company’s Columbus, Ohio office. It is not eligible for remote or hybrid work.
This individual should consistently demonstrate Integrity, Gratitude, Excellence, and Leadership.
Responsibilities:
Sage 300 CRE Administration & Support
- Serve as a primary technical resource for the Company’s Sage 300 CRE environment and related applications.
- Support the Sage 300 CRE modules, functionality, workflows, databases, and related applications utilized by the Company (GL, AR, AP, JC, and PR).