Snowflake Architect

Role: Snowflake Architect

Location: New York, NY (4 days Onsite per week/Hybrid)

Duration: Long-term Contract

Employment Type: W2

Domain: Preferred exp. with Banking, financial services, capital markets, or fintech

Job Description:

We are looking for an experienced Snowflake Architect to design, develop, and implement scalable, secure, and high-performance cloud data warehouse solutions. The ideal candidate should have strong expertise in Snowflake architecture, cloud data platforms, data modeling, ETL/ELT pipelines, and enterprise data integration.

The candidate will work closely with business stakeholders, data engineers, solution architects, and technology teams to build modern data solutions supporting enterprise banking and financial services applications.

Key Responsibilities

• Design and implement enterprise-scale data warehouse and data lakehouse solutions using Snowflake.
• Define Snowflake architecture, data models, database structures, schemas, and data integration strategies.
• Develop scalable ETL/ELT pipelines using Snowflake, SQL, Python, and relevant data integration tools.
• Optimize Snowflake query performance, warehouse sizing, resource utilization, and overall cost.
• Implement data security, governance, access controls, RBAC, masking policies, and data encryption.
• Design data ingestion solutions for structured and semi-structured data.
• Integrate Snowflake with cloud platforms such as AWS, Azure, or Google Cloud Platform.
• Establish data quality, metadata management, lineage, and monitoring frameworks.
• Work with large-scale financial datasets and ensure data accuracy, consistency, and reliability.
• Provide technical leadership, architecture guidance, and best practices to development teams.
• Collaborate with enterprise architecture, infrastructure, security, and business teams.