Senior Snowflake Data Engineer

ZipStaff•Chapel Hill, NC

1d•Remote

About The Position

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.

Requirements

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.

Responsibilities

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.