: Lead Snowflake Date Architect || C2C || Hybrid

Overview

Hybrid
Depends on Experience
Contract - Independent
Contract - W2
Contract - 6 Month(s)
No Travel Required

Skills

Snowflake
AWS
SQL
Snowpipe/Ingestion pipelines
Informatica
DataStage
or similar tools
Databricks
Python
Oracle
Azure
ERwin
PowerDesigner

Job Details

Job Title: Lead Snowflake Date Architect

Location: Minneapolis, MN (Hybrid 2 days/week onsite)

Rate: $--/hr on CTC or 1099

Type: Contract-to-Hire (6 months with likely extensions)

Non locals are fine

Must work in hybrid work environment

Key Responsibilities:

Serve as technical lead for multiple Snowflake-based data initiatives

Architect and build scalable, high-performance Snowflake data pipelines and solutions

Convert conceptual and logical data models into robust physical implementations

Guide and mentor a team of Snowflake and ETL engineers

Collaborate closely with Product Owners, Domain Architects, QA, and business stakeholders

Create and maintain source-to-target mappings, and ensure data integrity across systems

Optimize pipeline performance and ensure solutions meet non-functional requirements

Support Agile delivery practices across teams and projects

Tech Stack:

Must-Have: Snowflake, AWS, SQL, Snowpipe/Ingestion pipelines

ETL: Informatica, DataStage, or similar tools

Bonus: Databricks, Python, Oracle, Azure, ERwin, PowerDesigner

Required Qualifications:

  • 10 20 years of IT experience with a strong focus on data engineering and architecture
  • 7+ years of experience building enterprise data solutions and warehouses
  • Expertise in Snowflake architecture, implementation, and pipeline optimization
  • Strong data modeling (3NF, dimensional), SQL, and DDL scripting skills
  • Experience with ingestion frameworks, data quality, and governance
  • Proven leadership experience with the ability to lead and mentor technical teams
  • Excellent communication and collaboration skills across technical and business groups
  • Preferred Qualifications:
  • Financial services experience (especially in data warehousing)
  • Experience with Agile/SAFe methodologies
  • Familiarity with data cataloging tools (e.g., Informatica EDC) and governance frameworks
  • Certifications: CDMP, CBIP, Snowflake, AWS, or equivalent

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.