Senior Snowflake Developer

Contract, onsite Senior Snowflake Developer role in Trenton, NJ, focused on designing, developing, and optimizing Snowflake data solutions, ELT pipelines, and data governance within an Agile environment.

Responsibilities

• Create and sustain Snowflake schemas, data models, and data lake architectures
• Build efficient automated ELT pipelines to ingest data from a variety of enterprise sources into Snowflake
• Craft data transformation workflows using dbt and Snowflake features such as tasks and streams
• Develop custom data engineering scripts, automation pipelines, and UDFs with Python and Snowpark
• Tune query performance and virtual warehouse sizing via query profiles and automatic clustering
• Monitor and optimize Snowflake credit usage and warehouse costs
• Develop complex SQL queries, analytic functions, and advanced stored procedures
• Implement strong security and data governance controls 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 in Git with automated CI/CD deployment pipelines
• Implement disaster recovery using 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 for data engineering, including hands-on Snowpark
• Proven production experience using modern transformation tools, specifically dbt
• Solid experience with Snowflake cost management, infrastructure optimization, and performance tuning
• Deep understanding of enterprise data security, 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

Technologies

• Snowflake
• dbt (Data Build Tool)
• Python
• Snowpark
• SQL
• Git
• Snowflake Replication
• Failover Groups
• Time Travel

Physical Demands

• Ability to safely perform essential job functions in accordance with ADA and applicable standards
• Capability to conduct repetitive computer-based tasks using a mouse, keyboard, and monitor
• Ability to communicate with customers and team members by phone and in person
• Predominantly sedentary work with occasional movement around the office to attend meetings