IT ERP M&A Data Migration Technical Manager

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.

Position Overview

Woolpert is hiring an IT ERP M&A Data Migration Technical Manager to join our dynamic Corporate Applications. This position reports to theSenior Director Corporate Applications.This roleis accountable for leading and executing ERP data migrations for companies acquired by Woolpert in support of the firms 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 Woolperts ERP ecosystem. The position requires a balance of people leadership and deep handson 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 Woolperts overall M&A integration program.
• Define and execute endtoend 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 activity.
• Reduce migration cycle time through innovative tools automation and repeatable frameworks.
• Continuously refine and evolve ETL processes to improve quality scalability and efficiency.

What You Will Bring:

Education & Experience

• Bachelors degree in Computer Science Information Technology Mathematics or a related field or equivalent experience.
• Proven experience in managing/leading teams and delivering fulllifecycle ERP implementations.
• 10 years of experience working with data migrations for complex ERP implementations preferably in M&A environments.
• 7 years of handson experience with Microsoft Dynamics 365 Finance & Operations including 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 conversions sourcetotarget 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 (ADF) 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. Must demonstrate proven expertise in mapping and reconciling financial transactions across multiple currencies managing historical exchange rates and ensuring balance integrity and consistency.
• 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 the ability to communicate effectively across technical and business audiences.
• Excellent written and verbal communication skills with the ability to present complex concepts clearly and concisely.
• Proven ability to operate in a fastpaced deadlinedriven M&A environment.
• Strong interpersonal skills across both verbal (daytoday discussions team meetings workshops) and written (requirements and design specifications) communication with a consistent focus on clarity and precision.

Core Competencies

• Strong analytical and problemsolving skills with exceptional attention to detail.
• Ability to evaluate complex datasets reconcile discrepancies and translate data into actionable insights.
• Adaptability and resourcefulness in dynamic highchange environments.
• Strong business acumen with an 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 (e.g. 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

Certified as a Great Place to Work Woolpert is one of the fastest-growing architecture engineering and geospatial companies in the world. With over 75 offices and countless projects around the globe youll work on meaningful assignments that improve quality of life around the addition to offering competitive pay we provide employees with a robust set of unique benefits including:

• Freedom to Work program: Set your own schedule and location (as appropriate).
• Principal program: Earn the 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!

Find out more about what Woolpert has to offer here: 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. You may view more about EEO on our website: and EEO is the Law Poster Supplement.

Applicants who require an accommodation throughout the application and interview process should request this in advance by contacting .

If you need to reschedule or cancel your interview please reach out to your recruiter by contacting .

To all agencies:Please no phone calls or emails to any employee of Woolpert or any of our subsidiaries about this requisition. All resumes submitted by search firms/employment agencies to any employee at Woolpert via email the internet or in any form and/or method will be deemed the sole property of Woolpert unless such search firms/employment agencies were engaged by Woolperts Talent Acquisition Team for this requisition and a valid agreement is in the event a candidate who was submitted outside of Woolperts applicant process is hired no fee or payment of any kind will be paid.