Snowflake Architect

Mandatory Skills Required:

• Data Architecture
• Data Migration
• Data Modeling
• Snowflake Designer/Developer
• DBT (Data Build Tool)
• ETL Design
• AWS Services - including S3, ETL/EMR, Security, Lambda, etc.
• StreamSet
• Python Programming
• Leadership and Team Handling
• Strong Communication and Collaboration Skills

Role: Snowflake Architect

Location: Basildon, UK/Dublin, Ireland

Work from Client office 5 days weekly

Responsibilities:

-Design, develop, and maintain robust data pipelines and ETL processes using Snowflake on AWS.

-Implement data warehousing solutions, ensuring efficient storage, retrieval, and transformation of large datasets.

-Collaborate with data analysts, scientists, and other stakeholders to define and fulfil data requirements.

-Optimize performance and scalability of Snowflake data warehouse, ensuring high availability and reliability.

-Develop and maintain data integration solutions, ensuring seamless data flow between various sources and Snowflake.

-Monitor, troubleshoot, and resolve data pipeline issues, ensuring data quality and integrity.

-Stay up-to-date with the latest trends and best practices in data engineering and cloud technologies. Cloud Services such as AWS

Qualifications:

>Bachelor's degree in computer science, Engineering, or a related field.

>5+ years of experience in data engineering, with a strong focus on Snowflake and AWS.

>Proficiency in SQL, Python, and ETL tools (Streamsets, DBT etc.)

>Hands on experience with Oracle RDBMS

>Data Migration experience to Snowflake

>Experience with AWS services such as S3, Lambda, Redshift, and Glue.

>Strong understanding of data warehousing concepts and data modelling.

>Excellent problem-solving and communication skills, with a focus on delivering high-quality solutions.

>Understanding/hands on experience in Orchestration solutions such as Airflow

>Deep knowledge of key non-functional requirements such as availability, scalability, operability, and maintainability

Evaluation will be done according to below:

Area of Assessment

Priority

Data Architect

Must Have

Data Migration

Must Have

Data Modeling

Must Have

DBT Knowledge

Should Have

ETL Design

Must Have

Snowflake Designer/Developer

Must Have

AWS (S3, ETL/EMR, Security, Lambda etc )

Must Have

Leadership/Team handling

Must Have

Communication and Collaboration

Must Have

StreamSet

Should Have

Python

Should Have