Woolpert is hiring a Technical Dynamics 365 Data Migration 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., * Freedom to Work program: Set your own schedule and location (as appropriate)., Manage the insurance tax team, assist in client relationships and business development, oversee tax compliance, and support tax strategies. Top Skills: AccountingInsurance TaxTax Compliance Wipfli

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

Reposted 14 Hours Ago Be an Early Applicant In-Office Denver, CO, USA 139K-175K Annually Expert/Leader In-Office Denver, CO, USA 139K-175K Annually Expert/Leader Lead and execute end-to-end ERP data migrations into Dynamics 365 (F&O and CE) for acquisitions. Define migration strategy, design and run ETL, data mapping, reconciliation, validation, and cutover. Manage a blended team, ensure data quality and governance, and drive automation and continuous improvement across migration processes. The summary above was generated by AI, * 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!

LI-Hybrid

Base pay offered may vary depending on job-related knowledge, skills, and experience. Pay Range $139,200-$175,000 USD, Remote or Hybrid United States 142K-192K Annually Expert/Leader 142K-192K Annually Expert/Leader Cloud * Fintech * Software * Business Intelligence * Consulting * Financial Services Lead complex real estate tax engagements, mentor teams, provide client advisory on tax strategies, and drive business growth through networking. Top Skills: CpaJdLlmMstTax Technology Tools Wipfli, Remote or Hybrid United States 107K-160K Annually Senior level 107K-160K Annually Senior level Cloud * Fintech * Software * Business Intelligence * Consulting * Financial Services Serve as a trusted advisor to behavioral health providers by reviewing financial reporting, preparing budgets/forecasts, analyzing KPIs, providing technical accounting support, identifying operational improvements, leading US and offshore engagement teams, and coaching staff to ensure high-quality deliverables and client service. Top Skills: Bill.ComNetSuiteQuickbooks OnlineSage Intacct

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

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