Salary: $85,000 - 122,000 per year
Requirements:
- Strong Oracle SQL skills, including joins, CTEs, stored procedures, and data manipulation
- Hands-on experience with data migration or conversion on ERP projects
- Experience preparing data for Microsoft Dynamics 365 Finance & Operations or Business Central
- Understanding of procure-to-pay and order-to-cash data flows
- Detail-oriented approach with strong data validation and reconciliation practices
- Ability to collaborate with technical and business teams
- IFS ERP experience is a plus
- Familiarity with SSIS, Azure Data Factory, or other ETL tools is desirable
- Experience using Excel or Power Query for data validation is desirable
- D365 Data Management Framework experience is desirable
Responsibilities:
- Extract data from the legacy IFS ERP SQL database
- Write and optimize complex SQL queries to retrieve, transform, and reconcile data
- Clean and validate data by removing duplicates, standardizing formats, and addressing gaps
- Map legacy data to D365 data entities and prepare files for loading through the Data Management Framework or data packages
- Convert master and transactional data, including suppliers, customers, products, invoices, purchase orders, sales orders, and costing information
- Run mock conversions, reconcile record counts and balances, and support cutover
- Work with functional consultants and business users to resolve data issues
Technologies:
- Azure
- ETL
- ERP
- Excel
- Support
- Oracle
- Power Query
- SQL
- SSIS
- Office 365
- Cloud
- DevOps
More:
We are moving from a legacy IFS ERP system to Microsoft Dynamics 365 and need a hands-on data conversion specialist to help migrate data accurately and reliably.
last updated 46 week of 2026
You apply on DevITjobs, where this job was posted. Peter Nowak isn’t the employer and doesn’t check listings.
