Data Engineer
Summary
Senior Data Engineer leads DB2-to-Azure SQL migrations, builds ETL/ELT pipelines, and ensures data quality for a cloud-based platform.
Davidson Technology Consulting is a boutique, expert-driven business and technology consultancy on a mission to help organisations drive lasting change. We empower clients to build high-performing functions while leveraging our expertise to lead transformation and innovation.
Our consulting teams partner with clients to solve complex business and technology challenges through practical delivery, transformation leadership, and modern ways of working. We bring together strategy, design, delivery, architecture, and emerging technology capability to help organisations move from ambition to execution.
About the Role
We are seeking an experienced Senior Data Engineer to lead the migration of enterprise data from IBM DB2 platforms to an Azure-based SQL database environment. The role will be responsible for assessing migration approaches, designing and implementing data migration solutions, developing ETL/ELT pipelines, validating data quality, and ensuring the successful transition of critical business data to the Azure ecosystem.
The successful candidate will work closely with business stakeholders, solution architects, application teams, infrastructure teams, and project delivery teams to deliver a scalable, secure, and performant cloud-based data platform.
About You
Required Experience
- 7+ years of Data Engineering experience.
- Proven experience migrating enterprise databases to Azure.
- Experience with DB2 to SQL Server or Azure SQL migrations.
- Strong understanding of performance tuning and query optimisation.
- Experience implementing automated deployment and testing practices.
- Experience working within Agile project delivery environments.
Preferred Skills
- Experience with Azure Synapse or Fabric.
- Experience with Change Data Capture (CDC) tools.
- Knowledge of data governance and security frameworks
- Experience in regulated or enterprise-scale environments.
- Familiarity with Data Vault or modern data warehouse methodologies.
- Strong problem-solving and analytical skills.
- Ability to lead technical design discussions.
- Excellent stakeholder management and communication.
- Strong documentation and technical writing skills.
- Ability to manage competing priorities and delivery deadlines.
- Mentoring and leadership capabilities.
- Risk identification and mitigation expertise.