Compunnel
Role Snowflake DBT Lead
Location New York, NY Onsite
Contract role – 6+ month
Job description
Design develop and maintain robust ETLELT pipelines using SQL DBT and Snowflake
Perform data matching processes using various methodologies Union Union Precision Columns Joined Precision Columns
Configure data loads and creating data pipeline workflows for customer
Write optimize the DMLDDL Operations in snowflake
Required Skills Qualifications
5- 10 years of experience in data engineering ETL development or analytics engineering
Expertlevel proficiency in SQL and Snowflake
Snowflake Databases Schemas Tables Views Procedures Datashare Roles Staging Production Work area Sandbox Partition Date SQL SELECT WHERE ORDER BY qualify rownumber MAX etc
Handson experience with DBT Data Build Tool in enterprise environments
Experience with Airflow Jobs Orchestration AutomationOrchestration Dag DailyWeekly Cadence scripting
Experience in Python scripting
File Formats Compression Parquet CSV GZ bzip
Exposure and Experience in matching methodologies Union Union Precision Columns Joined Precision Columns
Strong understanding of data architecture data modeling and pipeline orchestration
To apply for this job email your details to krish@compunnel.com