Data Conversion Specialist

Client is moving from legacy IFS ERP to Microsoft Dynamics 365, and they need a hands-on data conversion specialist to help us migrate our data cleanly and accurately.

What You'll Do

• Extract data from the legacy IFS ERP on a SQL database
• Write and tune complex SQL queries to pull, transform and reconcile data
• Cleanse the data: remove duplicates, standardize formats, fix gaps and validate it
• Map legacy data to D365 data entities and prepare load-ready files (Data Management Framework / data packages)
• Convert master and transactional data, including:
• Suppliers / Vendors
• Customers
• Products / Items
• Invoices (AP & AR)
• Purchase Orders
• Sales Orders
• Costs / Standard Costing
• Run mock conversions, reconcile record counts and balances, and support cutover
• Work with functional consultants and business users to resolve data issues

What We're Looking For

• Oracle SQL : strong skills in joins, CTEs, stored procedures and data manipulation
• Data migration / conversion: hands-on experience on ERP projects
• Microsoft Dynamics 365: experience preparing data for D365 (Finance & Operations or Business Central)
• IFS ERP: experience is a plus
• Business processes: understanding of procure-to-pay and order-to-cash data flows
• Data quality: detail-oriented, with solid data validation and reconciliation habits
• Communication: able to work with both technical and business teams

Nice to Have

• SSIS, Azure Data Factory or other ETL tools
• Excel / Power Query for data validation
• D365 Data Management Framework (DMF) experience