DATA MIGRATION ANALYST SKILLS, EXPERIENCE, AND JOB REQUIREMENTS

Published: October 2, 2024 - The Data Migration Analyst with robust communication skills excels in effectively conveying complex data concepts and collaborating with stakeholders to meet stringent deadlines. Proficient in designing and executing ETL processes using tools like Microsoft SSIS and IBM InfoSphere DataStage, coupled with strong project management acumen and familiarity with Atlassian tools such as Jira and Confluence. This position holds advanced IT qualifications and possesses extensive experience in Microsoft data platforms and HR data migration methodologies, integrating platforms like SAP HCM and Workday.

Essential Hard and Soft Skills for a Standout Data Migration Analyst Resume
  • Data Mapping
  • Data Profiling
  • SQL
  • ETL Development
  • Data Quality Assurance
  • Data Transformation
  • Data Cleansing
  • Data Migration Planning
  • Metadata Management
  • Data Reconciliation
  • Communication
  • Problem Solving
  • Attention to Detail
  • Critical Thinking
  • Time Management
  • Adaptability
  • Collaboration
  • Analytical Thinking
  • Stakeholder Management
  • Project Coordination

Summary of Data Migration Analyst Knowledge and Qualifications on Resume

1. BS in Computer Science with 6 years of Experience

  • Demonstrated experience in data analysis on multi-system data convergence and migration projects.
  • Experience in gathering and documenting data requirements, data migration business rules and development of complex data maps.
  • Experience as an MSSQL Database Developer in creating Stored Procedures and Views.
  • Strong analytical skills with the ability to collect, organize, analyze and disseminate significant amounts of information across project teams and stakeholders with attention to detail and accuracy.
  • Experience in project/program management within established structures with the ability to work to tight deadlines and competing priorities..
  • Experience in developing extract-transform-load (ETL) processes using tools such as Microsoft SSIS or IBM InfoSphere DataStage.
  • Knowledge of data governance or data management practices
  • Strong analytic skills with attention to detail providing front-end data analysis, requirements gathering, design, testing, documentation implementation, and support of assigned data projects
  • Intermediate to advanced proficiency in Microsoft Office products (Excel, Word, Access, Visio, PowerPoint, and Outlook)
  • Experience in 1 or more SAP modules (Agricultural Contract Management - Preferred, SD, MM, FI) in a data management or related role
  • Experience in the Agribusiness industry
  • Experience leading continuous improvement projects and tasks

2. BA in Information Systems with 5 years of Experience

  • Demonstrated competency in data analysis and/or data migration.
  • Knowledge and/or experience with eClinicalWorks or any other EHR systems.
  • Strong analytical and problem-solving skills
  • Excellent analytical, mathematical, and problem-solving abilities.
  • Outstanding presentation, reporting and communication skills.
  • Ability to work on own initiative or as part of a team.
  • Knowledge of data tools.
  • Experienced with process improvement, reporting, forecasting and change management.
  • Prior experience with requirements gathering business process mapping and cross-functional team communications.
  • Well-organized, with a high attention to detail and ability to prioritize.
  • Strong technical and numerical skills with advanced Excel skills.
  • Proficiency with MS Office/Office 365.

3. BS in Data Science with 3 years of Experience

  • High level oral, written and interpersonal communication skills including ability to communicate effectively with team members and stakeholders.
  • Experience in project/program management within established structures with the ability to work to tight deadlines and competing priorities.
  • Experience in working collaboratively within a team environment with high-priority deliverables, and ability to guide and knowledge transfer to project team members.
  • Experience in developing extract-transform-load (ETL) processes using tools such as Microsoft SSIS or IBM InfoSphere DataStage.
  • Tertiary qualifications in IT, computer science or software engineering.
  • Experience using Atlassian tools such as Jira, Bitbucket (Git) and Confluence.
  • Experience with Microsoft data platform, including tools such as SSIS and Master Data Services.
  • Experience with the Microsoft platform in the development of data migration processes e.g.: .NET Framework, Team Foundation Server (TFS), T-SQL.
  • Experience with Enterprise Architect Data modeling methodology.
  • Knowledge of HR Data Migration Processes.
  • Knowledge of HR concepts and technologies such as SAP HCM / Peoplesoft / euHReka / Workday / SuccessFactors.
  • Knowledge of integration technologies such as SAP XI/PI

