Senior Snowflake Data Engineer - Remote Contract

ZipStaff Inc.; Chapel Hill (NC); Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

401(k) + 401(k) matching

Paid time off

Referral Program

Job summary

ZipStaff is seeking a hands-on Senior Snowflake Data Engineer for a contract role in a Data and Analytics function at a professional services and accounting firm. You will write pipelines daily into Snowflake as an individual contributor, not a manager or architect. This position is remote in the U.S.

with required overlap of U.S. and Ireland hours. Responsibilities include designing and deploying ETL/ELT pipelines with Informatica IDMC, Azure Data Factory, and dbt; ensuring data quality and

Qualifications

• 8+ years in data engineering with modeling, ETL/ELT, and warehousing.
• 6+ years hands-on Snowflake architecture and current features.
• Complex SQL proficiency under questioning.
• Substantial dbt experience for transformations, not tutorials.
• Azure stack including SQL Server, Synapse, ADF, Databricks, Cosmos DB, Power BI.
• Informatica IDMC: Cloud Data Integration and exposure to CDGC/MDM/Data Quality.
• Programming in Python, C#, or Java.
• Able to overlap US and Ireland hours.
• US Citizen or Green Card only; no sponsorship.

Responsibilities

• Design, build, and deploy ETL/ELT pipelines into Snowflake.
• Integrate databases, warehouses, APIs and external systems, and cleanse/aggregate/enrich data.
• Tune pipelines and Snowflake workloads for performance.
• Put data-quality checks in the pipeline.
• Partner with architects, data scientists, and AI engineers without handing them the build.

Skills

Snowflake

SQL

dbt

ETL/ELT

Python

C#

Java

Data engineering

Data modeling

Tools

Informatica IDMC

Azure Data Factory

dbt

Snowflake

Power BI

Databricks

SQL Server

Synapse

Cosmos DB

Job description

ZipStaff is seeking a hands-on Senior Snowflake Data Engineer for a contract role in a Data and Analytics function at a professional services and accounting firm. You will write pipelines daily into Snowflake as an individual contributor, not a manager or architect. This position is remote in the U.S.

with required overlap of U.S. and Ireland hours. Responsibilities include designing and deploying ETL/ELT pipelines with Informatica IDMC, Azure Data Factory, and dbt; ensuring data quality and