Overview
Remote
Hybrid
$DOE
Full Time
Contract - Independent
Contract - W2
Contract - Permanent
Skills
AWS
ETL
snowflake
Data Warehouse
Snowpipe
SnowSQL
Job Details
Position Title: Snowflake Architect
Domain Experience: Financial Services
Location: Remote CST (occasional travel expenses paid)
Type: Contract-to-Hire (C2H) / Full-Time
Job Description
Key Responsibilities
- Design, develop, and optimize Snowflake data warehouse solutions for large-scale financial data systems.
- Collaborate with business and data engineering teams to define data architecture, ETL pipelines, and data modeling strategies.
- Implement best practices for performance tuning, cost optimization, and data governance in Snowflake.
- Integrate Snowflake with various data sources, including AWS, Azure, and on-prem systems.
- Build and manage data ingestion and transformation frameworks using tools like Informatica, DBT, or Apache Airflow.
- Ensure data security, compliance, and audit readiness in accordance with financial industry standards.
- Support data migration initiatives and modernize legacy systems into Snowflake.
- Work closely with stakeholders to translate analytical requirements into scalable data solutions.
Required Skills & Qualifications
- Proven experience as a Snowflake Architect with expertise in data modeling, performance tuning, and optimization.
- SnowPro Core or SnowPro Advanced Architect Certification (highly preferred).
- Deep understanding of Snowflake architecture, including virtual warehouses, micro-partitioning, clustering, caching, and query optimization.
- Hands-on experience with Snowflake features such as Snowpipe, Streams, Tasks, Time Travel, and Zero-Copy Cloning.
- Experience implementing data security, RBAC, and row-level access control within Snowflake.
- Strong proficiency in SQL and Python for data transformation and automation.
- Experience with ETL/ELT orchestration tools (e.g., DBT, Apache Airflow, Informatica).
- Integration experience with AWS/Azure cloud data sources and services.
- Solid understanding of data governance, lineage, and compliance frameworks in the financial domain.
- Familiarity with Data Sharing, Snowflake Marketplace, and Snowpark for advanced data solutions.
- Excellent communication and documentation skills for collaboration with business and technical stakeholders.
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.