Data Migration Analyst in Manchester, North West

Data Migration Analyst
Contract
CRM Migration
Inside IR35
£450.00 - £475.00p/d
6 Months+
Manchester - Compulsory 2 days per week on-site
ASAP Start

Key Responsibilities

• Data Analysis & Discovery
  • Assess source systems to understand data structures, relationships, quality issues, and dependencies
  • Profile data to identify anomalies, inconsistencies, and transformation challenges
  • Collaborate with business and technical stakeholders to clarify data definitions and migration rules 

• ETL Design & Development
  • Design and build scalable ETL pipelines that extract, transform, and load data according to defined mappings and rules
  • Develop and document complex transformation logic with clear lineage and traceability
  • Optimise ETL performance through tuning, parallelisation, and incremental load strategies 

• Testing & Validation
  • Define and execute data reconciliation, validation, and audit processes.
  • Implement repeatable test frameworks to ensure data integrity and completeness throughout migration cycles.
  • Work closely with testing teams to resolve data discrepancies and refine transformation logic 

• Data Quality & Governance
  • Enforce data quality controls, ensuring completeness, accuracy, and compliance with standards.
  • Identify and document source data issues and contribute to data cleansing strategies.
  • Support metadata management and ensure traceability of transformations 

• Collaboration & Continuous Improvement
  • Partner with solution architects, DBAs, and business SMEs to deliver migration solutions aligned with target architecture
  • Share best practices, mentoring team members on ETL principles and transformation techniques
  • Continuously review and enhance data migration methodologies and automation tools

Key Skills & Experience

• Multiple large scale data migration project experiences from design to completion, experience in a regulated environment a bonus
• Deep understanding of ETL design, implementation, and optimisation (e.g., SSMS, SSIS, Azure Data Factory)
• Proven ability to analyse complex data structures and devise effective transformation strategies
• Significant and deep hands-on experience with SQL, Stored Procedures and Data Profiling across relational and non-relational data sources
• Strong understanding of data mapping, lineage, transformation audit trails and reconciliation practices
• Familiarity with data migration strategies (incremental loads, delta handling, cutover, and rollback)
• Knows how to gain an adequate understanding of source data (data meaning, relationships, data quality issues)
• Experienced enough to know how to simplify ETL logic so that it is maintainable and not error prone
• Experienced with incremental loading and cutover strategies
• Prowess with data reconciliation and validation
• Project deliverables have included rehearsals, refinements, and learning cycles
• Experience of addressing NFRs for performance, scalability & reusability

Data Migration Analyst

Voceer presents this job opportunity for Uniting Ambition, a 50 person sized company who are categorized as a Recruitment Agency.

This position is being managed by Uniting Ambition, a reputable recruitment agency known for placing candidates in desirable positions.