Snowflake Architect

Stanley David and Associates; Basildon; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A data solutions company is seeking a Snowflake Architect based in Basildon, UK. The role involves designing and maintaining data pipelines, implementing data warehousing solutions, and collaborating with stakeholders to fulfill data requirements. Candidates should have a bachelor's degree, over 5 years of experience in data engineering, and proficiency in SQL, Python, and Snowflake. A hybrid work model is offered, along with the opportunity to work with AWS technologies and modern data integration techniques.

Qualifications

• 5+ years of experience in data engineering, with a strong focus on Snowflake and AWS.
• Hands-on experience with data migration to Snowflake.
• Deep knowledge of key non-functional requirements such as availability, scalability, operability, and maintainability.

Responsibilities

• Design, develop, and maintain data pipelines and ETL processes using Snowflake on AWS.
• Implement data warehousing solutions for large datasets.
• Collaborate with stakeholders to fulfill data requirements.

Skills

SQL

Python

ETL tools (Streamsets, DBT)

Data warehousing concepts

Problem-solving skills

Communication skills

Orchestration solutions (Airflow)

Education

Bachelor’s degree in computer science, Engineering, or a related field

Tools

Snowflake

AWS Services (S3, Lambda, Redshift, Glue)

Oracle RDBMS

Job description

Role: Snowflake Architect

Location: Basildon, UK / Dublin, Ireland

Work mode: Hybrid

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 fulfill 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 modeling.

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