Back to search

Data Analyst - ERP

Hands-on Data Analyst to support an ERP transformation initiative, focusing on investigating, analyzing, reconciling, and improving data across multiple legacy systems for ERP migration and system decommissioning.

  • Chambersburg, Pennsylvania, United States
  • Contract
  • Posted Nov 17, 2026
INDUSTRYSoftware & InternetSaaS & Enterprise SoftwareData & Analytics

Responsibilities

  • Investigate and analyze data across multiple legacy systems to support ERP migration and decommissioning initiatives
  • Identify data quality issues, including duplicates, missing relationships, inconsistent values, and conflicting definitions
  • Perform data analysis, reconciliation, and cleanup using Excel, CSV extracts, and SQL queries
  • Analyze legacy data structures, tables, and relationships to understand how information is stored and used
  • Validate data across source systems and support pre- and post-conversion analysis
  • Document data findings, assumptions, source characteristics, and recommendations
  • Collaborate with business stakeholders and subject matter experts to clarify data definitions and identify authoritative data sources
  • Support data readiness and modeling activities associated with a Snowflake-based environment

Requirements

  • Bachelor's degree in Information Systems, Data Analytics, Computer Science, Business, or a related field
  • Experience in a manufacturing
  • Experience in a industrial enterprise

Nice to have: ERP implementations, Data migrations, Legacy system decommissioning, Snowflake, AI-assisted query generation, Data exploration tools

Skills

Microsoft ExcelAccessPower QueryPower BISQLExcelCSVSQLAccessPower QueryPower BISnowflake

More jobs nearby

Full description

Overview We are seeking a hands-on Data Analyst to support an ERP transformation initiative. This contract role will focus on investigating, analyzing, reconciling, and improving data across multiple legacy systems to support ERP migration and system decommissioning efforts. The ideal candidate is a self-starter who can independently navigate complex data environments, identify data quality issues, and translate findings into actionable recommendations. The role will work closely with Information Systems, Business Analysts, and business stakeholders to ensure data is understood, validated, and ready for migration to a modern data environment. Duties Investigate and analyze data across multiple legacy systems to support ERP migration and decommissioning initiatives. Identify data quality issues, including duplicates, missing relationships, inconsistent values, and conflicting definitions. Perform data analysis, reconciliation, and cleanup using Excel, CSV extracts, and SQL queries. Analyze legacy data structures, tables, and relationships to understand how information is stored and used. Validate data across source systems and support pre- and post-conversion analysis. Document data findings, assumptions, source characteristics, and recommendations. Collaborate with business stakeholders and subject matter experts to clarify data definitions and identify authoritative data sources. Support data readiness and modeling activities associated with a Snowflake-based environment. Required Skills 3+ years of hands-on data analysis experience in complex enterprise or legacy system environments. Advanced proficiency with Microsoft Excel and other data analysis tools such as Access, Power Query, or Power BI. Strong SQL skills for querying, analyzing, and validating data. Experience analyzing large datasets, data structures, and relationships across multiple systems. Strong analytical and problem-solving skills, including the ability to independently investigate unfamiliar datasets. Excellent documentation and communication skills, with the ability to explain findings to both technical and non-technical audiences. Ability to work effectively in evolving environments with changing priorities and ambiguous data requirements. Bachelor's degree in Information Systems, Data Analytics, Computer Science, Business, or a related field, or equivalent experience. Preferred Skills Experience supporting ERP implementations, data migrations, or legacy system decommissioning. Familiarity with Snowflake or other modern cloud-based data platforms. Exposure to AI-assisted query generation or data exploration tools. Experience working with multiple source systems where data definitions and ownership may be inconsistent. Background in manufacturing or other industrial enterprise environments.

Data Analyst - ERP at Lingatech Inc. | Referso Jobs