ERP Systems Analyst
George J. Igel & Co., Inc. · Columbus, OH · 3 wk ago
On-siteInformation TechnologyFull-time
We need to output HTML fragment with headings for sections present: About the role (General Overview), Responsibilities, Qualifications, Knowledge, Skills, And Abilities (maybe combine as Skills). Also maybe Benefits, Pay, Schedule if present. The posting includes Hours: 7:00 a.m. to 4:00 p.m. (One (1) Hour Lunch); occasional work outside normal business hours may be required. That's schedule info. Also location and remote not allowed. But schedule section only if posting actually states them. It does state hours. So we can include a Schedule section with that info. Benefits? Not mentioned. Pay? Not mentioned. So omit those.
We need to not repeat job title as heading. Use
for sections present: About the role (General Overview), Responsibilities, Qualifications, Knowledge, Skills, And Abilities (maybe combine as Skills). Also maybe Benefits, Pay, Schedule if present. The posting includes Hours: 7:00 a.m. to 4:00 p.m. (One (1) Hour Lunch); occasional work outside normal business hours may be required. That's schedule info. Also location and remote not allowed. But schedule section only if posting actually states them. It does state hours. So we can include a Schedule section with that info. Benefits? Not mentioned. Pay? Not mentioned. So omit those.
We need to not repeat job title as heading. Use for each section heading. Use - for any list of duties/requirements/benefits. Use
for prose.
We must preserve all substantive info, not invent or summarize away detail. Remove boilerplate like EEO etc. There's none.
We need to include sections only when posting has real specific content. So we will have:
- About the role (or General Overview) -> use heading About the role? The instruction says use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we should use those exact headings. For the overview we can use About the role.
- Responsibilities
- Qualifications
- Skills (maybe combine Knowledge, Skills, And Abilities as Skills)
- Schedule
We need to ensure we don't create empty sections.
Now extract content.
About the role: The paragraph after "General Overview". It includes several sentences. We'll put that in
.
Responsibilities: There's a big list broken into subheadings: Current-State ERP Administration & Support, Reporting, Business Intelligence & Data, Legacy Systems & Integrations, ERP Migration & Data Readiness, Modern Integrations & Cloud Readiness, ERP Implementation & Vendor Coordination, Business & Technical Analysis. Each has bullet-like sentences (some are paragraphs). We need to turn into
- items. Probably each sentence that starts with a verb is a duty. We'll capture each bullet as
- . We need to preserve all substantive info; not summarizing. We'll break each line that ends with a period.
Let's extract responsibilities section text:
"Responsibilities Current-State ERP Administration & Support Serve as a primary technical resource for the Company’s Sage 300 ERP environment and related applications.Support Sage 300 modules including General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Inventory Control (IC), and other modules utilized by the Company.Maintain a strong working understanding of the Microsoft 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 appropriate 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 appropriate 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. Reporting, Business Intelligence & Data Develop, maintain, and improve financial, operational, and management reports using tools such as Crystal Reports, Sage Intelligence, Power BI, SQL, and other reporting technologies.Work directly with business stakeholders to understand reporting requirements and translate those requirements into accurate and useful reports, dashboards, queries, and data sets.Validate reporting logic and reconcile report results to source ERP data.Identify opportunities to automate recurring reporting and data-processing activities.Support the development of consistent data definitions, reporting standards, and data governance practices.Assist business users with understanding ERP data structures and determining the appropriate sources of information for reporting and analysis. Legacy Systems & Integrations Support, maintain, and troubleshoot integrations between Sage 300 and other Company systems.Maintain existing integrations such as EDI feeds, CRM connections, e-commerce interfaces, financial applications, operational systems, and other third-party platforms.Analyze data flows between systems and troubleshoot failed, incomplete, duplicated, or inaccurate transactions.Document system interfaces, source and destination fields, transformation logic, dependencies, schedules, and exception-handling processes.Work with internal IT resources and third-party vendors to improve the reliability and maintainability of existing integrations.Identify legacy customizations or integrations that may create operational risk or affect future ERP migration efforts. ERP Migration & Data Readiness Support the Company’s preparation for a future ERP replacement or modernization initiative.Extract large volumes of historical data from Sage 300, SQL Server, legacy databases, spreadsheets, and other business systems.Clean, normalize, validate, deduplicate, and transform data in preparation for migration.Develop repeatable ETL processes to move data into flat files, staging databases, integration platforms, or other migration environments.Analyze legacy ERP tables, relationships, fields, and business rules to understand how historical information is stored and used.Develop and maintain data mappings between legacy ERP structures and future ERP data models.Work with business stakeholders to establish data-retention requirements and determine which historical information should be migrated, archived, transformed, or retired.Perform reconciliation and validation activities to confirm that migrated data is complete and accurate.Assist with migration rehearsals, mock conversions, cutover planning, production conversion, and post-migration validation. Modern Integrations & Cloud Readiness Assist with developing integration requirements and technical specifications for future systems.Support cloud-based ERP applications and related data platforms as the Company modernizes its technology environment.Evaluate existing integrations and recommend whether they should be retained, redesigned, replaced, or eliminated as part of future ERP initiatives.Assist with establishing scalable integration and data-management practices that reduce dependence on one-off custom solutions. ERP Implementation & Vendor Coordination Serve as an internal technical liaison between the Company, ERP software vendors, consultants, and implementation partners.Provide implementation partners with accurate information regarding current systems, database structures, integrations, reports, business processes, customizations, and historical data.Participate in requirements-gathering sessions, system-design discussions, data-conversion workshops, integration meetings, testing activities, and implementation planning.Review technical recommendations from vendors and implementation partners and help evaluate their impact on existing Company systems and processes.Track technical issues, dependencies, risks, decisions, and outstanding implementation items.Assist with system configuration, testing, user acceptance testing, defect resolution, cutover activities, and post-go-live support.Help ensure knowledge developed by implementation partners is appropriately documented and transferred to internal Company resources. Business & Technical Analysis Meet with employees, managers, and department leaders to understand business processes, system requirements, challenges, and opportunities for improvement.Translate business requirements into clear technical requirements, data requirements, system changes, reports, integrations, or projects.Analyze current-state processes and recommend opportunities to improve efficiency, reliability, accuracy, and system utilization.Evaluate ERP-related requests based on business impact, technical complexity, dependencies, and long-term system strategy.Develop clear process, system, data-flow, interface, and technical documentation.Communicate technical concepts to both technical and non-technical audiences.Learn and adhere to all Company policies and procedures.Perform other duties as assigned. This list is non-exhaustive. Job responsibilities may vary based on operational needs and the instructions of the employee’s supervisor."
We need to split into list items. Each sentence ends with a period. We'll create
- for each sentence. However some sentences are long and contain multiple clauses but still one sentence. We'll keep as is.
We'll need to ensure we don't lose any content. Let's manually split.
I'll go through and create list items.
Current-State ERP Administration & Support:
1. Serve as a primary technical resource for the Company’s Sage 300 ERP environment and related applications.
2. Support Sage 300 modules including General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Inventory Control (IC), and other modules utilized by the Company.
3. Maintain a strong working understanding of the Microsoft SQL Server databases supporting Sage 300 and related business applications.
4. Write, review, and optimize SQL queries, stored procedures, views, and other database objects used for reporting, integrations, troubleshooting, and data analysis.
5. Monitor and improve database performance through appropriate indexing, query optimization, database maintenance, and performance troubleshooting.
6. Investigate and resolve ERP-related issues involving application functionality, data, database performance, interfaces, reports, and user workflows.
7. Assist with maintaining appropriate ERP security, user access, roles, permissions, and system controls.
8. Maintain accurate documentation of ERP configurations, customizations, integrations, databases, reports, interfaces, and business processes.
9. Coordinate with software vendors and third-party support providers to diagnose and resolve system issues.
Reporting, Business Intelligence & Data:
10. Develop, maintain, and improve financial, operational, and management reports using tools such as Crystal Reports, Sage Intelligence, Power BI, SQL, and other reporting technologies.
11. Work directly with business stakeholders to understand reporting requirements and translate those requirements into accurate and useful reports, dashboards, queries, and data sets.
12. Validate reporting logic and reconcile report results to source ERP data.
13. Identify opportunities to automate recurring reporting and data-processing activities.
14. Support the development of consistent data definitions, reporting standards, and data governance practices.
15. Assist business users with understanding ERP data structures and determining the appropriate sources of information for reporting and analysis.
Legacy Systems & Integrations:
16. Support, maintain, and troubleshoot integrations between Sage 300 and other Company systems.
17. Maintain existing integrations such as EDI feeds, CRM connections, e-commerce interfaces, financial applications, operational systems, and other third-party platforms.
18. Analyze data flows between systems and troubleshoot failed, incomplete, duplicated, or inaccurate transactions.
19. Document system interfaces, source and destination fields, transformation logic, dependencies, schedules, and exception-handling processes.
20. Work with internal IT resources and third-party vendors to improve the reliability and maintainability of existing integrations.
21. Identify legacy customizations or integrations that may create operational risk or affect future ERP migration efforts.
ERP Migration & Data Readiness:
22. Support the Company’s preparation for a future ERP replacement or modernization initiative.
23. Extract large volumes of historical data from Sage 300, SQL Server, legacy databases, spreadsheets, and other business systems.
24. Clean, normalize, validate, deduplicate, and transform data in preparation for migration.
25. Develop repeatable ETL processes to move data into flat files, staging databases, integration platforms, or other migration environments.
26. Analyze legacy ERP tables, relationships, fields, and business rules to understand how historical information is stored and used.
27. Develop and maintain data mappings between legacy ERP structures and future ERP data models.
28. Work with business stakeholders to establish data-retention requirements and determine which historical information should be migrated, archived, transformed, or retired.
29. Perform reconciliation and validation activities to confirm that migrated data is complete and accurate.
30. Assist with migration rehearsals, mock conversions, cutover planning, production conversion, and post-migration validation.
Modern Integrations & Cloud Readiness:
31. Assist with developing integration requirements and technical specifications for future systems.
32. Support cloud-based ERP applications and related data platforms as the Company modernizes its technology environment.
33. Evaluate existing integrations and recommend whether they should be retained, redesigned, replaced, or eliminated as part of future ERP initiatives.
34. Assist with establishing scalable integration and data-management practices that reduce dependence on one-off custom solutions.
ERP Implementation & Vendor Coordination:
35. Serve as an internal technical liaison between the Company, ERP software vendors, consultants, and implementation partners.
36. Provide implementation partners with accurate information regarding current systems, database structures, integrations, reports, business processes, customizations, and historical data.
37. Participate in requirements-gathering sessions,
- for any list of duties/requirements/benefits. Use
for prose. We must preserve all substantive info, not invent or summarize away detail. Remove boilerplate like EEO etc. There's none. We need to include sections only when posting has real specific content. So we will have: - About the role (or General Overview) -> use heading About the role? The instruction says use
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we should use those exact headings. For the overview we can use About the role. - Responsibilities - Qualifications - Skills (maybe combine Knowledge, Skills, And Abilities as Skills) - Schedule We need to ensure we don't create empty sections. Now extract content. About the role: The paragraph after "General Overview". It includes several sentences. We'll put that in
. Responsibilities: There's a big list broken into subheadings: Current-State ERP Administration & Support, Reporting, Business Intelligence & Data, Legacy Systems & Integrations, ERP Migration & Data Readiness, Modern Integrations & Cloud Readiness, ERP Implementation & Vendor Coordination, Business & Technical Analysis. Each has bullet-like sentences (some are paragraphs). We need to turn into
- items. Probably each sentence that starts with a verb is a duty. We'll capture each bullet as
- . We need to preserve all substantive info; not summarizing. We'll break each line that ends with a period. Let's extract responsibilities section text: "Responsibilities Current-State ERP Administration & Support Serve as a primary technical resource for the Company’s Sage 300 ERP environment and related applications.Support Sage 300 modules including General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Inventory Control (IC), and other modules utilized by the Company.Maintain a strong working understanding of the Microsoft 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 appropriate 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 appropriate 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. Reporting, Business Intelligence & Data Develop, maintain, and improve financial, operational, and management reports using tools such as Crystal Reports, Sage Intelligence, Power BI, SQL, and other reporting technologies.Work directly with business stakeholders to understand reporting requirements and translate those requirements into accurate and useful reports, dashboards, queries, and data sets.Validate reporting logic and reconcile report results to source ERP data.Identify opportunities to automate recurring reporting and data-processing activities.Support the development of consistent data definitions, reporting standards, and data governance practices.Assist business users with understanding ERP data structures and determining the appropriate sources of information for reporting and analysis. Legacy Systems & Integrations Support, maintain, and troubleshoot integrations between Sage 300 and other Company systems.Maintain existing integrations such as EDI feeds, CRM connections, e-commerce interfaces, financial applications, operational systems, and other third-party platforms.Analyze data flows between systems and troubleshoot failed, incomplete, duplicated, or inaccurate transactions.Document system interfaces, source and destination fields, transformation logic, dependencies, schedules, and exception-handling processes.Work with internal IT resources and third-party vendors to improve the reliability and maintainability of existing integrations.Identify legacy customizations or integrations that may create operational risk or affect future ERP migration efforts. ERP Migration & Data Readiness Support the Company’s preparation for a future ERP replacement or modernization initiative.Extract large volumes of historical data from Sage 300, SQL Server, legacy databases, spreadsheets, and other business systems.Clean, normalize, validate, deduplicate, and transform data in preparation for migration.Develop repeatable ETL processes to move data into flat files, staging databases, integration platforms, or other migration environments.Analyze legacy ERP tables, relationships, fields, and business rules to understand how historical information is stored and used.Develop and maintain data mappings between legacy ERP structures and future ERP data models.Work with business stakeholders to establish data-retention requirements and determine which historical information should be migrated, archived, transformed, or retired.Perform reconciliation and validation activities to confirm that migrated data is complete and accurate.Assist with migration rehearsals, mock conversions, cutover planning, production conversion, and post-migration validation. Modern Integrations & Cloud Readiness Assist with developing integration requirements and technical specifications for future systems.Support cloud-based ERP applications and related data platforms as the Company modernizes its technology environment.Evaluate existing integrations and recommend whether they should be retained, redesigned, replaced, or eliminated as part of future ERP initiatives.Assist with establishing scalable integration and data-management practices that reduce dependence on one-off custom solutions. ERP Implementation & Vendor Coordination Serve as an internal technical liaison between the Company, ERP software vendors, consultants, and implementation partners.Provide implementation partners with accurate information regarding current systems, database structures, integrations, reports, business processes, customizations, and historical data.Participate in requirements-gathering sessions, system-design discussions, data-conversion workshops, integration meetings, testing activities, and implementation planning.Review technical recommendations from vendors and implementation partners and help evaluate their impact on existing Company systems and processes.Track technical issues, dependencies, risks, decisions, and outstanding implementation items.Assist with system configuration, testing, user acceptance testing, defect resolution, cutover activities, and post-go-live support.Help ensure knowledge developed by implementation partners is appropriately documented and transferred to internal Company resources. Business & Technical Analysis Meet with employees, managers, and department leaders to understand business processes, system requirements, challenges, and opportunities for improvement.Translate business requirements into clear technical requirements, data requirements, system changes, reports, integrations, or projects.Analyze current-state processes and recommend opportunities to improve efficiency, reliability, accuracy, and system utilization.Evaluate ERP-related requests based on business impact, technical complexity, dependencies, and long-term system strategy.Develop clear process, system, data-flow, interface, and technical documentation.Communicate technical concepts to both technical and non-technical audiences.Learn and adhere to all Company policies and procedures.Perform other duties as assigned. This list is non-exhaustive. Job responsibilities may vary based on operational needs and the instructions of the employee’s supervisor." We need to split into list items. Each sentence ends with a period. We'll create
- for each sentence. However some sentences are long and contain multiple clauses but still one sentence. We'll keep as is. We'll need to ensure we don't lose any content. Let's manually split. I'll go through and create list items. Current-State ERP Administration & Support: 1. Serve as a primary technical resource for the Company’s Sage 300 ERP environment and related applications. 2. Support Sage 300 modules including General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Inventory Control (IC), and other modules utilized by the Company. 3. Maintain a strong working understanding of the Microsoft SQL Server databases supporting Sage 300 and related business applications. 4. Write, review, and optimize SQL queries, stored procedures, views, and other database objects used for reporting, integrations, troubleshooting, and data analysis. 5. Monitor and improve database performance through appropriate indexing, query optimization, database maintenance, and performance troubleshooting. 6. Investigate and resolve ERP-related issues involving application functionality, data, database performance, interfaces, reports, and user workflows. 7. Assist with maintaining appropriate ERP security, user access, roles, permissions, and system controls. 8. Maintain accurate documentation of ERP configurations, customizations, integrations, databases, reports, interfaces, and business processes. 9. Coordinate with software vendors and third-party support providers to diagnose and resolve system issues. Reporting, Business Intelligence & Data: 10. Develop, maintain, and improve financial, operational, and management reports using tools such as Crystal Reports, Sage Intelligence, Power BI, SQL, and other reporting technologies. 11. Work directly with business stakeholders to understand reporting requirements and translate those requirements into accurate and useful reports, dashboards, queries, and data sets. 12. Validate reporting logic and reconcile report results to source ERP data. 13. Identify opportunities to automate recurring reporting and data-processing activities. 14. Support the development of consistent data definitions, reporting standards, and data governance practices. 15. Assist business users with understanding ERP data structures and determining the appropriate sources of information for reporting and analysis. Legacy Systems & Integrations: 16. Support, maintain, and troubleshoot integrations between Sage 300 and other Company systems. 17. Maintain existing integrations such as EDI feeds, CRM connections, e-commerce interfaces, financial applications, operational systems, and other third-party platforms. 18. Analyze data flows between systems and troubleshoot failed, incomplete, duplicated, or inaccurate transactions. 19. Document system interfaces, source and destination fields, transformation logic, dependencies, schedules, and exception-handling processes. 20. Work with internal IT resources and third-party vendors to improve the reliability and maintainability of existing integrations. 21. Identify legacy customizations or integrations that may create operational risk or affect future ERP migration efforts. ERP Migration & Data Readiness: 22. Support the Company’s preparation for a future ERP replacement or modernization initiative. 23. Extract large volumes of historical data from Sage 300, SQL Server, legacy databases, spreadsheets, and other business systems. 24. Clean, normalize, validate, deduplicate, and transform data in preparation for migration. 25. Develop repeatable ETL processes to move data into flat files, staging databases, integration platforms, or other migration environments. 26. Analyze legacy ERP tables, relationships, fields, and business rules to understand how historical information is stored and used. 27. Develop and maintain data mappings between legacy ERP structures and future ERP data models. 28. Work with business stakeholders to establish data-retention requirements and determine which historical information should be migrated, archived, transformed, or retired. 29. Perform reconciliation and validation activities to confirm that migrated data is complete and accurate. 30. Assist with migration rehearsals, mock conversions, cutover planning, production conversion, and post-migration validation. Modern Integrations & Cloud Readiness: 31. Assist with developing integration requirements and technical specifications for future systems. 32. Support cloud-based ERP applications and related data platforms as the Company modernizes its technology environment. 33. Evaluate existing integrations and recommend whether they should be retained, redesigned, replaced, or eliminated as part of future ERP initiatives. 34. Assist with establishing scalable integration and data-management practices that reduce dependence on one-off custom solutions. ERP Implementation & Vendor Coordination: 35. Serve as an internal technical liaison between the Company, ERP software vendors, consultants, and implementation partners. 36. Provide implementation partners with accurate information regarding current systems, database structures, integrations, reports, business processes, customizations, and historical data. 37. Participate in requirements-gathering sessions,