Migrations Analyst Developer Full Time

Streamline Connections

Migrations Analyst Developers – ETL/SQL/Data Migration

Hybrid working out of either London. Birmingham, Newcastle, Edinburgh or Dundee (3 days per week in office)

The Migration Team has accountability for managing the end-to-end delivery life cycle for all Migration projects. The role involves working with big data, designing, developing, maintaining and supporting the Extract, Transform and Load (ETL) process.

Reporting to the Migration Team Lead, you will work as an integral part of the team, analysing requirements before designing & implementing solutions.

This role is technical and focused on providing long term solutions. The data model and data population routines are a critical part of the migration process so accuracy and attention to detail are important characteristics.

You will need background in:

• Producing technical migration outputs, such as data models, data mapping definitions and data validation
• Designing, creating and maintaining SSIS packages to migrate data
• Designing and developing ETL workflows conforming to best practices and creating re-usable components
• Supporting changes through the testing; resolving data issues, complete unit testing and system documentation for ETL processes
• Providing post implementation support once the migration is complete

Essential Skills:

• MS SQL Server
• Data mapping and profiling techniques
• ETL tools, (SSIS, Informatica)
• Business Intelligence projects