ETL/Snowflake Developer - W2 Requirement

Job Title: ETL/Snowflake Developer - W2 Requirement

Location: NYC, NY – Remote

Experience: 5+ yrs

Duration: Contract

Note: Certifications: SnowPro Core or SnowPro Advanced Architect certifications.

 

Job Description :

We are seeking an experienced ETL / Snowflake Developer to drive the design, development, and execution of our enterprise cloud data architecture. In this role, you will coordinate with a team of data engineers, architect robust ETL/ELT pipelines, and optimize our Snowflake Data Cloud ecosystem. You will serve as the technical authority for data integration, warehousing best practices, performance tuning, and cross-functional collaboration with analytics and business stakeholders.

 

Key Responsibilities

Architecture Development: Design and build scalable secure and fault-tolerant ETL/ELT pipelines to ingest structured and semi-structured data into Snowflake.

 

Team : Technical leadership, code reviews, and mentorship for junior and mid-level data engineers.

Snowflake Optimization: Manage compute resources optimize storage costs, and implement auto-scaling and clustering strategies.

Data Pipelines Orchestration: Automate complex workflows using native Snowflake features (Snowpipe, Tasks, Streams) alongside orchestration engines

Data Modeling: Design star/snowflake schemas, Data Vault, or dimensional models aligned with business reporting needs.

Performance Tuning: Monitor Query Profiles, refactor complex SQL/stored procedures, and ensure sub-second response times for analytics workloads.

Governance Security: Implement Role-Based Access Control Object Tagging, Dynamic Data Masking, and secure data sharing across enterprise teams.

 

Required Qualifications Skills

Experience in ETL Development

Snowflake Expertise: hands-on experience with core Snowflake features

Advanced SQL Scripting: Expert proficiency in complex SQL, window functions, and procedure scripting in Python, JavaScript, or SQL Stored Procedures

Ecosystem Tools: Proven track record with dbt, Airflow, Matillion, Talend, or Informatica, alongside cloud platforms (AWS, Azure, or Google Cloud Platform)

 

Education: Bachelor’s degree in Computer Science, Information Technology, or a related quantitative field.

 

Preferred Qualifications

Certifications: SnowPro Core or SnowPro Advanced Architect certifications.

CI/CD DevOps: Hands-on experience with version control and infrastructure-as-code deployment pipeline

Streaming Data: Knowledge of real-time data streaming technologies into Snowflake

 

Back to blog

Other Jobs To Apply

Upto $200K/Year | Inpatient 7-On/7-Off | Dual-Certified PMHNP/FNP | Remote

Lead M&A Delivery

CAD Implementer (REMOTE-US)

Scientific Account Manager - Stem Cell Solutions- REMOTE

Regional Safety Leader - Remote Power & Energy

Sr. Program Manager (Healthcare)

Senior/Lead Software Engineer

Hubspot Marketing Consultant (Remote)- CONTRACT

Remote Sales Administrative Assistant

Remote eBay Expert

Electrical or Mechanical Commissioning Agent (Travel Required/Remote)

Senior Big Data Engineer: Snowflake + dbt (Remote)

Remote Senior Bioinformatics Manager, Genomics & Clinical

Business Process Analyst at General Dynamics: 100% Remote (LA)

Solution Architect – Agentic AI

NetSuite ARM Implementation Consultant - Senior Associate

PMT Engineer - Analytics and Automation

Payments & Product Partnerships Counsel, Americas

Financial Consultant I - Principal Connection

Dist Design Project Coord - Sr

Market Commentary Writer and Social Editor at Wealthfront: 100% Remote (San Francisco, CA, New York City, NY)

Global Total Rewards Lead

Remote Payroll Specialist | Flexible Hours & Growth

Entry-Level Auto Technician: Hands-On Tire & Maintenance

Senior Associate, Risk and Structuring Analytics

Services Project Coordinator

Software Developer/Senior Software Developer

Manager, Professional Services- Streaming Media

Varonis Careers - Technical Account Manager

Manager, Accounts Payable

Monday.com Consultant[remote]

Remote Electrical Engineer — Critical Power Systems

Platform Engineering & Reliability Specialist (Azure)

Remote Patient Scheduling Specialist (Part-Time, 20hrs/wk)

Remote Retirement Inside Sales Specialist

Remote SAP MM Consultant – Entry Level

Client Support Specialist - Greater Philadelphia, PA Area (REMOTE)

Customer Service Specialist I at Aon Plc: 100% Remote (Fort Washington, PA, US)

Services Project Coordinator

Appeals Nurse Consultant (Remote)

Servicing Travel Advisor III - Chase Travel (Remote - Tempe, AZ)

Programmatic Solutions Manager, Uber Advertising

Manager, Flight Maintenance - Traveling

Customer Service / Pizza Maker (01068) 28803 Northwestern Hwy, Southfield, MI

Guidewire Architect - PC/CC/BC

Notary Stamp Order Online | West College Corner, IN

Senior Analyst, Program Cost Controls (Remote)

Sr. Tech Business Developer, Just Walk Out Technology by Amazon - AWS Solutions

Medical Consultant

SENIOR DIGITAL SALES EXECUTIVE (REMOTE/USA) - KSLA (GDM - GRAY MEDIA GROUP)