Published: October 02, 2024 - The Data Migration Analyst is tasked with identifying discrepancies and inconsistencies within data across company systems, utilizing sources such as company documentation, ESMS data, and subject matter experts. Responsibilities include managing and enriching data within spreadsheets and SharePoint, conducting verification testing, and supporting data warehousing initiatives to guarantee the accuracy and reliability of database information. This role also involves analyzing database models to ensure compliance with standards, generating reports to aid business objectives, and performing rigorous analysis and testing on relational databases to troubleshoot any issues related to data loads or retrievals.
Tips for Data Migration Analyst Skills and Responsibilities on a Resume
1. Data Migration Analyst, Core Data Solutions LLC, Richmond, VA
Job Summary:
- Coordinating the data collection/validation project plan with the project management office
- Coordinating data collection/validation with client, vendor, and internal resources
- Conducting a data collection/validation call explaining the process for client, vendor, and internal resources
- Conducting weekly calls with the internal team guiding them through best practice data collection and validation progress
- Reviewing and validating foundational datasets to gain an intimate understanding of the client data design
- Performing regular analysis and reporting on data collection/validation progress and key metrics
- Auditing, cleaning, and standardization of large data sets including formatting, file combination, field mapping, and gap analysis
- Heavy Excel data manipulation of multiple large data sets
- Practicing best-practice data management including regular backups, data completeness audits, data mapping audits
- Learning an intimate knowledge of VMS data imports in several key VMS (SAP Fieldglass, Beeline, VNDLY, Coupa Contingent Workforce, etc.)
Skills on Resume:
- Data Coordination (Hard Skills)
- Data Validation (Hard Skills)
- Stakeholder Communication (Soft Skills)
- Data Analysis (Hard Skills)
- Data Auditing (Hard Skills)
- Excel Proficiency (Hard Skills)
- Data Standardization (Hard Skills)
2. Data Migration Analyst, PrimeTech Analytics Inc, Little Rock, AR
Job Summary:
- Executing rigorous VMS upload testing prior to and after project go-live
- Executing production of multiple VMS uploads
- Performing systematic audits of production data
- Reporting on data gaps and coordinating gap-fill logic
- Coordinates and resolves any missing data/data questions with the client or supplier resources
- Balancing competing priorities of multiple projects with overlapping data collection processes
- Actively contributing to product knowledge through self-study, meeting attendance, and project participation
- Proactively seeking help when required and voicing any data workstream risks
- Participating in corporate strategic initiatives aligned with process improvements or operational efficiencies
- Assist in the collection and consolidation of required information and data
Skills on Resume:
- VMS Upload Testing (Hard Skills)
- Data Auditing (Hard Skills)
- Data Reporting (Hard Skills)
- Client Coordination (Soft Skills)
- Project Management (Hard Skills)
- Product Knowledge Development (Soft Skills)
- Risk Management (Soft Skills)
- Data Consolidation (Hard Skills)
3. Data Migration Analyst, Vertex Consulting Group, Trenton, NJ
Job Summary:
- Identifying gaps and inconsistencies with data stored in company systems.
- Gather data from company document content, ESMS data and SMEs.
- Manage Data within Enrichment spreadsheets.
- Manage Data Enrichment within SharePoint.
- Participate in Verification Testing.
- Provide support for data warehousing initiatives and monitor data warehousing system to ensure the reliability and accuracy of information loaded into the databases.
- Analyze the logical and physical database models and ensure models are in accordance with standards.
- Generate and prepare reports to support business objectives.
- Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues.
- Issue tracking, status reporting, regression testing and data quality verification
- Gathering and prepare functional requirements and Non-functional requirements
Skills on Resume:
- Data Gap Analysis (Hard Skills)
- Data Management (Hard Skills)
- Data Enrichment (Hard Skills)
- Verification Testing (Hard Skills)
- Database Analysis (Hard Skills)
- Reporting (Hard Skills)
- Issue Tracking (Hard Skills)
- Requirements Gathering (Hard Skills)
4. Data Migration Analyst, Agile Data Systems, Fort Wayne, IN
Job Summary:
- Perform source system data analysis to map data objects in the legacy ERP system
- Create complex scripts to extra required data from source legacy ERP system
- Compare and transform extracted data within existing target ERP records to match and map identifiers
- Create exception logs and reports to proactively identify errors & mismatched data types
- Facilitate timely data corrections and re-validations
- Document the end-state extraction steps and checks to ensure data migration process is repeatable and tested to ensure a smooth go-live process
- Implemented VillageMD data extraction technologies across multiple EMR systems and multiple vendors
- Increased the portfolio of data pipelines into the VillageMD platform through creative solutions with external partners (migration vendors) and VillageMD engineers
- Created tools and workflows to facilitate data ingestion and delivery projects
- Plan and fully document requirements
- Take up change’s requests
- Perform acceptance testing
Skills on Resume:
- Data Mapping (Hard Skills)
- Data Extraction Scripting (Hard Skills)
- Data Transformation (Hard Skills)
- Error Identification (Hard Skills)
- Data Validation (Hard Skills)
- Documentation (Hard Skills)
- Change Request Management (Soft Skills)
- Acceptance Testing (Hard Skills)
5. Data Migration Analyst, InfoStream Technologies, Madison, WI
Job Summary:
- Creating a Data Migration and Conversion Plan and strategy
- Performing data mapping for systems integration, data provisioning, and data consumption
- Documenting metadata, data lineage, data definitions and business glossary entries
- Handling basic data transformation tasks such as date and decimal formatting, rounding of numeric values, and conversion of numeric values to percentages.
- Identifying, analyzing, and interpreting trends or patterns in complex data sets
- Developing ad hoc briefings, charts, data visualizations, meeting materials, etc.
- Identifying and proposing viable technology solutions to meet client needs
- Developing data migration and conversion specifications, test scripts and templates required to complete data conversion activities
- Establishing a process to reconcile and report on converted data
Skills on Resume:
- Data Migration Planning (Hard Skills)
- Data Mapping (Hard Skills)
- Metadata Documentation (Hard Skills)
- Data Transformation (Hard Skills)
- Data Analysis (Hard Skills)
- Data Visualization (Hard Skills)
- Technology Solution Identification (Soft Skills)
- Conversion Specification Development (Hard Skills)
6. Data Migration Analyst, DataNet Solutions Inc, Des Moines, IA
Job Summary:
- Responsible for all aspects of Data Migration, supporting the Data Migration approach.
- Work with the ERP System Integrator, supplier and internal resources to deliver the migration of data from legacy finance systems, onto a new consolidated ERP SaaS System as well as dependent data updates in legacy systems.
- Identify, document and validate data migration scope, risks, constraints, dependencies and assumptions. Ensuring a thorough and controlled documentation process.
- Coordinate the delivery of all aspects of the data migration plan utilising internal and supplier resources.
- Definition of all data requirements for the build, test and cutover project phases.
- Enforce policies for the effective management of data, and the migration of data to the organization’s new ERP system.
- Legacy data identification and mapping from legacy systems to the new system.
- Managing to extract, stage, cleanse, transform and load of the data into the target solution (transactional and master).
- Work with the system integrator to ensure an optimal approach to the upload of legacy data into the new system, together with ensuring a smooth process for the resolution of upload issues.
- Coordinate all aspects of data cleansing, including coordinating BAU resources within the business functions.
Skills on Resume:
- Data Migration Management (Hard Skills)
- ERP Integration Coordination (Hard Skills)
- Risk and Scope Documentation (Hard Skills)
- Data Requirement Definition (Hard Skills)
- Data Cleansing (Hard Skills)
- Legacy Data Mapping (Hard Skills)
- Data Transformation and Loading (Hard Skills)
- Process Coordination (Soft Skills)
7. Data Migration Analyst, CloudMatrix Solutions LLC, Hartford, CT
Job Summary:
- Working under the direction of the Data Migration Lead and IT Leadership:
- Work hours that will support UK (GMT) and German (CET) timezones
- Profile legacy ERP source data for accuracy and completeness
- Perform Customer, Vendor, Material Master and GL data cleansing and data enrichment activities to drive data accuracy
- Develop detailed mapping documents among all source-to-target datasets
- Perform ETL activities using ETL tools, as necessary
- Enrich data and metadata, as necessary, potentially requiring joining multiple source datasets, to create a complete set for target loads
- Perform data test loads and production loads
- Provide regular status reports to leadership
- Work with global stakeholders to drive data mapping, process clarification, and data verification activities
- Identify any risks and issues and timely report out to leadership for resolution
Skills on Resume:
- Data Profiling (Hard Skills)
- Data Cleansing and Enrichment (Hard Skills)
- Mapping Document Development (Hard Skills)
- ETL Execution (Hard Skills)
- Metadata Management (Hard Skills)
- Test and Production Loading (Hard Skills)
- Stakeholder Collaboration (Soft Skills)
- Risk Identification and Reporting (Soft Skills)