Data Analyst, Data Migration Senior Associate

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.