Snowflake Developer

Keyrus·Remote(United States)
Software Development

WFA Digital Insight

The demand for skilled Snowflake developers has skyrocketed in recent years, with the global cloud analytics market projected to reach $40 billion by 2027. As companies increasingly rely on data-driven insights to drive business decisions, professionals with expertise in Snowflake, SQL, and Python are in high demand. With its strong reputation for innovation and technology, Keyrus is an attractive employer for those looking to grow their careers in a fast-paced consulting environment. Before applying, candidates should be prepared to showcase their technical skills, experience working with cross-functional teams, and ability to adapt to a dynamic and challenging environment.

Job Description

About the Role

As a Snowflake Developer at Keyrus, you will play a critical role in developing, maintaining, and optimizing data pipelines and transformations using Snowflake, SQL, and Python. You will be part of a dynamic and fast-paced consulting environment, working closely with senior engineers, architects, and client teams to deliver high-quality data products. Your expertise in Snowflake, SQL, and Python will be essential in supporting the implementation of scalable and efficient data solutions for enterprise clients.

The role entails working on a variety of projects, from building and maintaining batch and near real-time data pipelines for analytics and reporting use cases to developing transformation logic using SQL and frameworks such as dbt. You will also be responsible for performing data validation, testing, and troubleshooting to ensure data quality and reliability.

Keyrus values professionals who are detail-oriented, care about data quality and performance, and feel comfortable collaborating with others in a team environment. If you are adaptable, proactive, and excited to be part of a fast-paced consulting environment, this role may be an excellent fit for you.

What You Will Do

  • Develop, maintain, and optimize data pipelines and transformations using Snowflake, SQL, and Python
  • Support the implementation of scalable and efficient data solutions for enterprise clients
  • Work closely with senior engineers, architects, and client teams to deliver high-quality data products
  • Build and maintain batch and near real-time data pipelines for analytics and reporting use cases
  • Develop transformation logic using SQL and frameworks such as dbt
  • Support data ingestion processes using APIs, file-based ingestion, or ELT tools
  • Perform data validation, testing, and troubleshooting to ensure data quality and reliability
  • Contribute to performance optimization and cost efficiency in Snowflake workloads
  • Apply best practices in data modeling, data governance, and pipeline orchestration
  • Collaborate in Agile/Scrum environments, contributing to sprint planning and delivery
  • Communicate progress and technical challenges clearly with internal teams

What We Are Looking For

  • 4-6 years of experience in data engineering, databases, or data-related roles
  • Minimum 2 years of hands-on experience working with Snowflake
  • Strong proficiency in SQL (advanced querying, transformations, optimization)
  • Experience with Python for data processing, automation, or pipeline development
  • Experience building and maintaining data pipelines and ETL/ELT processes
  • Good understanding of data warehousing concepts and modern data architecture
  • Experience with data integration patterns (APIs, flat files, streaming)
  • Familiarity with tools like dbt, Airflow, or similar
  • Experience working in cloud environments (AWS, Azure, or GCP)
  • Strong problem-solving and communication skills
  • Experience working in Agile environments

Nice to Have

  • Snowflake certifications (SnowPro Core or similar)
  • Experience with Snowpark, Streams & Tasks, or other advanced Snowflake features
  • Exposure to BI/reporting tools
  • Consulting experience or stakeholder interaction

Benefits and Perks

  • Competitive benefits and multiple opportunities for professional growth
  • 100% remote work with the possibility of 10-20% travel depending on the position
  • Challenging environment with cutting-edge technologies in the world of consulting
  • Great Place to Work certified
  • Diversity and inclusion-focused work environment
  • Opportunities for career advancement and skill development
  • Access to the latest tools and technologies in the field

How to Stand Out

  • Develop a strong foundation in Snowflake, SQL, and Python to increase your chances of success in this role.
  • Create a portfolio that showcases your experience in building and maintaining data pipelines and transformations.
  • Be prepared to talk about your experience working with cross-functional teams and your ability to adapt to a dynamic and challenging environment.
  • Highlight your problem-solving skills and ability to communicate technical challenges clearly.
  • Research Keyrus and its values to demonstrate your interest in the company and the role.
  • Practice your skills in data validation, testing, and troubleshooting to be prepared for technical questions during the interview process.

This is a remote position listed on WFA Digital, the platform for professionals who work from anywhere. Browse more remote jobs across all categories.