Senior Snowflake Software Developer

Senior Snowflake Software Developer

Req number:

R7765

Employment type:

Full time

Worksite flexibility:

Hybrid

Who we are

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

We are looking for a motivated Senior Snowflake Software Developer ready to take us to the next level! If you have expert-level skills in Snowflake Cloud Data Platform, SQL, and enterprise data engineering and are looking for your next career move, apply now.

Job Description

We are looking for a Senior Snowflake Software Developer to design, develop, and optimize Snowflake data solutions for enterprise-level applications. This position will be full-time, and hybrid. With employees expected to work onsite 3 days per week.

Only work authorizations that will not require sponsorship now or in the future will be considered.

What You’ll Do

• Design and maintain Snowflake data schemas, models, and data lake architectures

• Develop efficient, automated ELT pipelines to ingest data from diverse enterprise sources into Snowflake

• Build data transformation pipelines utilizing dbt (Data Build Tool) and native Snowflake features like tasks and streams

• Write custom data engineering scripts, automation pipelines, and UDFs using Python and Snowpark

• Optimize query performance and virtual warehouse sizing using query profiles and automatic clustering

• Monitor, audit, and optimize Snowflake credit consumption and warehouse spending

• Write complex SQL queries, analytical functions, and advanced stored procedures

• Implement robust security and data governance measures, including RBAC, masking policies, and encryption

• Establish automated data quality validation frameworks, monitoring alerts, and observability dashboards

• Manage database infrastructure and dbt models as code within version control systems (Git) using automated CI/CD deployment pipelines

• Implement disaster recovery strategies utilizing Snowflake Replication, Failover Groups, and Time Travel

• Collaborate with cross-functional data, science, and analytics teams in an Agile/Scrum environment

What You'll Need

Required:

• Bachelor’s or Master’s degree in computer science, data engineering, or a related field

• 7+ years of experience in data warehousing, data modeling, and enterprise data engineering

• 3+ years of direct, hands-on production engineering experience inside Snowflake

• Strong proficiency in Python development tailored for data engineering, including hands-on Snowpark experience

• Proven production experience using modern transformation tools, specifically dbt (Data Build Tool)

• Solid experience with Snowflake cost management, infrastructure optimization, and performance tuning

• Deep understanding of enterprise data security, role-based access control (RBAC), and governance compliance

• Experience managing infrastructure as code via Git and automated CI/CD deployment pipelines

• Excellent problem-solving, communication, and Agile collaboration skills

Preferred:

• Snowflake certifications (such as SnowPro Core or Advanced)

• Agile Scrum team collaboration experience

Physical Demands 

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

• Must be able to communicate with customers/team members over the phone and in person

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

#LI-NA1

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodatio