Data Migration Architect

$115,000 - $124,000/Yr

Teckpert - Miami, FL

Part-time - Mid Level

Remote - Miami, FL

Professional, Scientific, and Technical Services

About the position

The Data Migration Architect will play a crucial role in supporting a local government organization's data migration initiative. This position involves managing the end-to-end data migration process, ensuring data quality and accuracy while collaborating with various departments and vendor teams. The architect will be responsible for designing, planning, and executing the migration of legacy systems into a new third-party application, making it essential for the success of the project.

Responsibilities

• Lead and manage the end-to-end data migration and conversion process, including design, planning, and execution for several legacy systems into the new third-party application.
• Work closely with County and vendor teams to gather and document data migration requirements, ensuring a comprehensive and cohesive data conversion strategy.
• Analyze legacy data systems, map data fields, and ensure proper data cleansing and standardization to meet project needs.
• Oversee the development and validation of ETL (Extract, Transform, Load) processes to migrate large datasets, ensuring data integrity and consistency.
• Coordinate with stakeholders to ensure that migration tasks align with project milestones and timelines.
• Perform data conversion testing and validation in collaboration with technical teams and business stakeholders, ensuring successful migration and data accuracy.
• Regularly communicate progress, challenges, and risks to the project management team, ensuring stakeholders are kept informed.
• Lead efforts to troubleshoot and resolve issues during data migration, acting as the primary escalation point for all data conversion tasks.

Requirements

• Bachelor's Degree in Computer Science, Computer Engineering, or a related field with a focus on software development.
• At least eight (8) years of experience in data migration, data conversion, or similar roles.
• Experience in large-scale data migration/ETL processes from legacy to modern systems, including data mapping, design, validation, and implementation.
• Proficiency with database management and development tools, specifically SQL Server, SSIS, and SQL stored procedures.
• Expertise in Excel and various ETL tools and techniques.
• Strong technical background in database development and migration.
• Experience working with mainframe applications, including COBOL and IDMS databases.
• Familiarity with both Waterfall and Agile methodologies for software development.
• Excellent attention to detail, along with strong written and verbal communication skills.

Benefits

• Flexible schedule
• Health insurance
• Life insurance
• Vision insurance