Remote Data Migration Specialist

Summary

The Data Migration Specialist will be responsible for migrating a legacy Permitting system to a SAAS product over 6 months. The role involves planning, executing, and managing the migration process, defining data mapping strategies, developing data transformation processes, creating comprehensive plans, executing tasks according to the plan, collaborating with cross-functional teams, conducting post-migration verification, maintaining documentation, and generating reports.

Requirements

• Bachelor’s degree in computer science, Software Engineering, or a related field (or equivalent experience)
• Proven track record of developing custom software solutions and system integrations
• Strong data querying skills using SQL and database skills (5+ years)
• Strong understanding of data modeling concepts and best practices and building data pipelines using ETL frameworks and APIs
• Minimum of 8 years of relevant software engineering experience
• Familiarity with Agile development methodologies
• Experience with version control systems, GIT
• Experience with JIRA

Responsibilities

• Will be responsible for planning, executing, and managing the migration of data from one/multiple system(s) or platform to another
• Define data mapping strategies to effectively translate data from the source to the target system, considering data types, formats, and business rules
• Develop and execute data transformation processes to cleanse, convert, and validate data for migration, ensuring data consistency and accuracy
• Develop comprehensive migration plans, including timelines, resource allocation, and risk assessment, to achieve successful data migration
• Developing a data migration checklist and sign-off process to ensure completion of planned activities
• Execute data migration tasks according to the established plan, monitor progress, and address any issues or discrepancies that arise during the migration process
• Collaborate with cross-functional teams, including IT, business stakeholders, and data owners, to ensure smooth migration processes and minimize disruption to operations
• Communicate progress, challenges, and resolution strategies to stakeholders, ensuring transparency and alignment with project objectives
• Conduct thorough data verification and validation post-migration to ensure data integrity, completeness, and accuracy in the target system
• Maintain detailed documentation of the entire data migration process, including mapping, transformation rules, migration steps, and issue resolution
• Generate comprehensive reports summarizing the migration process, outcomes, and any lessons learned for future improvements