4. BA in Business Analytics with 4 years of Experience

  • Strong organizational skills and ability to multitask.
  • Strong problem-solving, quantitative and analytical abilities.
  • Strong SQL skills, and ability to perform effective querying involving multiple tables and subqueries.
  • Excellent documentation creation and management skills
  • Experience with Vendor migration and implementation expertise in a SaaS environment
  • Excellent communication and collaboration skills with the ability to engage with all stakeholder levels.
  • Experience with quality-driven and customer-centric focus.
  • Proven strategic advice and planning to support customer experience teams and senior management in developing procedures and guidelines.
  • Proficiency in MS Office Applications, Tableau.
  • Ability to obtain a Working with Children Check
  • Systematic processing and analytical thinking
  • Advanced MS Excel data manipulation skills
  • Experience in Sharepoint

5. BS in Information Technology with 5 years of Experience

  • Experience in business, data, or systems analysis, or as a key business resource on systems projects
  • Demonstrated leadership on mid to large-scale projects impacting strategic priorities
  • Experience in leading and ensuring delivery of all aspects of data migration including data identification, analysis and mapping
  • Integration and data migration experience with Salesforce.com
  • Good Understanding of data quality and governance models
  • Strong problem-solving skills and a laser focus on even the smallest details
  • Competent knowledge of NetSuite, Oracle
  • Ability to work with changing priorities and with multiple projects
  • Excellence in collaboration, analytical thinking and technical expertise
  • Able to manage and execute effectively on multiple, time-sensitive projects, with keen sense of urgency 
  • Experience in data migration projects

6. BA in Database Management with 4 years of Experience

  • Experience in process mapping of complex processes and data flows
  • Experience in requirements gathering and reporting design
  • Experience with data migration or data transformation
  • Experience in complex problem-solving and mediating decision-making
  • Industry experience in one or more Finance/Travel & Expenses, HR, or Procurement
  • Exposure to SAP S/4HANA
  • Experience in engaging with both technical and non-technical stakeholders
  • Consulting experience and background, including engaging directly with clients
  • Experience in a delivery role on Data Migration, Business Intelligence, Data Warehousing, Big Data or analytics projects
  • Experience with master data management
  • Experience with the Australian Public Service

7. BS in Software Engineering with 7 years of Experience

  • Experience in Data Migration or Data Integration.
  • Knowledge and experience working within the insurance industry- advantage.
  • Ability to translate functional requirements to test scenarios.
  • Expert-level knowledge and experience with information systems (such as ERP).
  • Ability to understand the data models and structures of complex technology systems.
  • Experience working with SQL.
  • Familiar/working with REST APIs, XML, SAOP.
  • Strong MS Office skills.
  • Experience with ETL (K2VIEW, Talend) -advantage.
  • Experience with interface design and integration planning.
  • Experience analyzing and implementing interfaces between systems.
  • Programming experience- advantage.
  • Excellent communication and presentation skills.
  • Experience in conducting/leading sessions with customers/High presentation skills

8. BA in Management Information Systems with 8 years of Experience

  • Proficient computer skills including MS Office Suite (Excel, Outlook and Word).
  • Ability to manage projects and lead a team.
  • Strong level of project management knowledge including the ability to effectively manage and prioritize projects, issues and tasks.
  • Excellent verbal and written communication skills with the ability to communicate with all levels of clients and internal staff.
  • Strong sense of accountability and follow through, effective problem-solving skills as well as a commitment to positive solutions and the client experience.
  • Previous Omaha credit processing platform knowledge/experience
  • Experience in performing complex source and target data analysis
  • MS Access experience including data transformation from source to target structure
  • Experience in writing SQL queries to retrieve and manipulate complex data
  • Experience and understanding of ETL concepts
  • Excel spreadsheet macros/VB scripting experience
  • Excellent problem-solving and analytical skills

9. BS in Data Analytics with 2 years of Experience

  • Experience with  Dynamics 365 data migration 
  • Experience with SQL Server and writing queries for data analysis, cleansing and extraction.
  • Working knowledge of Master Data concepts and implementation.
  • Excellent problem-solving and documentation skills.
  • Excellent organizational and communication skills both written and verbal.
  • Excellent interpersonal skills that are conducive to a team culture.
  • Experience with migration from Dynamics AX 2009/2012 to D365
  • Knowledge of and hands-on experience with Dynamics AX 2009/2012.
  • Development of data import export tool (DIXF) and AX development.
  • Knowledge of Dynamics 365 Finance
  • Experience with ERP systems
Relevant Information
Data Integration Specialist Skills, Experience, and Job Requirements
Data Integrator Skills, Experience, and Job Requirements
Data Integrity Analyst Skills, Experience, and Job Requirements
Data Business Analyst Skills, Experience, and Job Requirements