ERP Systems Analyst

Job Description

Job Description:\n\nGeorge J. Igel & Co., Inc.\n\nERP Systems Analyst\n\nReports to: IT Director FLSA Status: Exempt\nHours: 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 implementationsJob 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.\n \nGeneral Overview:\nThe ERP Systems Analyst is responsible for supporting, maintaining, and improving the Company’s enterprise resource planning systems, with an immediate focus on Sage 300 and its supporting Microsoft SQL Server environment. This position serves as a technical resource for ERP administration, reporting, data analysis, system integrations, troubleshooting, and data integrity.\nIn 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.\nThis 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.\nThis position requires regular, full-time, in-person attendance at the Company’s Columbus, Ohio office. It is not eligible for remote or hybrid work. \nThis individual should consistently demonstrate Integrity, Gratitude, Excellence, and Leadership.\n\nResponsibilities:\nCurrent-State ERP Administration & Support\n\nServe as a primary technical resource for the Company’s Sage 300 ERP environment and related applications.\nSupport Sage 300 modules including General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Inventory Control (IC), and other modules utilized by the Company.\nMaintain a strong working understanding of the Microsoft SQL Server databases supporting Sage 300 and related business applications.\nWrite, review, and optimize SQL queries, stored procedures, views, and other database objects used for reporting, integrations, troubleshooting, and data analysis.\nMonitor and improve database performance through appropriate indexing, query optimization, database maintenance, and performance troubleshooting.\nInvestigate and resolve ERP-related issues involving application functionality, data, database performance, interfaces, reports, and user workflows.\nAssist with maintaining appropriate ERP security, user access, roles, permissions, and system controls.\nMaintain accurate documentation of ERP configurations, customizations, integrations, databases, reports, interfaces, and business processes.\nCoordinate with software vendors and third-party support providers to diagnose and resolve system issues.\n\nReporting, Business Intelligence & Data\n\nDevelop, maintain, and improve financial, operational, and management reports using tools such as Crystal Reports, Sage Intelligence, Power BI, SQL, and other reporting technologies.\nWork directly with business stakeholders to understand reporting requirements and translate those requirements into accurate and useful reports, dashboards, queries, and data sets.\nValidate reporting logic and reconcile report results to source ERP data.\nIdentify opportunities to automate recurring reporting and data-processing activities.\nSupport the development of consistent data definitions, reporting standards, and data governance practices.\nAssist business users with understanding ERP data structures and determining the appropriate sources of information for reporting and analysis.\n\nLegacy Systems & Integrations\n\nSupport, maintain, and troubleshoot integrations between Sage 300 and other Company systems.\nMaintain existing integrations such as EDI feeds, CRM connections, e-commerce interfaces, financial applications, operational systems, and other third-party platforms.\nAnalyze data flows between systems and troubleshoot failed, incomplete, duplicated, or inaccurate transactions.\nDocument system interfaces, source and destination fields, transformation logic, dependencies, schedules, and exception-handling processes.\nWork with internal IT resources and third-party vendors to improve the reliability and maintainability of existing integrations.\nIdentify legacy customizations or integrations that may create operational risk or affect future ERP migration efforts.\n\nERP Migration & Data Readiness\n\nSupport the Company’s preparation for a future ERP replacement or modernization initiative.\nExtract large volumes of historical data from Sage 300, SQL Server, legacy databases, spreadsheets, and other business systems.\nClean, normalize, validate, deduplicate, and transform data in preparation for migration.\nDevelop repeatable ETL processes to move data into flat files, staging databases, integration platforms, or other migration environments.\nAnalyze legacy ERP tables, relationships, fields, and business rules to understand how historical information is stored and used.\nDevelop and maintain data mappings between legacy ERP structures and future ERP data models.\nWork with business stakeholders to establish data-retention requirements and determine which historical information should be migrated, archived, transformed, or retired.\nPerform reconciliation and validation activities to confirm that migrated data is complete and accurate.\nAssist with migration rehearsals, mock conversions, cutover planning, production conversion, and post-migration validation.\n\nModern Integrations & Cloud Readiness\n\nAssist with developing integration requirements and technical specifications for future systems.\nSupport cloud-based ERP applications and related data platforms as the Company modernizes its technology environment.\nEvaluate existing integrations and recommend whether they should be retained, redesigned, replaced, or eliminated as part of future ERP initiatives.\nAssist with establishing scalable integration and data-management practices that reduce dependence on one-off custom solutions.\n\nERP Implementation & Vendor Coordination\n\nServe as an internal technical liaison between the Company, ERP software vendors, consultants, and implementation partners.\nProvide implementation partners with accurate information regarding current systems, database structures, integrations, reports, business processes, customizations, and historical data.\nParticipate in requirements-gathering sessions, system-design discussions, data-conversion workshops, integration meetings, testing activities, and implementation planning.\nReview technical recommendations from vendors and implementation partners and help evaluate their impact on existing Company systems and processes.\nTrack technical issues, dependencies, risks, decisions, and outstanding implementation items.\nAssist with system configuration, testing, user acceptance testing, defect resolution, cutover activities, and post-go-live support.\nHelp ensure knowledge developed by implementation partners is appropriately documented and transferred to internal Company resources.\n\nBusiness & Technical Analysis\n\nMeet with employees, managers, and department leaders to understand business processes, system requirements, challenges, and opportunities for improvement.\nTranslate business requirements into clear technical requirements, data requirements, system changes, reports, integrations, or projects.\nAnalyze current-state processes and recommend opportunities to improve efficiency, reliability, accuracy, and system utilization.\nEvaluate ERP-related requests based on business impact, technical complexity, dependencies, and long-term system strategy.\nDevelop clear process, system, data-flow, interface, and technical documentation.\nCommunicate technical concepts to both technical and non-technical audiences.\nLearn and adhere to all Company policies and procedures.\nPerform other duties as assigned.\n\nThis list is non-exhaustive. Job responsibilities may vary based on operational needs and the instructions of the employee’s supervisor.\n\nQualifications:\n\nBachelor’s degree in Information Systems, Computer Science, Business Analytics, Accounting Information Systems, or a related field; equivalent professional experience may be considered.\nThree (3) or more years of experience supporting ERP, financial, accounting, or enterprise business systems preferred.\nHands-on experience with Sage 300 strongly preferred.\nExperience working with Microsoft SQL Server and writing SQL queries required.\nExperience with relational databases, database schemas, tables, views, stored procedures, indexing, and query optimization.\nExperience developing or supporting reports using Crystal Reports, Sage Intelligence, Power BI, SQL-based reporting tools, or similar technologies.\nExperience supporting integrations between ERP systems and third-party applications.\nExperience with ETL, data conversion, data migration, or large-scale data transformation strongly preferred.\nERP implementation or ERP migration experience preferred.\nExperience working with ERP vendors, consultants, or implementation partners preferred.\nMust 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.\nCandidates are responsible for their own relocation, if applicable. The Company does not provide relocation assistance for this position.\nMust successfully pass a pre-employment drug screening. (George J. Igel & Co., Inc. is a SUPR Drug-Free Workplace and tests for marijuana)\nMust be willing to sign a confidentiality agreement upon hire\nMust maintain an MVR (Motor Vehicle Record) that meets the Company’s eligibility requirements\nMust be at least 18 years old.\n\nKnowledge, Skills, and Abilities:\nSage 300 & Current Environment\n\nStrong knowledge of Sage 300 architecture, data structures, modules, configuration, and reporting.\nStrong understanding of Microsoft SQL Server administration and relational database concepts.\nAbility to write complex SQL queries and troubleshoot data-related issues.\nKnowledge of database indexing, query execution, performance tuning, and database maintenance practices.\nUnderstanding of core ERP and accounting concepts, including General Ledger, Accounts Payable, Accounts Receivable, inventory, purchasing, and related transaction flows.\nAbility to develop and maintain financial and operational reports using Crystal Reports, Sage Intelligence, Power BI, or similar tools.\nAbility to understand, troubleshoot, and document legacy system integrations and customizations.\n\nData Migration & Future ERP Readiness\n\nStrong understanding of ETL concepts and techniques for extracting, transforming, validating, and loading large volumes of data.\nAbility to analyze legacy database schemas and understand relationships between ERP tables, transactions, master data, and historical records.\nAbility to develop detailed source-to-target data mappings for ERP migration.\nStrong understanding of data cleansing, normalization, deduplication, reconciliation, and validation techniques.\nFamiliarity with staging databases, flat-file formats, data-import templates, and migration utilities.\nAbility to identify data-quality issues and work with business stakeholders to determine appropriate corrective action.\n\nIntegration & Technical Skills\n\nAbility to read and interpret technical documentation.\nAbility to understand end-to-end system and data flows across multiple applications.\nStrong technical troubleshooting and root-cause analysis skills.\nAbility to evaluate technical solutions with consideration for maintainability, scalability, security, and long-term supportability.\n\nBusiness & Project Skills\n\nStrong analytical and problem-solving skills with the ability to break down complex technical and business problems into understandable components.\nAbility to communicate effectively with employees, managers, department leaders, technical staff, vendors, consultants, and implementation partners.\nAbility to translate between business requirements and technical requirements.\nStrong documentation skills, including the ability to create system diagrams, process maps, data mappings, integration documentation, technical requirements, and testing documentation.\nAbility to manage multiple priorities and maintain accurate, organized, and up-to-date technical documentation.\nStrong attention to detail, particularly when working with financial, operational, and migration data.\nAbility to work effectively both independently and collaboratively with business stakeholders and IT resources.\nAbility to coordinate activities and follow-up items with external vendors and implementation partners.\nIntellectual curiosity and a willingness to develop a detailed understanding of how business processes, systems, and data interact.\nAbility to learn new ERP platforms, cloud technologies, integration technologies, and business processes as the Company’s technology environment evolves.\nAbility to travel to and from the primary workplace and occasionally to other Company locations or job sites as needed.\n\nIgel Difference – Our Benefits Package*\n\nComprehensive Health Insurance\n\nEmployees pay a low portion of their insurance premium\n\nDental, Vision, Short Term Disability, Long Term Disability, and Life insurance are offered at no cost to the employee\nIncentive Compensation\n401K Match\n401K Profit Sharing\nProfessional Development\nStudent Loan Repayment Program\nTuition Assistance\nPaid Vacation, Sick Time and Holidays\nPaid Parental Leave\n\n*This list of benefits is intended to serve only as a representation of current benefit offerings. The Company reserves the right to modify benefit offerings at any time.\n\nEqual Opportunity Employer