At a Glance
- Tasks: Join our team to build and validate data migration pipelines in cloud environments.
- Company: Dynamic tech company focused on data and AI with a commitment to diversity.
- Benefits: Flexible work options, continuous learning opportunities, and a supportive environment.
- Other info: We promote equity and diversity, ensuring a welcoming workplace for all.
- Why this job: Make an impact by transforming data for modern cloud platforms and enhancing data quality.
- Qualifications: Experience in data migration, AWS services, and strong teamwork skills required.
The predicted salary is between 50000 - 65000 £ per year.
We are seeking a detail-oriented and capable Data Migration Engineer to join our Data & AI practice. The successful candidate will bring solid experience in data migration, ETL/ELT pipeline development, and cloud-based data platforms, with a focus on AWS Data Lakehouse environments. This role is key to supporting the design, build, and validation of data migration pipelines, enabling the successful transition of data from legacy systems to modern cloud platforms. You will contribute to ensuring data quality, integrity, and performance, particularly through structured testing and validation activities. You will work closely with architects, senior engineers, and analysts to deliver scalable and reliable migration solutions, using technologies such as AWS Glue, Apache Iceberg, Python/PySpark, SQL, and YAML configurations. You should be comfortable working in a collaborative, delivery-focused environment and have a strong interest in data migration, cloud technologies, and modern data engineering practices.
What you'll be doing:
- Client Engagement & Delivery
- Support delivery within data migration programmes, contributing to key workstreams
- Collaborate with architects, engineers, and stakeholders to implement migration solutions
- Assist in planning and executing data migration tasks and deliverables
- Data Migration Engineering
- Build and maintain data migration pipelines from legacy data warehouses to AWS-based platforms
- Support execution of bulk data migrations and incremental/delta loads
- Assist with pipeline repointing and migration to cloud environments
- Data Pipeline Testing & Validation (Core Focus)
- Test ETL/ELT data pipelines on AWS services, including AWS Glue and Apache Iceberg
- Support validation of data pipeline migrations to AWS Data Lakehouse architectures
- Execute and validate initial bulk data loads
- Write and run SQL queries to validate transformation outputs
- Support development of test scripts and validation checks
- AWS Data Platforms & Lakehouse
- Work with AWS services including AWS Glue and S3-based data lakes
- Support implementation of Data Lakehouse architectures, including Apache Iceberg
- Contribute to improving pipeline performance and reliability
- Data Transformation & Support
- Apply transformation logic based on defined data mapping rules
- Support preparation of data for target-state models
- Assist in ensuring consistency between source and target datasets
- Follow established engineering standards and best practices
- Contribute to documentation and reusable components
- Quality, Governance & Security
- Support maintenance of data quality and integrity during migration
- Follow secure data handling practices
- Assist with compliance requirements, including GDPR and public sector data standards (where applicable)
- Contribute to testing, validation, and audit activities
What experience you'll bring:
- Strong focus on testing, validation, and data quality assurance
- Ability to work across data pipelines and transformation workflows
- Good analytical and problem-solving skills
- Effective communication and teamwork skills
- Willingness to learn and develop in data migration and cloud technologies
Technical Expertise
- Hands-on experience with AWS cloud services, especially AWS Glue
- Python / PySpark
- SQL querying and validation
- Familiarity with data lake / Lakehouse concepts (e.g., Apache Iceberg)
- Basic understanding of ETL vs ELT approaches and cloud-based data architectures
- Exposure to version control and CI/CD tools desirable
What we’ll offer you:
We offer a range of tailored benefits that support your physical, emotional, and financial wellbeing. Our Learning and Development team ensures continuous growth and development opportunities for our people. We also offer flexible work options. We are an equal opportunities employer. We believe in the fair treatment of all our employees and commit to promoting equity and diversity in our employment practices. We are also a proud Disability Confident Committed Employer – we are committed to creating a diverse and inclusive workforce. We actively collaborate with individuals who have disabilities and long-term health conditions that affect their ability to perform normal daily activities, ensuring barriers are eliminated when it comes to employment opportunities. In line with our commitment, we guarantee an interview to applicants who declare to us, during the application process, that they have a disability and meet the minimum requirements for the role. If you require any reasonable adjustments during the recruitment process, please let us know. Join us in building a truly diverse and empowered team.
Data Migration Engineer in London employer: Women in Data®
As a Data Migration Engineer at our company, you will thrive in a collaborative and innovative environment that prioritises employee growth and development. We offer tailored benefits to support your wellbeing, flexible work options, and a commitment to diversity and inclusion, ensuring that every team member feels valued and empowered. Join us to work on cutting-edge cloud technologies while contributing to meaningful projects that enhance data quality and integrity.
StudySmarter Expert Advice🤫
We think this is how you could land Data Migration Engineer in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Women in Data®!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Migration Engineer at Women in Data®.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Women in Data®.
✨Apply Directly through Our Website
When you find a suitable opening like Data Migration Engineer at Women in Data®, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Migration Engineer in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Women in Data®, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Women in Data®. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Women in Data®
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Women in Data®!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
