Senior Snowflake Data Engineer / Architect (with Certification)

1 view
Skip to first unread message

Resumes onc2c

unread,
Aug 25, 2025, 10:16:39 AMAug 25
to shr...@erp-initiatives.com

Job Title:

Senior Snowflake Data Engineer / Architect (with Certification)

Duration:

Long-term Contract (renewable every 6 months)

Location:

Remote – Candidate must be able to work in EST Time Zone
(Local driver’s license copy not applicable since remote)

Client:

[Confidential – To be disclosed during submission]

Due Date:

[Specify submission deadline here]

Billing Rate:

Quote your best lowest C2C/W2/1099

State or City Client Experience:

Mandatory – Prior state or city client project experience required

Job Summary:

The client is seeking a highly experienced Senior Snowflake Data Engineer / Architect to lead enterprise-scale Snowflake implementations, migrations, and optimizations. The role involves architecting data pipelines, ensuring scalable performance, and enabling advanced analytics in Snowflake environments. The ideal candidate will combine deep technical expertise in Snowflake with strong client-facing and communication skills, capable of driving requirements, solution design, implementation, and delivery.

Core Responsibilities:

  • Architect, design, and implement enterprise Snowflake solutions.

  • Optimize performance using virtual warehouses, micro-partitioning, query profiling, and resource scaling.

  • Define and enforce RBAC policies, secure data handling, time travel, and zero-copy cloning strategies.

  • Build modular, testable data models with DBT (Data Build Tool).

  • Orchestrate workflows with Apache Airflow (or equivalent).

  • Develop and maintain ETL/ELT pipelines using Fivetran, Matillion, Informatica, or similar.

  • Integrate with AWS cloud-native services (S3, Glue, Lambda, etc.).

  • Write complex SQL queries (window functions, CTEs, dynamic SQL).

  • Automate and script using Python or Scala for data transformations.

  • Lead end-to-end implementation: requirement gathering → architecture design → UAT → go-live support.

Required Skills & Experience:

  • 15+ years overall in data engineering / BI platforms.

  • 8+ years direct experience with Snowflake.

  • Deep knowledge of Snowflake architecture and performance tuning.

  • Hands-on experience with DBT, Airflow, Fivetran/Matillion/Informatica, AWS services, Python/Scala, and advanced SQL.

  • Proven experience with at least 3 enterprise-scale Snowflake implementations.

  • Excellent client-facing communication skills – ability to explain technical and business implications clearly.

Preferred Skills (Nice to Have):

  • Experience with Tableau, Power BI, or similar BI tools.

  • Kafka / Kinesis / CDC pipelines.

  • Prior consulting or client-facing engagement background.

  • Snowflake Certification (SnowPro® Advanced Architect or Data Engineer) – sponsorship available if otherwise a strong fit.

Education:

  • Bachelor’s or Master’s Degree in Computer Science, Information Technology, Data Engineering, or related technical discipline required.

📌 Consultant Details (to be submitted with resume):

  • Legal First & Last Name

  • Phone Number & Email Address

  • Current Location (with Zip Code)

  • Distance to client location (if applicable)

  • Willing to Relocate?

  • Start Availability / Upcoming Vacations

  • Work Authorization

  • LinkedIn Profile Link

  • Reason for Job Change

  • Education details (Degree, Specialization, University, Graduation Year, Location)

  • Date of Birth (MM/DD)

  • Last 4 digits of SSN

  • Active Interviews / Close to Offer Status

  • Interview Availability

References (Mandatory):

  • Reference 1: Name | Phone | Email | Designation | Company

  • Reference 2: Name | Phone | Email | Designation | Company

  • Reference 3: Name | Phone | Email | Designation | Company

Reply all
Reply to author
Forward
0 new messages