IT ERP M&A Data Migration Technical Manager
Woolpert, Atlanta, GA, United States
We seek to move the world forward through innovative thinking. Woolpert is an award-winning, global leader in architecture, engineering, and geospatial services. We blend design excellence with cutting‑edge technology to deliver exceptional client value. Our team is passionate about their work and committed to building the next generation of industry leaders, and as a certified Great Place to Work, Woolpert embraces progress and innovation to create limitless opportunities for career growth.
We are unable to provide visa sponsorship for this position. Applicants must already possess work authorization in the country the job is located.
Position Overview
IT ERP M&A Data Migration Technical Manager – responsible for leading and executing ERP data migrations for companies acquired by Woolpert. This role, within Corporate Applications, defines migration strategy, leads the IT data migration team, and designs and executes enterprise‑wide data migration and ETL processes to support integration into Microsoft Dynamics 365 Finance & Operations and Customer Engagement.
Leadership & Strategy
Own and lead the ERP Data Migration workstream within Woolpert’s M&A integration program.
Define and execute end‑to‑end migration strategies for complex ERP integrations following acquisitions.
Partner closely with 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 processes from legacy systems into 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.
Execute mock conversions, cut‑over 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.
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 activity.
Reduce migration cycle time through innovative tools, automation, and repeatable frameworks.
Continuously refine and evolve ETL processes to improve quality, scalability, and efficiency.
Education & Experience
Bachelor’s degree in Computer Science, Information Technology, Mathematics, or related field, or equivalent experience.
Proven experience in managing and leading teams and delivering full‑lifecycle ERP implementations.
10+ years of experience working with complex ERP data migrations, preferably in M&A environments.
7+ years of hands‑on experience with Dynamics 365 Finance & Operations, deep knowledge of data entities and structures.
10+ years of demonstrated expertise in SQL, including queries, scripting, and stored procedures.
10+ years of experience in data analysis, source‑to‑target mappings, testing, and operational support.
Technical Expertise
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, DMF/DIXF, KingswaySoft (SSIS), eOne SmartConnect, TIBCO Scribe, or equivalent tools.
Strong data analysis and transformation skills using SQL, Excel, and ETL platforms.
Experience with multicurrency financial data, including general ledger structures, historical exchange rates, and financial reconciliation.
Familiarity with Azure, Dataverse, Power Platform, Power BI, and Azure DevOps is preferred.
Leadership & Communication
Demonstrated ability to manage, mentor, and coach technical and functional data migration teams.
Strong stakeholder management skills with ability to communicate effectively across technical and business audiences.
Excellent written and verbal communication skills with ability to present complex concepts clearly and concisely.
Proven ability to operate in a fast‑paced, deadline‑driven M&A environment.
Strong interpersonal skills in verbal and written communication with a focus on clarity and precision.
Core Competencies
Strong analytical and problem‑solving skills with exceptional attention to detail.
Ability to evaluate complex datasets, reconcile discrepancies, and translate data into actionable insights.
Adaptability and resourcefulness in dynamic, high‑change environments.
Strong business acumen with understanding of how data migration impacts financial and operational outcomes.
Technical Skills Summary
Microsoft Dynamics 365 Finance & Operations and Customer Engagement
SQL Server / SQL Management Studio
ETL & Migration Tools (ADF, DMF/DIXF, SSIS/KingswaySoft, Scribe, SmartConnect)
Azure DevOps
Microsoft Excel
Power BI
Data mapping, automated testing, validation, and reconciliation tools
Benefits You Will Love
Freedom to Work program: set your own schedule and location (as appropriate).
Principal program: earn opportunity to become an owner of the firm.
Flexible paid time off/vacation: take time off when it makes sense for you and your team.
Career development: explore a wide range of learning and growth opportunities within and across industries.
Health, life, vision, and dental insurance: cover all your medical bases.
Paid sick time, retirement plan, fitness reimbursement, pet insurance, identity protection, technology stipend, employee assistance program, and more.
Base pay offered may vary depending on job‑related knowledge, skills, and experience.
Pay Range
$130,000 - $145,000 USD
Woolpert is an equal‑opportunity employer. Woolpert is committed to the full inclusion of all individuals. We recruit, train, compensate, and promote regardless of race, religion, color, national origin, sex, disability, age, veteran status, and other protected status as required by applicable law.
#J-18808-Ljbffr
We are unable to provide visa sponsorship for this position. Applicants must already possess work authorization in the country the job is located.
Position Overview
IT ERP M&A Data Migration Technical Manager – responsible for leading and executing ERP data migrations for companies acquired by Woolpert. This role, within Corporate Applications, defines migration strategy, leads the IT data migration team, and designs and executes enterprise‑wide data migration and ETL processes to support integration into Microsoft Dynamics 365 Finance & Operations and Customer Engagement.
Leadership & Strategy
Own and lead the ERP Data Migration workstream within Woolpert’s M&A integration program.
Define and execute end‑to‑end migration strategies for complex ERP integrations following acquisitions.
Partner closely with 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 processes from legacy systems into 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.
Execute mock conversions, cut‑over 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.
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 activity.
Reduce migration cycle time through innovative tools, automation, and repeatable frameworks.
Continuously refine and evolve ETL processes to improve quality, scalability, and efficiency.
Education & Experience
Bachelor’s degree in Computer Science, Information Technology, Mathematics, or related field, or equivalent experience.
Proven experience in managing and leading teams and delivering full‑lifecycle ERP implementations.
10+ years of experience working with complex ERP data migrations, preferably in M&A environments.
7+ years of hands‑on experience with Dynamics 365 Finance & Operations, deep knowledge of data entities and structures.
10+ years of demonstrated expertise in SQL, including queries, scripting, and stored procedures.
10+ years of experience in data analysis, source‑to‑target mappings, testing, and operational support.
Technical Expertise
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, DMF/DIXF, KingswaySoft (SSIS), eOne SmartConnect, TIBCO Scribe, or equivalent tools.
Strong data analysis and transformation skills using SQL, Excel, and ETL platforms.
Experience with multicurrency financial data, including general ledger structures, historical exchange rates, and financial reconciliation.
Familiarity with Azure, Dataverse, Power Platform, Power BI, and Azure DevOps is preferred.
Leadership & Communication
Demonstrated ability to manage, mentor, and coach technical and functional data migration teams.
Strong stakeholder management skills with ability to communicate effectively across technical and business audiences.
Excellent written and verbal communication skills with ability to present complex concepts clearly and concisely.
Proven ability to operate in a fast‑paced, deadline‑driven M&A environment.
Strong interpersonal skills in verbal and written communication with a focus on clarity and precision.
Core Competencies
Strong analytical and problem‑solving skills with exceptional attention to detail.
Ability to evaluate complex datasets, reconcile discrepancies, and translate data into actionable insights.
Adaptability and resourcefulness in dynamic, high‑change environments.
Strong business acumen with understanding of how data migration impacts financial and operational outcomes.
Technical Skills Summary
Microsoft Dynamics 365 Finance & Operations and Customer Engagement
SQL Server / SQL Management Studio
ETL & Migration Tools (ADF, DMF/DIXF, SSIS/KingswaySoft, Scribe, SmartConnect)
Azure DevOps
Microsoft Excel
Power BI
Data mapping, automated testing, validation, and reconciliation tools
Benefits You Will Love
Freedom to Work program: set your own schedule and location (as appropriate).
Principal program: earn opportunity to become an owner of the firm.
Flexible paid time off/vacation: take time off when it makes sense for you and your team.
Career development: explore a wide range of learning and growth opportunities within and across industries.
Health, life, vision, and dental insurance: cover all your medical bases.
Paid sick time, retirement plan, fitness reimbursement, pet insurance, identity protection, technology stipend, employee assistance program, and more.
Base pay offered may vary depending on job‑related knowledge, skills, and experience.
Pay Range
$130,000 - $145,000 USD
Woolpert is an equal‑opportunity employer. Woolpert is committed to the full inclusion of all individuals. We recruit, train, compensate, and promote regardless of race, religion, color, national origin, sex, disability, age, veteran status, and other protected status as required by applicable law.
#J-18808-Ljbffr