ERP Systems Analyst

George J. Igel & Co., Inc.•Columbus, OH

9d•$94,000 - $154,000•Onsite

About The Position

The ERP Systems Analyst supports, maintains, and improves the company’s enterprise resource planning systems, with an immediate focus on Sage 300 Construction and Real Estate (Sage 300 CRE) and its supporting Microsoft SQL Server environment. The role provides technical support for ERP administration, Crystal Reports development and troubleshooting, reporting, data analysis, system integrations, issue resolution, and data integrity. A major focus is developing and maintaining accurate, useful Crystal Reports in collaboration with business users and ensuring report results can be reconciled to source systems. The analyst also supports preparation for a future ERP replacement or modernization. This includes extracting, cleansing, mapping, validating, and migrating data; documenting reporting and system requirements; supporting integrations and testing; and coordinating with ERP vendors and implementation partners. The position collaborates with Accounting, Operations, Estimating, Project Management, Human Resources, IT, and other business functions to understand requirements, resolve issues, and improve processes. This is a full-time, 100% in-office position at the company’s Columbus, Ohio office. The stated schedule is 7:00 a.m. to 4:00 p.m. with a one-hour lunch. Occasional work outside normal business hours may be required for maintenance, upgrades, or implementations. Remote and hybrid arrangements are not available. Relocation assistance is not provided, though it may be considered for a highly qualified candidate. The individual is expected to demonstrate Integrity, Gratitude, Excellence, and Leadership.

Requirements

Bachelor’s degree in Information Systems, Computer Science, Business Analytics, Accounting Information Systems, or a related field; equivalent professional experience may be considered.
Demonstrated experience developing, modifying, and troubleshooting Crystal Reports is required.
Ability to develop complex Crystal Reports using relational databases and multiple data sources is required.
Experience working with Microsoft SQL Server and writing SQL queries is required.
Experience with relational databases, schemas, tables, views, stored procedures, indexing, and query optimization.
Must be able and willing to work 100% in person at the company’s Columbus, Ohio office; the position is not eligible for remote or hybrid work.
Must successfully pass a pre-employment drug screening in accordance with company requirements.
Must be at least 18 years old.
Strong analytical, problem-solving, troubleshooting, and root-cause analysis skills.
Ability to communicate effectively with business stakeholders, technical staff, vendors, consultants, and implementation partners, and translate between business and technical requirements.
Strong documentation, organizational, and attention-to-detail skills, including for financial, operational, reporting, and migration data.
Ability to manage multiple priorities and work independently and collaboratively.
Ability to evaluate technical solutions for maintainability, scalability, security, and long-term supportability; learn new ERP, cloud, integration, and reporting technologies.

Nice To Haves

Three or more years of experience supporting ERP, financial, accounting, construction management, or enterprise business systems is preferred.
Hands-on experience supporting Sage 300 Construction and Real Estate (Sage 300 CRE) is strongly preferred.
Experience developing financial, accounting, operational, or project-management reports is 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 is strongly preferred.
ERP implementation or ERP migration experience is preferred.
Experience working with ERP vendors, consultants, or implementation partners is preferred.
Candidates outside the Columbus area may be considered; relocation assistance is not guaranteed but may be considered for a highly qualified candidate.

Responsibilities

Serve as a primary technical resource for Sage 300 CRE and related applications, modules, workflows, databases, and configuration.
Support Sage 300 CRE modules including GL, AR, AP, JC, and PR; troubleshoot ERP application, data, database, interface, report, and workflow issues.
Maintain and improve SQL Server databases supporting Sage 300 CRE and related applications, including writing and optimizing queries, stored procedures, views, and other database objects.
Monitor and improve database performance through indexing, query optimization, maintenance, and troubleshooting.
Assist with ERP security, user access, roles, permissions, and system controls; maintain documentation of configurations, customizations, databases, integrations, reports, interfaces, and processes.
Coordinate with software vendors and third-party support providers to diagnose and resolve issues.
Develop, modify, maintain, and troubleshoot complex Crystal Reports for financial, accounting, operational, project, and management reporting.
Gather reporting requirements from business stakeholders; analyze report data sources, relationships, formulas, parameters, grouping, calculations, sub-reports, and business logic.
Validate report logic and reconcile results with Sage 300 CRE and other source systems; troubleshoot performance, connection, and data-quality problems.
Organize report documentation, identify redundant or outdated reports, recommend improvements, and identify opportunities to automate recurring reporting and data-processing work.
Support Power BI, Sage Intelligence, SQL-based reporting tools, and other reporting or business intelligence technologies as appropriate; assist with data definitions, reporting standards, and governance.
Support and document integrations between Sage 300 CRE and other systems, including EDI feeds, CRM connections, financial applications, operational systems, and third-party platforms.
Analyze system data flows and troubleshoot failed, incomplete, duplicated, or inaccurate transactions; work with IT and vendors to improve integration reliability and maintainability.
Identify legacy customizations and integrations that could create operational risk or affect future ERP migration.
Support preparation for a future ERP replacement or modernization, including data extraction, cleansing, normalization, validation, deduplication, transformation, and migration.
Develop repeatable ETL processes and source-to-target data mappings; analyze legacy schemas, tables, relationships, fields, and business rules.
Identify reports and reporting requirements for future replacement or redesign; document critical report data sources, calculations, logic, and requirements.
Work with stakeholders on data retention decisions and determine which historical information should be migrated, archived, transformed, or retired.
Perform migration reconciliation and validation; assist with migration rehearsals, mock conversions, cutover planning, production conversion, and post-migration validation.
Assist with future integration requirements and technical specifications, cloud ERP and data-platform support, and recommendations to retain, redesign, replace, or eliminate existing integrations.
Serve as an internal technical liaison with ERP vendors, consultants, and implementation partners; provide accurate information about current systems, data, reports, integrations, processes, and customizations.
Participate in requirements gathering, system design, data-conversion and integration workshops, reporting sessions, testing, and implementation planning.
Review technical recommendations, track implementation issues and risks, assist with configuration, user acceptance testing, defect resolution, cutover, and post-go-live support, and help ensure knowledge transfer and documentation.
Meet with employees, managers, and department leaders to understand processes, requirements, reporting needs, challenges, and improvement opportunities.
Translate business needs into technical requirements, data requirements, system changes, reports, integrations, or projects; analyze processes and recommend improvements.
Develop process, system, data-flow, interface, report, and technical documentation; communicate technical concepts to technical and non-technical audiences.
Learn and follow company policies and procedures, perform other duties as assigned, and adapt responsibilities to operational needs and supervisor instructions.

Benefits

Comprehensive health insurance; employees pay a low portion of the insurance premium.
Dental, vision, short-term disability, long-term disability, and life insurance offered at no cost to the employee.
Incentive compensation.
401K match.
401K profit sharing.
Professional development.
Student loan repayment program.
Tuition assistance.
Paid vacation, sick time, and holidays.
Paid parental leave.