[Hiring] Senior Snowflake Data Engineer @ZipStaff

Role Description

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.

• 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.

Qualifications

• 8+ years in data engineering: modeling, ETL/ELT, warehousing.
• 6+ years recent, hands-on Snowflake experience, including architecture and current features — not a one-year add-on.
• Complex SQL proficiency that can be demonstrated under questioning.
• Substantial dbt experience for transformations, not just a tutorial.
• Experience with Azure: SQL Server, Synapse, Azure Data Factory, Databricks, Cosmos DB, and Power BI.
• Informatica IDMC experience: Cloud Data Integration, and exposure to CDGC, MDM, or Data Quality.
• Proficiency in Python, C#, or Java.
• Able to overlap U.S. and Ireland hours.
• U.S. Citizen or Green Card holder only. No sponsorship.

Preferred Qualifications

• Snowflake, Azure Data Engineer, or dbt certification.
• Experience in 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.

Company Description

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.