Data Migration Lead, D365

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

Take your career to new heights with the Astronics team as a Data Migration Lead!

Astronics, a leader in aerospace manufacturing and technology solutions, is seeking an experienced Data Migration Lead to drive the data migration strategy and execution for our multi-year Dynamics 365 implementation across global locations. As we embark on this transformational ERP journey, you will own the end-to-end data migration process — from extraction and mapping through validation and go-live — ensuring data integrity across Finance, Operations, Supply Chain, MES, and Engineering systems.

This is a hands-on technical leadership role where you will lead the data migration workstream, collaborate closely with developers, functional analysts, infrastructure teams, and our implementation partner. You will combine strategic planning with hands-on execution, running SQL queries, designing data transformation logic, driving validation to ensure a clean cutover to D365, MES, PLM and custom applications.

This is a remote role, which requires flexibility to travel as needed to our headquarters outside of Buffalo, New York. Some additional travel will also be expected to support go-live activities both domestically and internationally.

Why consider Astronics?

• Competitive base salary with quarterly bonus opportunities
• 9/80 schedule with every other Friday off
• 401(k) with company contribution and discounted Employee Stock Purchase Plan
• Week-long Christmas shutdown and paid holidays
• An engaging culture that values integrity, teamwork, and innovation
• Purpose-driven work, contributing directly to products that shape the aerospace industry

What You’ll Do:

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!

What You’ll Bring:

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

Compensation:

• Base salary: $107,000 - $130,000, influenced by several factors including experience, skill set, education, certifications, market conditions, and business needs.
• This position may involve access to items subject to U.S. export‑control laws. Employment is contingent upon the employee’s authorization to access such items under applicable law. The company does not guarantee and is under no obligation to seek such authorization if it would be necessary.

Why You’ll Love Working Here:

• Flexibility That Works:Enjoy a 9/80 schedule with every other Friday off, promoting the work‑life harmony you deserve.
• Rewards That Matter:Competitive compensation, quarterly bonuses tied to company profitability, a 401(k) with a 3% company contribution, and an Employee Stock Purchase Plan to secure your financial future.
• Comprehensive Benefits:Health, dental, vision, disability, and life insurance, as well as additional voluntary coverage options.
• Paid Holidays and Time to Recharge:Celebrate holidays and benefit from a week-long, full Christmas shutdown.
• A Chance to Innovate:Your leadership will play a key role in driving advancements at the forefront of aerospace technology.

Astronics Corporation (Nasdaq: ATRO) serves the world's aerospace, defense, and other mission critical industries with proven, innovative technology solutions. Astronics works side‑by‑side with customers, integrating its array of power, connectivity, lighting, structures, interiors, and test technologies to solve complex challenges. For over 50 years, Astronics has delivered creative, customer‑focused solutions with exceptional responsiveness. Today, global airframe manufacturers, airlines, militaries, completion centers and Fortune 500 companies rely on the collaborative spirit and innovation of Astronics. The Company's strategy is to increase its value by developing technologies and capabilities that provide innovative solutions to its targeted markets.

For more information on Astronics and its solutions, visit www.Astronics.com .

All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status.