Role: Snowflake Data Architect (Wealth Management)
Location: NJ or Dallas (local candidates strongly preferred)
Visa: USC
Experience: 14-18 years overall, including 4-8 years in Snowflake architecture
About the Role
Client is seeking a hands-on Snowflake Data Architect to lead the design and implementation of modern data platforms for enterprise clients. This role suits someone who started as a Data Engineer and grew into a Snowflake Architect, with deep experience in data engineering, data warehousing and cloud-native architectures. The ideal candidate has strong expertise in Snowflake, DBT, AWS, Spark and Python, and stays actively involved in architecture, design and implementation.
Key Responsibilities
Snowflake Architecture
Design and implement scalable Snowflake data platforms
Develop Snowflake architecture standards and best practices
Design secure data-sharing and secure data exchange solutions
Implement Snowpark-based processing frameworks
Use Dynamic Tables, Streams & Tasks for modern ELT architectures
Optimize performance, scalability, governance and cost
Data Engineering & AWS
Architect modern ETL/ELT solutions
Design enterprise data warehousing solutions
Build scalable data ingestion and transformation frameworks
Partner with engineering teams on implementation and optimization
Drive data quality, metadata management and governance initiatives
Design solutions leveraging AWS cloud services
Required Skills:
Mandatory
DBT (strong requirement)
Spark / PySpark
Python
AWS (strong)
Snowflake
Snowflake architecture and platform design
Snowpark
Dynamic Tables
Streams & Tasks
Data Sharing
Secure Data Exchange
Data Engineering
Advanced SQL
Data modeling
ETL/ELT design
Data warehousing
Good to Have
Kafka
Terraform
GitHub Actions
Jenkins
Preferred Domain Experience
Wealth Management, Asset Management, Investment Management, Banking, Financial Services. Domain experience is preferred but not mandatory.
Certifications
SnowPro and AWS certifications are preferred
Candidates without certifications can still be considered if they show strong hands-on Snowflake architecture experience
Leadership Competencies
Strategic Thinking: aligns enterprise data architecture with business objectives
Executive Communication: comfortable presenting architecture recommendations to Directors, VPs and C-level stakeholders
Consulting Mindset: drives client outcomes while balancing technology, cost and business priorities
Coaching & Mentorship: track record of developing architects and engineering leaders
Ownership: drives architecture from concept through successful implementation
Never miss an opportunity! Create an alert based on the job you applied for.
