Cloud Architect - Snowflake (65k base + 15% cash flex + 15% bonus)

Location: London

Overview:

We are seeking an experienced Cloud Architect to create design documents, develop enterprise data models, and ensure seamless data integration and migration using modern technologies.

Key Responsibilities:

• Design data hydration process for Teradata/Hadoop to Data Lake (S3) and to Snowflake migration using AWS Services, Glue, DBT, and Snowflake.
• Create business cases for wider implementation, including business benefits, ROI, features comparison, and cost comparison of on-premises and cloud solutions.
• Simplify current architecture by reducing data redundancy, removing silos in data, metadata, and technology, and adopting data product and data mesh architecture.
• Design and Develop logical and physical data models in Snowflake.
• Design a framework for Teradata BTEQ and ETL code conversion to DBT and Snowflake SQL.
• Design Enterprise Metadata Hub for resigtering metada from Alation, Glue Catalog, DBT, and Snowflake.
• Design Data Product Pipelines for functional, cross-domain, and business data products in Snowflake.
• Design a semantic layer in Snowflake and Starburst for analytics and reporting use cases.
• Design orchestration pipelines using GitHub, Step Function, and Airflow.

Qualifications:

• Proven experience as a Cloud Architect or similar role.
• Expertise in AWS, Snowflake, and DBT
• Strong knowledge of data modelling and ETL processes.
• Experience with metadata management tools (Alation, Glue Catalog).
• Proficiency in SQL and Teradata BTEQ scripts.
• Familiarity with Git, Jenkins, and Airflow

Damia Group Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept our Data Protection Policy which can be found on our website.

Please note that no terminology in this advert is intended to discriminate on the grounds of a person's gender, marital status, race, religion, colour, age, disability or sexual orientation. Every candidate will be assessed only in accordance with their merits, qualifications and ability to perform the duties of the job.

Damia Group is acting as an Employment Business in relation to this vacancy and in accordance to Conduct Regulations 2003.