My Shortlist

Your shortlisted jobs will appear here. To view your shortlist: Login Or Register

Date Added: Tue 17/01/2023

Migration Architect

Hounslow, TW3, UK
Apply Now


Job Type: Permanent, FullTime

Salary: £85000 - £100000/annum

Migration Architect

An excellent opportunity has arisen with our client, a global brand, for an experienced Migration Architect. The successful candidate will work on an exciting migration project, moving the on premise components from Teradata / Informatica to AWS / Snowflake.

Our client have a flexible approach to home working but will require weekly trips to their HQ's located in Heathrow.

The successful candidate will plan a migration strategy and solution for the on-premises components in cloud.

Role & Responsibilities:

Come up with migration strategy and solution for the on-premises components (Teradata/Informatica) in cloud (AWS PAAS services + Snowflake)
Design, review, and approve all objects that will be part of the database
Establish and maintain meta data standards
Coordinate with the business staff and the warehouse support staff in matters regarding meta data capture and meanings, schema modifications and enhancements
Develop and maintain technical documentation about the data
Coordinate with the ETL specialist on data mappings and conversion rules, and with the DBA for instantiating logical schemas into physical schemas
Enforce applicable standards, policies, procedures, and best practices in the implementation and/or maintenance of ETL mappings
Architect the modern data platforms while leveraging cloud offerings such as AWS/SaaS/IaaS, other tools, tableau, Power BI
Create and maintain data definition language (DDL) that can be used to create and update the database
Essential Skills and Experience:

Proven experience as an Enterprise Data Vault Architect
Proficiency in the ETL design/development
Solid knowledge of various AWS PaaS services within data and analytics
Experience in migration of data from Legacy to Cloud environments (Migrating Teradata to Snowflake)
Background in data platform/pipeline management and performance optimisation
Ability to perform all the skills required for data warehouse design, implement and monitor.
Familiarity with designing and delivering data and analytics solutions for an enterprise which aligned to business drivers, architecture principle, and security policies.
Familiarity with a data strategy for enterprise and data management
Working experience of the Data Vault Model
Experience with Snowflake Data Warehouse projects

Up to £100K basic salary
Annual bonus scheme
Pension, health care, life assurance, laptop, phone, access to extensive training resources
Apply Now