IT ERP M&A Data Migration Technical Manager

Position Overview

Woolpert is hiring an IT ERP M&A Data Migration Technical Manager to join our dynamic Corporate Applications. This position reports to the Senior Director, Corporate Applications. This role is accountable for leading and executing ERP data migrations for companies acquired by Woolpert in support of the firm’s growth strategy. This role is a hands-on technical leadership position within the Corporate Applications team, responsible for defining migration strategy, leading the IT data migration team, and designing and executing enterprise-wide data migration and ETL processes.

This role is critical to the successful integration of acquired companies into Microsoft Dynamics 365 Finance & Operations (F&O) and Customer Engagement (CE) by ensuring accurate, timely, and auditable conversion of legacy data into Woolpert’s ERP ecosystem. The position requires a balance of people leadership and deep hands‑on technical execution, with direct involvement in complex data extraction, transformation, loading, reconciliation, and validation across global legal entities. Strong SQL expertise, data mapping, and validation experience are required to support complex financial, multicurrency, and operational datasets across diverse legal structures.

We are unable to provide visa sponsorship for this position.  Applicants must already possess work authorization in the country the job is located.

What You Will Do:

Leadership & Strategy

• Own and lead the ERP Data Migration workstream within Woolpert’s overall M&A integration program.
• Define and execute end‑to‑end data migration strategies for complex ERP integrations following acquisitions.
• Partner closely with the M&A Integration Director, Corporate Applications leadership, Business Process Owners, and acquisition stakeholders to define data requirements, timelines, risks, and dependencies.
• Lead and manage a blended team of approximately 10 employees and contractors, supporting multiple parallel ERP migrations globally.
• Drive continuous improvement, automation, and efficiency across migration and ETL processes.

Data Migration & ETL Execution

• Design, build, and oversee data extraction, transformation, and loading (ETL) processes from legacy systems into Microsoft Dynamics 365 F&O and CE.
• Lead data mapping and conversion for master data and historical transactional data, including complex financial, operational, and multicurrency datasets.
• Ensure accurate integration with downstream and upstream systems (e.g., Dayforce and other enterprise platforms).
• Execute mock conversions, cutover planning, and final production migrations with a strong focus on accuracy and auditability.
• Own data reconciliation, validation, and issue resolution between source systems and target ERP.

Data Quality, Governance & Validation

• Ensure the accuracy, completeness, and integrity of migrated data through robust validation, testing, and reconciliation processes.
• Identify and resolve data quality issues, inconsistencies, gaps, and anomalies prior to migration.
• Design and implement error handling and rollback strategies to mitigate migration risk.
• Maintain comprehensive documentation covering mappings, transformation logic, validation results, and operational procedures.

Architecture & Continuous Improvement

• Own the architecture and design of ERP data migration solutions across all M&A activ