Data Analyst - ERP

LingaTech

Chambersburg (Franklin County)

On-site

USD 55,000 - 96,000

Full time

7 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

LingaTech seeks a hands-on Data Analyst to support an ERP transformation initiative. The role focuses on investigating, reconciling, and cleaning data across legacy systems to enable migration and decommissioning.

The ideal candidate will navigate complex data environments, identify quality issues, and produce actionable insights for stakeholders, with experience in Excel, SQL, and Snowflake-ready data modeling.

Qualifications

  • 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.

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.

Skills

SQL
Excel
Data analysis
Power BI
Documentation
Communication

Education

Bachelor's degree in Information Systems, Data Analytics, Computer Science, Business, or related field

Tools

Snowflake

Job description

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

Princeton IT Services, Inc • Trenton (NJ)

Hybrid
USD 55,000 - 96,000
Product Data Analyst
Product Data Analyst

Compunnel Inc. • Texas

On-site
USD 90,000 - 120,000
Senior ERP Data Analyst
Senior ERP Data Analyst

Versique Executive, Professional & Interim Recruiting • Saint Paul (MN)

Hybrid
USD 90,000 - 120,000
Medical insurance
Dental insurance
Vision insurance
+7
Data Quality Engineer
Data Quality Engineer

Vedan Technologies • Connecticut

On-site
USD 90,000 - 120,000
Data Analyst
Data Analyst

Insight Global (United States) • United States

On-site
USD 70,000 - 110,000
ERP Data Analyst - Migration & Data Quality Specialist
ERP Data Analyst - Migration & Data Quality Specialist

LingaTech • Chambersburg

On-site
USD 55,000 - 96,000
Systems Analyst
Systems Analyst

Compunnel Inc. • Smithfield (RI)

On-site
USD 90,000 - 120,000
Data and Analytics Engineer
Data and Analytics Engineer

Arcadian Infracom • St. Louis (MO)

On-site
USD 80,000 - 110,000
ERP Data Migration Business Analyst
ERP Data Migration Business Analyst

AppleOne Employment Services • United States

On-site
USD 75,000 - 90,000
Data Analyst (SAP)
Data Analyst (SAP)

Insight Global (United States) • Nashville (TN)

On-site
USD 55,000 - 96,000