IT ERP M&A Data Migration Technical Manager

Position Overview

Woolpert, a global leader in architecture, engineering, and geospatial services, is hiring an IT ERP M&A Data Migration Technical Manager for its Corporate Applications team. The role reports to the Senior Director, Corporate Applications and is responsible for leading and executing ERP data migrations for companies acquired by Woolpert. This hands‑on technical leadership position involves defining migration strategy, managing the data migration team, and designing and executing enterprise‑wide data migration and ETL processes to integrate acquired businesses into Microsoft Dynamics 365 Finance & Operations (F&O) and Customer Engagement (CE).

• Own and lead the ERP Data Migration workstream within Woolpert’s 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.

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

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

• Own the architecture and design of ERP data migration solutions across all M&A activity.
• Reduce migration cycle time through innovative tools, automation, and repeatable frameworks.
• Continuously refine and evolve ETL processes to improve quality, scalability, and efficiency.

• Bachelor’s degree in Computer Science, Information Technology, Mathematics, or a related field, or equivalent experience.
• Proven experience in managing/leading teams and delivering full‑lifecycle ERP implementations.
• 10+ years of experience working with data migrations for complex ERP implementations, preferably in M&A environments.
• 7+ years of hands‑on experience with Microsoft Dynamics 365 Finance & Operations.
• 10+ years of demonstrated expertise in SQL.
• 10+ years of experience in data analysis, conversions, source‑to‑target mappings, testing, and operational support.

• Advanced proficiency in SQL, including queries, scripting, stored procedures, and performance tuning.
• Extensive experience with ETL tools and ERP migration platforms such as Azure Data Factory (ADF), DMF/DIXF, Kingsway Soft (SSIS), eOne Smart Connect, TIBCO Scribe, or equivalent.
• Strong data analysis and transformation skills using SQL, Excel, and ETL platforms.
• Experience with multicurrency financial data and financial reconciliation across multiple currencies.
• Familiarity with Azure, Dataverse, Power Platform, Power BI, and Azure Dev Ops is preferred.

• Demonstrated ability to manage, mentor, and coach technical and functional data migration teams.
• Strong stakeholder management skills with the ability to communicate…