Senior Snowflake Developer
Position Type: Hybrid
Hybrid Schedule: Onsite 3 days per week
Contract Length: 3 months + extensions Position Overview:
We are seeking a Senior Snowflake Developer to design, build, and optimize scalable Snowflake-based data solutions supporting enterprise analytics and business operations. This role will focus on developing high-performance ELT pipelines, data transformation frameworks, and automation processes using Snowflake, dbt, Python, and Snowpark. The ideal candidate will bring strong expertise in data engineering, performance tuning, security governance, and CI/CD best practices while collaborating closely with cross-functional teams in an Agile environment. Duties:
- 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 liketasks 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
- 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.
- Snowflake certifications (such as SnowPro Core or Advanced).
- Agile Scrum team collaboration experience
Recommended Jobs
Restock & Floor Support
Job Description Job Description The right candidate will be people friendly, bring a high energy level and be eager to learn about wine, spirits and beer. Qualified candidates will demonstrate pr…
Principal D&A Portfolio & Operations (E6117)
Job Summary The Principal D&A Portfolio & Operations is a senior leader within the Data & Analytics organization accountable for the health alignment and execution of the entire D&A portfolio as…
OTR Dry Van Company Driver W2 Job in Carteret, NJ by American Trucking Group
Dry Van Company Driver W2 Truck Driving Jobs in Carteret, NJ Are you a qualified Class A CDL driver in search of a company that genuinely honors its commitments? At American Trucking Group, we d…
Lead Veterinarian / Medical Director - Blairstown, NJ | AAHA-Accredited Small Animal Practice Lead Veterinarian / Medical Director - Blairstown, NJ | AAHA-Accredited Small Animal Practice
We’re currently recruiting for a growing small animal practice in Blairstown, NJ, that is seeking a dedicated Medical Director to lead its veterinary team. The practice offers a supportive environm…
Shift Leader
Job Description Job Description Shift Leader The Shift Leader supervises shifts and/or work areas in the operation of a Papa John’s restaurant to ensure high quality products and customer serv…
Procurement Manager - Manufacturing
Job Details: Procurement Manager – Manufacturing We are seeking a hands-on Procurement Manager to lead procurement operations supporting aerospace, defense, and manufacturing programs. This rol…
Technology Support Specialist
Job Description Step into the role of technology support, where your expertise shapes the seamless tech experience in a dynamic cultural environment. As a Senior Support Specialist, Data Center…
MASTER PROFILE Director/ Assistant Director
Overview and Compensation A Director at The Goddard School is responsible for managing the program and curriculum. Additionally, the Director may be responsible for certain business tasks as delegate…
Personal Injury Attorney
Job Description Job Description Join an award winning firm with a supportive culture. Personal Injury Attorney Benefits: - Starting Salary starting in the $175K-$250K+ Range - Medical, Den…
Assistant Construction Manager, Site Operations
Pay Range: $25 to $35 per hour, based on experience Schedule: Monday through Friday, 6:00 AM to 4:00 PM Saturdays during busy periods Average 50 to 60 hours per week We are looking for a str…