Senior Snowflake Software Developer

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. With over 40 years of excellence, we unite talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we create tailor-made solutions across the public and commercial sectors and are trailblazers in bringing neurodiversity to the enterprise.

About the role

We are looking for a Senior Snowflake Software Developer to design, develop, and optimize Snowflake data solutions for enterprise-level applications. This is a full-time, hybrid position with employees expected to work onsite 3 days per week. Only candidates with work authorizations that do not require sponsorship now or in the future will be considered.

Responsibilities

• 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

Requirements

• 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 Qualifications

• Snowflake certifications (such as SnowPro Core or Advanced)
• Agile Scrum team collaboration experience

Benefits

• Medical, dental, and vision insurance
• 401k retirement account access
• Paid sick leave and other paid time off as provided by applicable law

Pay

$70 - $80 per hour. Exact compensation may vary based on location, experience, and education.

Schedule

Hybrid, with employees expected to work onsite 3 days per week.