Data Analyst, Data Migration Senior Associate

Grant Thornton (US); Downers Grove (IL); On-site; USD 72,000 - 95,000; Full time

Job summary

Grant Thornton in Downers Grove, IL seeks a Data Analyst, Data Migration Senior Associate with extensive data-migration experience to support ERP implementations and system modernization programs.

The role covers end-to-end migration lifecycle, ensuring data accuracy, completeness, and compliance while collaborating with business stakeholders, functional teams, and data migration consultants.

Qualifications

• Bachelor's degree as listed in the requirements.
• Five or more years experience as Data Analyst, Business Analyst, or Data Migration Analyst, incl. 3+ years on large-scale migrations.
• Strong knowledge of data mapping, transformation, reconciliation, and validation methodologies.
• Advanced SQL skills for large datasets analysis and manipulation.
• Experience with SAP S/4HANA, Oracle, Dayshape, Fieldglass, MS Dynamics or similar.
• Proficiency with Excel, Power BI, Tableau or similar reporting tools.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Analyze source-system data to identify completeness, accuracy, consistency, duplication, and missing values.
• Define cleansing, remediation, and enrichment activities before migration.
• Develop data-quality metrics and validation reports.
• Develop and maintain source-to-target mapping specs for master, transactional, and reference data.
• Define business rules, transformation logic, and data-conversion requirements.
• Collaborate with business SMEs to validate field definitions and update mappings.
• Support migration activities for ERP, financial, operational, and reporting systems.
• Review migration files and templates for load readiness.
• Troubleshoot data-conversion issues and load failures with technical teams.
• Participate in mock loads, test migrations, cutover planning, and production deployments.
• Validate migrated data through reconciliation, SIT, UAT, and post-production review.
• Investigate discrepancies and root causes of migration defects.
• Develop reconciliation reports and controls for business sign-off.
• Coordinate migration activities across stakeholders and data teams.
• Facilitate data-discovery workshops and requirements gathering sessions.
• Communicate migration risks and dependencies to leadership.
• Recommend improvements to data-quality controls and governance.

Skills

Data analysis

Analytical thinking

Communication

Problem solving

Education

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

Tools

SAP S/4HANA

Oracle

Dayshape

Fieldglass

Microsoft Dynamics

Excel

Power BI

Tableau

Job description

Job Description

Grant Thornton is seeking Data Analyst, Data Migration Senior Associate to join the team in Downers Grove, IL. We are seeking a highly analytical and detail-oriented Data Analyst with extensive data migration experience to support enterprise transformation initiatives, including ERP implementations and system modernization programs.

Job Description

Grant Thornton is seeking Data Analyst, Data Migration Senior Associate to join the team in Downers Grove, IL. We are seeking a highly analytical and detail-oriented Data Analyst with extensive data migration experience to support enterprise transformation initiatives, including ERP implementations and system modernization programs. The Data Analyst supports the end-to-end migration lifecycle, helping ensure business-critical data is accurate, complete, compliant, and ready for operational use. This role serves as a key liaison among business stakeholders, functional teams, technical resources, and data migration consultants.

Key Responsibilities

Data Analysis and Data Quality

• Analyze source-system data to identify completeness, accuracy, consistency, duplication, and missing-value issues.
• Define and execute data cleansing, remediation, and enrichment activities before migration.
• Develop and maintain data-quality metrics and validation reports.

Data Mapping and Transformation

• Develop and maintain source-to-target mapping specifications for master, transactional, and reference data.
• Define business rules, transformation logic, and data-conversion requirements.
• Partner with business subject matter experts to validate field definitions and update mapping specifications as business processes evolve.

Data Migration Execution

• Support migration activities for ERP, financial, operational, and reporting systems.
• Review migration files and templates for load readiness.
• Collaborate with technical teams to troubleshoot data-conversion issues and load failures.
• Participate in mock loads, test migrations, cutover planning, and production deployments.

Reconciliation and Testing

• Validate migrated data through source-to-target reconciliation, System Integration Testing, User Acceptance Testing, and post-production review.
• Investigate reconciliation discrepancies and identify the root causes of migration defects.
• Develop reconciliation reports and controls to support business review and sign-off.

Stakeholder Collaboration

• Coordinate migration activities across business owners, functional consultants, developers, project managers, and data migration consultants.
• Facilitate data-discovery workshops and requirements-gathering sessions.
• Communicate migration risks, issues, and dependencies to project leadership.
• Recommend improvements to data-quality controls, governance practices, and migration procedures.

Required Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Finance, Accounting, Business, or a related field.
• Five or more years of experience as a Data Analyst, Business Analyst, or Data Migration Analyst, including at least three years supporting large-scale data migration projects.
• Strong knowledge of data mapping, transformation, reconciliation, and validation methodologies.
• Advanced SQL skills with the ability to analyze and manipulate large datasets.
• Experience working with SAP S/4HANA, Oracle, Dayshape, Fieldglass, Microsoft Dynamics, or comparable platforms.
• Proficiency with Excel, Power BI, Tableau, or comparable reporting tools.
• Excellent analytical, problem-solving, and communication skills.

Preferred Qualifications

• Experience supporting SAP S/4HANA Public Cloud data migration projects.
• Knowledge of financial, billing, project accounting, customer, vendor, and master data structures.
• Experience with ETL and data-integration tools.
• Familiarity with Snowflake, Azure Data Factory, Informatica, SAP Migration Cockpit, or comparable technologies.
• Understanding of data governance, controls, and audit requirements.
• PMP, CBAP, SAP, or data-management certification preferred.

The base salary range for this position is between $72,000 and $95,000. Placement within the pay range is at Grant Thornton’s discretion, and it is based on multiple factors, including but not limited to, job-related knowledge/skills, experience, business needs, progression within the role, geographic location, and internal equity. At Grant Thornton, compensation decisions are dependent upon the facts and circumstances of each position and candidate.