> Markdown version of [/jobs/ext/2996529-data-migration-lead](https://www.wearedevelopers.com/jobs/ext/2996529-data-migration-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Migration Lead - **Company:** Astronics Corporation - **Location:** Buffalo, NY, United States (Remote available) - **Experience:** Expert - **Salary:** $107,000.0 - $130,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Information Systems, Data Validation, Data Governance, Extract Transform Load (ETL), Data Mapping, Data Migration, Data Mining, Data Profiling, Data Structures, Data Warehousing, Database Queries, Document-Oriented Databases, Systems Analysis, Microsoft Dynamics, Migration Manager, Webui, SQL Stored Procedures, SQL Databases, Data Streaming, Technical Data Management Systems, Sql Optimization, Generative AI, Information Technology, Data Management - **Published:** September 19, 2026 - **Apply:** https://www.dice.com/job-detail/96dbcc95-fa61-4420-ba5a-7b5f6c2c3f0b ## About the Role * Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent work experience. * 7+ years of hands-on data migration experience in Dynamics 365 F&O. * Advanced SQL proficiency: writing complex queries, stored procedures, and ETL logic. * Experience leading data migration projects from extraction through go-live, including data mapping, transformation, validation, and cutover in multi-phase implementations. * Exposure to international data migrations across multiple legal entities. * Demonstrated experience with data quality assessment, validation frameworks, and reconciliation. * Experience working with cross-functional teams including developers, business analysts, infrastructure and vendor teams. * Solid understanding of financial data flows (GL, AP, AR) and supply chain processes (Procurement, Inventory, Warehouse Management). * Familiarity with data staging environments, ETL tools, and database management. * Familiarity with enterprise data governance platforms (Microsoft Purview). * Experience with Open WebUI, generative AI tools, or AI-assisted data profiling and validation. * Some travel may be required to support go-live activities domestically and internationally * Manufacturing or aerospace industry background is a plus. Your Key Skills and Competencies: * Passionate about data migration and driven to deliver clean, accurate data that enables successful ERP implementations. * Strong technical and analytical skills with attention to data accuracy and integrity. * Clear communicator who can translate technical data concepts into language business stakeholders understand. * Natural leader and decision-maker; comfortable taking ownership of outcomes and making trade-off decisions under pressure. * Collaborative team player; equally effective working independently or guiding others through complex technical challenges. * Detail-oriented and organized; able to manage multiple data streams, timelines, and priorities simultaneously. * Proactive problem-solver; comfortable troubleshooting issues and proposing data remediation strategies. * Adaptable and comfortable in a dynamic, fast-paced implementation environment with evolving requirements. ## Description Are you a data migration expert who thrives leading complex ERP data initiatives? At Astronics, you will be the Accountable for all data migration activities. You will define migration strategy, coordinate multiple data sources, guide teams through technical transformation challenges, and own the outcome of data quality across all D365 go-lives. * Project Planning: Develop detailed migration plans, manage timelines, and coordinate dependencies across developers, analysts, infrastructure teams and implementation partner. * Data Extraction & Source System Analysis: Lead the extraction of data from all source systems (legacy ERP/PLM). Analyze source system data structures. Work with process owners, functional and integration leads to understand data dependencies and ensure all required data is captured. * SQL & ETL: Collaborate with developers, write and optimize SQL queries, stored procedures, and ETL logic. Troubleshoot data anomalies and pipeline performance issues. * Collaboration & Leadership: Lead meetings with functional analysts and developers. Provide technical guidance while incorporating business requirements. Communicate status and risks regularly with global project manager. * Data Validation & Quality Assurance: Design and run validation tests to ensure all migrated data is complete and accurate. Create test cases, validation scripts, and reconciliation checklists that can be reused. Manage business team participation in validation activities and coordinate data cleanup efforts. Track data quality issues from discovery to fix, documenting what went wrong and how it was resolved. Present results to functional leads for approval before UAT and go-live. * Documentation: Create data mapping documentation, transformation specifications, validation procedures, and runbooks. Build internal capability through migration playbooks. * AI & Data Analysis Support: Collaborate with the AI Lead to leverage Open WebUI and internal AI modules to identify data patterns, anomalies, and optimization opportunities. Use AI tools to accelerate validation and automate data profiling workflows. * Data Governance & Purview: Partner with the Data Governance Lead to classify all migrated data in Microsoft Purview. Define data sensitivity levels and lineage. Ensure compliance with enterprise data classification standards. * Enterprise Data Warehouse: Understand how migrated data flows from source systems through D365 into the Enterprise Data Warehouse. Design and validate D365-to-EDW data loads. * Establish MDM principles with the Data Governance Lead and infrastructure team. Monitor data quality post-go-live. Help document data governance workflows and stewardship responsibilities. Continue supporting master data improvements - this will not be a one and done! ## Related Videos - [Delete the roles, deploy the skills](https://www.wearedevelopers.com/videos/2104-delete-the-roles-deploy-the-skills) - [Web-based Information Visualization](https://www.wearedevelopers.com/videos/84-web-based-information-visualization) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Why Your AI Agent Keeps Hallucinating Your Data: Building Deterministic Context Layers](https://www.wearedevelopers.com/videos/2055-why-your-ai-agent-keeps-hallucinating-your-data-building-deterministic-context-layers) - [Data Mining Accessibility](https://www.wearedevelopers.com/videos/802-data-mining-accessibility) ## Related Articles - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Industries Outside of AI Are Hiring The Most AI Experts?](https://www.wearedevelopers.com/magazine/98-what-industries-outside-of-ai-are-hiring-the-most-ai-experts)