Technical Specialist (D365)

Responsibilities

Data Analysis and Planning:

• Perform a thorough evaluation of existing data within legacy systems.
• Develop a data migration strategy, including cleansing, transformation, and validation processes.
• Collaborate with business stakeholders to determine data requirements and establish mapping guidelines.

Data Mapping and Transformation:

• Align source data with D365 structures while ensuring compliance with business rules.
• Use tools like Power Query and SQL to transform data into D365-compatible formats.
• Create scripts or ETL (Extract, Transform, Load) workflows to optimize data conversion.

Migration Execution:

• Utilize migration tools such as D365 Data Import Export Framework (DIXF), Azure Data Factory, and SSIS to transfer data.
• Conduct test migrations to verify data accuracy and identify any potential issues.
• Diagnose and resolve migration errors in collaboration with technical teams.

Data Validation and Quality Assurance:

• Implement validation procedures post-migration to ensure data integrity and completeness.
• Compare migrated data with legacy records to confirm accuracy.
• Work with business users to validate and ensure the usability of transferred data.

Documentation and Training:

• Maintain detailed documentation on data mappings, transformation processes, and validation steps.
• Provide training for business users on data validation techniques and using migrated data within D365.

Ongoing Data Management:

• Offer post-migration support for any data quality concerns or additional transformation needs.
• Develop protocols for continuous data updates and integration with D365.

Requirements

• Experience with data transformation and ETL tools.
• Proficiency in scripting for automation and data processing.
• Hands-on experience with D365 data migration tools.
• Knowledge of Azure services for data integration.
• Expertise in database management and data governance best practices.
• Strong understanding of data quality assurance and compliance.
• Ability to analyze business requirements and translate them into data solutions.
• Strong problem-solving and troubleshooting skills.
• Experience in project management and effective communication.
• Familiarity with Microsoft Power Platform.
• Fluency in English and German.