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.