Senior Snowflake Data Engineer

Job Title: Senior Snowflake Data Engineer.
Location: Remote (U.S. — must overlap U.S. and Ireland hours).
Employment Type: Contract (W2 through Zip Staff — No C2C or 1099).

Zip Staff 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.

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

Zip Staff 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.