# Snowflake Developer — Ascent It Solutions

- Location: Kearny, NJ (remote)
- Posted: Sep 1, 2021
- Status: open (checked Nov 18, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/ascentitsolutions/743999770170872
- Employer record: https://visajobs.io/company/ascent-solutions.md

## Sponsorship history
- Tier: Some history
- Occupation (SOC): Software Developers (15-1252)
- Employer's certified LCAs for this occupation in NJ, FY2024–FY2026: 0
- …in the whole US: 6
- With this exact title: 0
- Median DOL prevailing wage, level I / II: $95k / $124k
- Staffing / consulting firm: 93% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
Job Description
Role: Sr. Snowflake Tech Lead/Sr. Snowflake Developer
2 positions (9+ years)
Remote role (Client Location: NC/NJ)
Key Responsibilities:
• Understand the current Snowflake implementation
• Recommend re-platforming to leverage ‘Snowflake’ way of working like
1. Leveraging compute-compute separation, task, streams and snowpipe for near real time ELT
2. Leveraging Variant support for avoiding complex ETL around JSON/XML processing
3. Leveraging features like zero copy clone and time travel to increase efficiency in dev/test/prod environments etc
• Replatform POC to gauge advantage and standardize the replatforming architecture
• Hands on coding on Snowflake side
• Build reference implementations and reusable components
• Data modeling as needed
• Help with replatforming planning and implementation
Profile Expected:
1. 10-15 years of experience with 2-3 years spent on Snowflake
2. Implemented green field Snowflake as Data Lake or DWH workloads
3. Strong data engineering background
4. Nice to have – knowledge of Data Guise, and Collibra and its integration with Snowflake
Additional Comments:
• Heavily using Datastage in classic ETL way. Need to re-engineer to classic ELT way.
• Transformation heavy consultants who have expertise in Snowflake Stored Procs, SnowSQL, DBT etc.
• Knowledge of Data Stage or other ETL tool like Informatica would be useful.
Qualifications
Master's Degree / Bachelor’s degree in Computer Science, Electrical/Electronic Engineering, Information System
Additional Information
All your information will be kept confidential according to EEO guidelines.

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
