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 worklo.

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