Bounteous

Snowflake Solution Architect

Bounteous$102K — $133K *
US-AnywhereRemote in Canada
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of data engineering experience, including 3+ years of Snowflake development.
  • Expert-level SQL skills for complex query design and optimization.
  • Strong experience in dimensional or data vault modeling and ELT pipeline construction.
  • Proficiency in dbt for data transformation and modeling.
  • Hands-on experience with a cloud platform (AWS, Azure, or GCP) and related services.
  • Programming skills in Python for data processing and automation.
  • Familiarity with GenAI and AI-assisted development tools for coding.
  • Experience with orchestration tools like Airflow, Dagster, or Prefect.

Responsibilities

  • Design and maintain scalable data pipelines and ELT/ETL workflows on Snowflake.
  • Architect and optimize Snowflake data models and schemas for performance and cost efficiency.
  • Implement data governance and security measures across the platform.
  • Monitor and enhance warehouse performance and resource consumption.
  • Build and maintain CI/CD pipelines for data infrastructure tools.
  • Leverage advanced Snowflake features for automated data solutions.
  • Collaborate with stakeholders to translate requirements into data solutions.
  • Mentor junior engineers and establish best data engineering practices.

Benefits

  • Health, dental and vision insurance.
  • 401(k) with company match.
  • Generous paid time off and holiday schedule.
  • Opportunities for professional development and growth.
  • Remote work flexibility available.
Full Job Description
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. $102,000 - $133,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. #BI-Remote #LI-Remote

About Bounteous

Bounteous is a digital experience agency that provides services such as strategy, design, and development for clients in industries such as healthcare, retail, and financial services. The company was founded in 2003 in Chicago and has since expanded to have offices in North America and Europe. Bounteous has partnerships with major technology companies such as Adobe, Google, and Amazon Web Services. The company has won numerous awards for its work, including recognition from the Webby Awards and the Interactive Advertising Bureau.
Learn more about Bounteous
Size
500 employees
Industry
Founded
2003
5 Year Trend
+100%
Revenue
$50 million

Similar Jobs

More Jobs at Bounteous

More Information Technology Jobs

Find similar Snowflake Solution Architect jobs: