Lead Data Engineer - Azure PostgreSQL & Migration Expert

Scrumconnect Limited; Newcastle upon Tyne; On-site; GBP 75,000 - 110,000; Full time

Job summary

Scrumconnect Consulting in Newcastle, United Kingdom, is seeking a Lead Data Engineer to own the data migration capability for CRS, taking technical ownership of end-to-end delivery and ensuring data is migrated accurately and securely within programme timelines.

This senior role focuses on data migration, data modelling, ETL, and Azure PostgreSQL, with a strong emphasis on data quality, governance, and collaboration with business stakeholders to meet 140+ reporting needs.

Qualifications

• Senior/Lead Data Engineer with a strong focus on data migration.
• Extensive experience with ETL development and Azure PostgreSQL.
• Experience designing and delivering complex data migration solutions.

Responsibilities

• Design and deliver the end-to-end data migration strategy for CRS.
• Develop and implement ETL processes to Azure PostgreSQL.
• Design and maintain logical and physical data models for the target platform.
• Establish the data migration capability as the new platform becomes available.
• Define and implement approaches for moving CRS data into staging and production database environments.
• Develop robust processes for data extraction, transformation and loading.
• Ensure data quality, validation, reconciliation and governance throughout the migration lifecycle.
• Support the migration and transformation of data required for 140+ operational reports.
• Work closely with business and technical stakeholders to understand reporting requirements.
• Ensure target data structures support both current and future reporting requirements.
• Provide technical leadership and oversight across data migration and data modelling activities.
• Identify, assess and mitigate data migration risks.
• Troubleshoot complex data and database issues during migration.
• Ensure migration activities are delivered within agreed programme timescales.
• Establish repeatable and maintainable migration processes for ongoing operational use.
• Extensive experience as a Senior / Lead Data Engineer with a strong focus on data migration.
• Proven experience designing and delivering complex data migration solutions.
• Strong hands-on experience with ETL development and implementation.
• Strong experience working with Azure PostgreSQL.
• Excellent knowledge of relational databases and SQL.
• Strong experience in logical and physical data modelling.
• Experience designing database structures for operational and reporting requirements.
• Strong understanding of data quality, validation, reconciliation and governance.
• Experience migrating large or complex datasets between platforms.
• Experience designing staging and production data environments.
• Strong understanding of data transformation and mapping.
• Experience supporting reporting and analytics through well-designed data structures.
• Ability to provide technical leadership across data migration workstreams.
• Strong stakeholder management and communication skills.
• Experience identifying and managing data migration risks and dependencies.

Skills

ETL development

Azure PostgreSQL

Data migration

Data modelling

SQL

Data governance

Relational databases

Tools

Actian

Job description

Scrumconnect Consulting in Newcastle, United Kingdom, is seeking a Lead Data Engineer to own the data migration capability for CRS, taking technical ownership of end-to-end delivery and ensuring data is migrated accurately and securely within programme timelines.

This senior role focuses on data migration, data modelling, ETL, and Azure PostgreSQL, with a strong emphasis on data quality, governance, and collaboration with business stakeholders to meet 140+ reporting needs.