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
Never miss an opportunity! Create an alert based on the job you applied for.