Job Description
We are looking for a Senior Snowflake Software Developer to design, develop, and optimize Snowflake data solutions for enterprise-level applications.
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.
Numbers & Facts
Location
Trenton, NJ
Skills
Access Controlunmatched
Agile Programming Methodologiesunmatched
Communication Skillsunmatched
Computer Scienceunmatched
Continuous Deployment/Deliveryunmatched
Continuous Integrationunmatched
Cost Controlunmatched
Cross-Functionalunmatched
Cryptographyunmatched
Data Lakeunmatched
Data Managementunmatched
Data Modelingunmatched
Data Qualityunmatched
Data Scienceunmatched
Data Warehousingunmatched
Database Administrationunmatched
Disaster Recoveryunmatched
Engineeringunmatched
Enterprise Protectionunmatched
Failoverunmatched
Gitunmatched
Information/Data Security (InfoSec)unmatched
Keyboardsunmatched
Performance Tuning/Optimizationunmatched
Problem Solving Skillsunmatched
Python Programming/Scripting Languageunmatched
Query Analysisunmatched
Query Optimizationunmatched
Replication and Remote Mirroringunmatched
Reporting Dashboardsunmatched
SQL (Structured Query Language)unmatched
Scripting (Scripting Languages)unmatched
Scrum Project Management and Software Developmentunmatched