Back to jobs

IT ERP M&A Data Migration Technical Manager

Atlanta, GA; Austin, TX; Chicago, IL; Cleveland, OH; Dallas, TX; Dayton, OH; Denver, CO; Houston, TX; Indianapolis, IN; Tampa, FL

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

  • 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, 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, 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 (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 fast‑paced, deadline‑driven M&A environment.
  • Strong interpersonal skills across both verbal (day‑to‑day discussions, team meetings, workshops) and written (requirements and design specifications) communication, with a consistent 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 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, you’ll work on meaningful assignments that improve quality of life around the world. In 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!

 

 

 

Base pay offered may vary depending on job-related knowledge, skills, and experience.

Pay Range

$130,000 - $145,000 USD

Find out more about what Woolpert has to offer here:  http://woolpert.com/about-us/

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.  You may view more about EEO on our website: Equal-Employment-Opportunity-The-Law.pdf 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 askhr@woolpert.com.

If you need to reschedule or cancel your interview, please reach out to your recruiter by contacting recruiting@woolpert.com. 

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 Woolpert's Talent Acquisition Team for this requisition and a valid agreement is in place. In the event a candidate who was submitted outside of Woolpert's applicant process is hired, no fee or payment of any kind will be paid.

Create a Job Alert

Interested in building your career at Woolpert? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

If you would like to share additional documents (such as a portfolio, work samples, or certifications), please upload them here

Accepted file types: pdf, doc, docx, txt, rtf

Select...
Select...
Select...
Select...
Select...
Select...

If yes, you can always opt-out by replying STOP.

Privacy Acknowledgement *

Please review our Privacy Policy to understand how we protect your personal information. By proceeding, you acknowledge and agree to our commitment to safeguarding your privacy.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Woolpert’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.