Snowflake Solution Architect

Bounteous is a premier end-to-end digital transformation consultancy dedicated to partnering with ambitious brands to create digital solutions for today’s complex challenges and tomorrow’s opportunities. With uncompromising standards for technical and domain expertise, we deliver innovative and strategic solutions in Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing.

Our Co-Innovation methodology is a unique engagement model designed to align interests and accelerate value creation. Our clients worldwide benefit from the skills and expertise of over 4,000+ expert team members across the Americas, APAC, and EMEA. By partnering with leading technology providers, we craft transformative digital experiences that enhance customer engagement and drive business success.

We are seeking a Senior Snowflake Engineer to design, build, and optimize our cloud data platform. In this role, you will own the architecture of our Snowflake environment end to end — from data ingestion and modeling to performance tuning, governance, and cost optimization. You will partner with data engineers, analysts, and business stakeholders to deliver reliable, scalable, and secure data solutions that power analytics and decision-making across the organization. 

Information Security Responsibilities

  • Promote and enforce awareness of key information security practices, including acceptable use of information assets, malware protection, and password security protocols
  • Identify, assess, and report security risks, focusing on how these risks impact the confidentiality, integrity, and availability of information assets
  • Understand and evaluate how data is stored, processed, or transmitted, ensuring compliance with data privacy and protection standards (GDPR, CCPA, etc.)
  • Ensure data protection measures are integrated throughout the information lifecycle to safeguard sensitive information

Role and Responsibilities:

  • Design, develop, and maintain scalable data pipelines and ELT/ETL workflows on Snowflake, integrating data from diverse internal and external sources.

  • Architect and optimize Snowflake data models, schemas, and warehouses for performance, reliability, and cost efficiency.

  • Implement and enforce data governance, security, role-based access controls, and data quality standards across the platform.

  • Monitor and tune warehouse performance, query execution, and resource consumption to control costs and meet SLAs.

  • Build and maintain CI/CD pipelines for data infrastructure using tools such as dbt, Git, and orchestration frameworks (e.g., Airflow).

  • Leverage advanced Snowflake features — Snowpipe, Streams, Tasks, Time Travel, Dynamic Tables, and Snowpark — to deliver near-real-time and automated data solutions.

  • Collaborate with analysts, data scientists, and business stakeholders to translate requirements into robust data solutions.

  • Mentor junior engineers, conduct code reviews, and establish best practices for data engineering across the team. 

Required Qualifications:

  • 8+ years of data engineering experience, with 3+ years of hands-on Snowflake development in a production environment.

  • Expert-level SQL skills, including complex query design, optimization, and performance tuning.

  • Strong experience designing dimensional and/or data vault data models and building ELT pipelines.

  • Proficiency with dbt for data transformation and modeling.

  • Hands-on experience with at least one cloud platform (AWS, Azure, or GCP) and its data services.

  • Programming proficiency in Python for data processing, automation, and scripting.

  • Proficiency using GenAI and AI-assisted development tools (e.g., Claude Code, ChatGPT/OpenAI, GitHub Copilot, Cursor) to accelerate coding, debugging, and documentation.

  • Experience with workflow orchestration tools such as Airflow, Dagster, or Prefect.

  • Solid understanding of data warehousing concepts, data governance, and security best practices.

  • Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience. 

Preferred Qualifications

  • SnowPro Core or Advanced certification.

  • Experience with Snowpark, Snowflake Cortex, or building data applications on Snowflake.

  • Familiarity with streaming technologies such as Kafka or Kinesis.

  • Experience with infrastructure-as-code tools (Terraform) and containerization (Docker, Kubernetes).

  • Background supporting BI and analytics tools (Tableau, Power BI, Looker).

  • Experience working in regulated industries or with sensitive
Back to blog

Other Jobs To Apply

No other job posts for this day.

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...