Data Migration Engineer

Data Migration Engineer

London Freelance 84000 - 108000 £ / year (est.) Home office possible
T

At a Glance

  • Tasks: Join us as a Data Migration Engineer, transforming data for a digital policing vision.
  • Company: Work with a leading consultancy driving innovation in digital services.
  • Benefits: Enjoy remote work flexibility and competitive daily rates.
  • Why this job: Make a real impact on public service efficiency while enhancing your tech skills.
  • Qualifications: Proficiency in Azure tools, Python, and strong analytical skills required.
  • Other info: This is a contract role based in London, offering a dynamic work environment.

The predicted salary is between 84000 - 108000 £ per year.

Job Title: Data Migration Engineer

Job Description

Our consultancy client are looking for a Data Migration Engineer to work with one of their end clients on one of their largest programmes, aimed at supporting their digital policing vision. As a Data Migration Engineer, you will play a key role in maintaining and modernising the application landscape, refreshing legacy applications, and delivering upgrades that enhance digital service performance. Your work will help optimise management processes, boost innovation, and enable officers to deliver efficient and cost-effective services.

Responsibilities

  • Define Physical Data Models and input into their development.
  • Design and deliver data mapping rules detailing the transformation from source to target.
  • Develop and build ETL routines using Azure Data Factory, Azure Synapse, and Databricks.
  • Conduct code reviews of colleagues\’ ETL routines.
  • Engage with clients to gather requirements and deliver the data management solution.
  • Estimate the effort required to deliver the data management solution.

Essential Skills

  • Proficiency in developing data transformation code using Azure Data Factory, Azure Synapse, Databricks, Python, and Pyspark.
  • In-depth knowledge of data warehouse designs, including slowly changing dimensions.
  • Experience with relational and database technologies such as Oracle and SQL Server.
  • Strong analytical skills and a logical approach to problem-solving.
  • Excellent organisational and coordination skills.
  • Exceptional communication skills, both oral and written.
  • Understanding of data quality and data profiling tools.
  • Knowledge of Master Data Management theory and applications.
  • Experience with at least one BI tool.

Additional Skills & Qualifications

  • Experience in data governance, data quality, data analysis, and data management.
  • Proven track record in migration projects.
  • Ability to work collaboratively within a team.

Job Type & Location

This is a Contract position based out of London, United Kingdom supporting fully remote working.

Location

London, UK

Rate/Salary

350.00 – 390.00 GBP Daily

Trading as TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom. No. 2876353. Allegis Group Limited operates as an Employment Business and Employment Agency as set out in the Conduct of Employment Agencies and Employment Businesses Regulations 2003. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as \”Allegis Group\”). Aerotek, Aston Carter, EASi, Talentis Solutions, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands. If you apply, your personal data will be processed as described in the Allegis Group Online Privacy Notice available at

To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go to

We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the \”Contacting Us\” section of our Online Privacy Notice at for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. If you are resident in the UK, EEA or Switzerland, we will process any access request you make in accordance with our commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield.

#J-18808-Ljbffr

Data Migration Engineer employer: TEKsystems, Inc.

As a Data Migration Engineer with our consultancy client, you will be part of a dynamic team dedicated to transforming digital policing in London. The company fosters a collaborative work culture that prioritises innovation and professional growth, offering opportunities to enhance your skills in cutting-edge technologies like Azure and Databricks. With the flexibility of fully remote working, you can enjoy a balanced work-life while contributing to meaningful projects that make a real impact on public service efficiency.
T

Contact Detail:

TEKsystems, Inc. Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Migration Engineer

✨Tip Number 1

Familiarise yourself with Azure Data Factory, Azure Synapse, and Databricks. Since these tools are essential for the role, showcasing your hands-on experience or any relevant projects during discussions can set you apart from other candidates.

✨Tip Number 2

Brush up on your knowledge of data warehouse designs, especially slowly changing dimensions. Being able to discuss these concepts confidently will demonstrate your expertise and understanding of the complexities involved in data migration.

✨Tip Number 3

Prepare to engage with clients effectively by practising your communication skills. Since you'll be gathering requirements, being articulate and clear in your explanations will help build trust and rapport with stakeholders.

✨Tip Number 4

Showcase your analytical and problem-solving skills through examples from past experiences. Be ready to discuss specific challenges you've faced in data migration projects and how you overcame them, as this will highlight your capability to handle similar situations in the new role.

We think you need these skills to ace Data Migration Engineer

Proficiency in Azure Data Factory
Experience with Azure Synapse
Knowledge of Databricks
Strong Python programming skills
Familiarity with Pyspark
In-depth understanding of data warehouse designs
Experience with slowly changing dimensions
Proficient in relational database technologies such as Oracle and SQL Server
Strong analytical skills
Logical problem-solving abilities
Excellent organisational skills
Exceptional written and verbal communication skills
Understanding of data quality and data profiling tools
Knowledge of Master Data Management theory
Experience with Business Intelligence (BI) tools
Experience in data governance
Experience in data quality and data analysis
Ability to work collaboratively within a team
Proven track record in migration projects

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience with Azure Data Factory, Azure Synapse, and Databricks. Include specific examples of data migration projects you've worked on, showcasing your proficiency in developing data transformation code.

Craft a Compelling Cover Letter: In your cover letter, emphasise your analytical skills and problem-solving abilities. Mention your understanding of data quality and Master Data Management, and how these skills will contribute to the consultancy's digital policing vision.

Showcase Relevant Skills: Clearly list your technical skills relevant to the role, such as Python, Pyspark, and your experience with relational databases like Oracle and SQL Server. This will help demonstrate that you meet the essential skills required for the position.

Prepare for Technical Questions: Anticipate technical questions related to data mapping rules and ETL routines. Be ready to discuss your previous experiences in detail, including any challenges you faced and how you overcame them during migration projects.

How to prepare for a job interview at TEKsystems, Inc.

✨Showcase Your Technical Skills

Make sure to highlight your proficiency in Azure Data Factory, Azure Synapse, and Databricks during the interview. Be prepared to discuss specific projects where you've used these tools, as well as any challenges you faced and how you overcame them.

✨Understand Data Migration Processes

Familiarise yourself with the data migration lifecycle, including data mapping, ETL processes, and data quality assurance. Being able to articulate your understanding of these concepts will demonstrate your expertise and readiness for the role.

✨Prepare for Scenario-Based Questions

Expect scenario-based questions that assess your problem-solving skills. Think of examples from your past experiences where you successfully managed data migration projects or resolved issues related to data quality and governance.

✨Communicate Effectively

Since exceptional communication skills are essential for this role, practice articulating your thoughts clearly and concisely. Be ready to explain complex technical concepts in a way that non-technical stakeholders can understand, as you'll likely engage with clients during the project.

T
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>