Snowflake Data Engineer

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.

• 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., * Snowflake, Azure Data Engineer, or dbt certification.
• Professional services, accounting, or a managed-services environment.

• Health Insurance.
• Dental Insurance.
• Vision Insurance.

• 401(k) + 401(k) matching.

• Paid time off.
• Referral Program.

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.