Senior Snowflake Software Developer

Senior Snowflake Developer

Location: Trenton NJ (Hybrid)

Position Type: Contract


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.

• 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 Youll Need

Required:

• Bachelors or Masters 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.

Required Skills:

data warehousing data modeling and enterprise data engineeringSnowflakeSnowparkSnowflake cost managementinfrastructure optimizationperformance tuningRBACCI/CDAgile Scrum