Snowflake Data Architect

Snowflake Data Architect

Basildon Full-Time 48000 - 72000 £ / year (est.) No home office possible
Go Premium
Avensys Consulting

At a Glance

  • Tasks: Design and maintain data pipelines using Snowflake on AWS, ensuring data quality and integrity.
  • Company: Join Avensys, a top IT services company based in Singapore with a global client base.
  • Benefits: Enjoy work-life balance and the chance to expand your skill set in a dynamic environment.
  • Why this job: This role offers exciting challenges, collaboration with experts, and the opportunity to impact various industries.
  • Qualifications: Bachelor's degree in a related field and 5+ years of experience in data engineering required.
  • Other info: Work from client offices in Basildon or Dublin, engaging in cutting-edge cloud technologies.

The predicted salary is between 48000 - 72000 £ per year.

Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success, we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail and supply chain.

We are currently looking for a Data Architect who has a proven track record in the IT industry. This is an exciting opportunity to expand your skill set, achieve job satisfaction and work-life balance.

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

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.
Avensys Consulting

Contact Detail:

Avensys Consulting Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Snowflake Data Architect

✨Tip Number 1

Familiarise yourself with Snowflake and AWS services. Since the role specifically requires expertise in these areas, consider taking online courses or certifications to deepen your knowledge and demonstrate your commitment to potential employers.

✨Tip Number 2

Network with professionals in the data engineering field, especially those who work with Snowflake. Attend industry meetups or webinars to connect with others and learn about job openings that may not be advertised widely.

✨Tip Number 3

Showcase your problem-solving skills by preparing examples of past projects where you optimised data pipelines or resolved complex data issues. Be ready to discuss these experiences during interviews to highlight your practical knowledge.

✨Tip Number 4

Stay updated on the latest trends in data engineering and cloud technologies. Follow relevant blogs, podcasts, or forums to keep your knowledge fresh and be able to discuss current best practices during your interview.

We think you need these skills to ace Snowflake Data Architect

Snowflake
AWS
ETL Processes
Data Warehousing
SQL
Python
Streamsets
DBT
Oracle RDBMS
Data Migration
AWS S3
AWS Lambda
AWS Redshift
AWS Glue
Data Modelling
Problem-Solving Skills
Communication Skills
Data Pipeline Monitoring
Airflow
Performance Optimisation
Scalability

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience with Snowflake, AWS, and data engineering. Use specific examples that demonstrate your skills in designing data pipelines and ETL processes.

Craft a Compelling Cover Letter: Write a cover letter that connects your background to the responsibilities listed in the job description. Emphasise your problem-solving skills and your ability to collaborate with various stakeholders.

Showcase Relevant Projects: If you have worked on projects involving data migration to Snowflake or using AWS services, include these in your application. Detail your role and the impact of your contributions.

Highlight Continuous Learning: Mention any recent courses or certifications related to data engineering, cloud technologies, or Snowflake. This shows your commitment to staying updated with industry trends and best practices.

How to prepare for a job interview at Avensys Consulting

✨Showcase Your Technical Skills

Be prepared to discuss your experience with Snowflake and AWS in detail. Highlight specific projects where you've designed data pipelines or implemented data warehousing solutions, as this will demonstrate your hands-on expertise.

✨Understand the Company’s Needs

Research Avensys and their client base. Understanding their industry focus, especially in banking, healthcare, and retail, will help you tailor your responses to show how your skills can meet their specific challenges.

✨Prepare for Problem-Solving Questions

Expect questions that assess your problem-solving abilities, particularly around data quality and integrity issues. Be ready to share examples of how you've monitored and resolved data pipeline issues in the past.

✨Communicate Clearly and Effectively

Since excellent communication skills are crucial for this role, practice explaining complex technical concepts in simple terms. This will help you connect with interviewers who may not have a technical background.

Snowflake Data Architect
Avensys Consulting
Location: Basildon
Go Premium

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>