Remote D365 ERP Data Migration Lead

Astronics; Buffalo (NY); Remote; USD 107,000 - 130,000; Full time

Benefits offered by this job

9/80 schedule with every other Friday

401(k) with company contribution

Employee Stock Purchase Plan

Week-long Christmas shutdown and paid

Paid holidays

Bonus opportunities

Job summary

Astronics is seeking a Data Migration Lead to drive end-to-end data migration for a multi-year Dynamics 365 implementation across global locations. You will own extraction, mapping, validation, and go-live data integrity for Finance, Operations, Supply Chain, MES, and Engineering systems.

This hands-on technical leadership role requires coordinating with developers, analysts, and infrastructure teams, while guiding the migration workstream and ensuring clean cutovers to D365 and related systems.

Qualifications

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

Responsibilities

• 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 and leads to capture dependencies.
• SQL & ETL: 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 aligning with business requirements.
• Data Validation & Quality Assurance: Design and run validation tests; create test cases and reconciliation checklists; coordinate data cleanup; present results for UAT/go-live.
• Documentation: Create data mapping docs, transformation specs, validation procedures, and runbooks.
• AI & Data Analysis Support: Collaborate with AI Lead to leverage tools to identify patterns and automate data profiling workflows.
• Data Governance & Purview: Partner to classify data, define sensitivity, ensure compliance with standards.
• Enterprise Data Warehouse: Understand data flows from source through D365 into EDW; design and validate D365-to-EDW loads.
• Establish MDM principles and drive data governance workflows post go-live.

Skills

Leadership

Cross-functional collaboration

Communication

Problem solving

Attention to detail

Strategic thinking

Tools

SQL

ETL

Microsoft Purview

D365

Open WebUI

AI tooling

Job description

Astronics is seeking a Data Migration Lead to drive end-to-end data migration for a multi-year Dynamics 365 implementation across global locations. You will own extraction, mapping, validation, and go-live data integrity for Finance, Operations, Supply Chain, MES, and Engineering systems.

This hands-on technical leadership role requires coordinating with developers, analysts, and infrastructure teams, while guiding the migration workstream and ensuring clean cutovers to D365 and related systems.