Job description

Job Title: Senior Snowflake Data Engineer. Location: Remote (U.S. — must overlap U.S. and Ireland hours). Employment Type: Contract (W2 through ZipStaff — No C2C or 1099). About the Opportunity ZipStaff is seeking a hands-on Senior Data Engineer for a new Data and Analytics function at a professional services and accounting firm. You will write pipelines every day into Snowflake. This is an individual-contributor build seat — not an architect, not a manager, and not a production-support rotation. The current search is a replacement. The last two candidates were declined because Snowflake, SQL logic, and dbt were not deep enough. What You’ll Do: • Design, build, and deploy ETL/ELT pipelines with Informatica IDMC, Azure Data Factory, and dbt into Snowflake. • Integrate databases, warehouses, APIs, and external systems, and cleanse, aggregate, and enrich the data. • Tune pipelines and Snowflake workloads: bottlenecks, caching, and query performance. • Put data-quality checks in the pipeline. • Partner with architects, data scientists, and AI engineers without handing them the build. Required Qualifications: • 8+ years data engineering: modeling, ETL/ELT, warehousing. • 6+ years recent, hands-on Snowflake , including architecture and current features — not a one-year add-on. • Complex SQL you can finish correctly under questioning. • Substantial dbt for transformations, not a tutorial. • Azure: SQL Server, Synapse, Azure Data Factory , Databricks, Cosmos DB, and Power BI. • Informatica IDMC : Cloud Data Integration, and exposure to CDGC, MDM, or Data Quality. • Python, C#, or Java. • Able to overlap U.S. and Ireland hours. • U.S. Citizen or Green Card only. No sponsorship. Preferred Qualifications: • Snowflake, Azure Data Engineer, or dbt certification. • Professional services, accounting, or a managed-services environment. Benefits: • Health Insurance. • Dental Insurance. • Vision Insurance. • 401(k) + 401(k) matching. • Paid time off. • Referral Program. About ZipStaff ZipStaff partners with leading organizations to connect skilled technology professionals with high-impact contract opportunities. We focus on quality matches, clear communication, and long-term success for candidates and clients. To apply, submit your resume with dated Snowflake years, dbt models you own, and ADF or IDMC pipelines you built. Do not apply if Snowflake is under 6 years, if dbt is light, or if you are not a U.S. Citizen or Green Card holder. Pay: $54 - $55 per hour

Requirements

Must-haves

Job Title: Senior Snowflake Data Engineer.
Location: Remote (U.S. — must overlap U.S. and Ireland hours).
Employment Type: Contract (W2 through ZipStaff — No C2C or 1099).
Design, build, and deploy ETL/ELT pipelines with Informatica IDMC, Azure Data Factory, and dbt into Snowflake.
Integrate databases, warehouses, APIs, and external systems, and cleanse, aggregate, and enrich the data.
Tune pipelines and Snowflake workloads: bottlenecks, caching, and query performance.
Put data-quality checks in the pipeline.
Partner with architects, data scientists, and AI engineers without handing them the build.
8+ years data engineering: modeling, ETL/ELT, warehousing.
6+ years recent, hands-on Snowflake , including architecture and current features — not a one-year add-on.
Complex SQL you can finish correctly under questioning.
Substantial dbt for transformations, not a tutorial.
Azure: SQL Server, Synapse, Azure Data Factory , Databricks, Cosmos DB, and Power BI.
Informatica IDMC : Cloud Data Integration, and exposure to CDGC, MDM, or Data Quality.
Python, C#, or Java.
Able to overlap U.S. and Ireland hours.
U.S. Citizen or Green Card only. No sponsorship.

Nice-to-haves

Snowflake, Azure Data Engineer, or dbt certification.
Professional services, accounting, or a managed-services environment.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlazureaipythonjava

Platform: betterteam
Effort: medium

Benefits

Benefits detected in the listing.

Health Insurance

Dental

Vision

401(K)

Paid Time Off