B

Senior Snowflake Engineer

Bounteous United State
Remote Visa Sponsorship
Apply
AI Summary

Design, build, and optimize end-to-end Snowflake data platform architecture for scalable, secure analytics solutions. Own data ingestion, modeling, performance tuning, governance, and cost optimization across cloud environments. Requires 8+ years data engineering experience with expert SQL, dbt, Python, and Snowflake advanced features.

Key Highlights
8+ years data engineering experience with 3+ years Snowflake production
Expert SQL skills for complex query design and optimization
dbt proficiency for data transformation and modeling
Python programming for data processing and automation
Key Responsibilities
Design, develop, and maintain scalable data pipelines and ELT/ETL workflows on Snowflake
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
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 dbt, Git, and orchestration frameworks
Leverage advanced Snowflake features such as Snowpipe, Streams, Tasks, Time Travel, Dynamic Tables, and Snowpark
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
Technical Skills Required
Snowflake SQL dbt Python
Benefits & Perks
$91,000 - $119,000 annual salary
Remote work
Nice to Have
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 data (PII, PHI, financial data)
Experience building data or analytics solutions with LLMs and GenAI frameworks

Job Description


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 data (PII, PHI, financial data).
  • Experience building data or analytics solutions with LLMs and GenAI frameworks — prompt engineering, AI agents/copilots, and tools such as Snowflake Cortex, OpenAI APIs, or LangChain .

$91,000 - $119,000 a year

Individual pay is determined by many factors, including experience, relevant education or training, and organizational needs. The mid-range to maximum of the salary range is generally reserved for individuals who are highly experienced in the role.

We invite you to stay connected with us by subscribing to our monthly job openings alert here .

Bounteous is proud to be an equal opportunity employer. Bounteous does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, physical or mental disability, national origin, veteran status, or any other status protected under federal, state, or local law. Bounteous is willing to sponsor eligible candidates for employment visas.

#BI-Remote

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.


Similar Jobs

Explore other opportunities that match your interests

Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

clera

United State

Cloud Cyber Risk Manager

Devops
59m ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Deloitte

United State
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

Sentara Health

United State

Subscribe our newsletter

New Things Will Always Update Regularly