Snowflake Solutions Architect

INFOTRON; India; On-site; INR 5,000,000 - 7,500,000; Full time

Job summary

INFOTRON in India seeks a Senior Snowflake Solutions Architect to design enterprise Snowflake data warehouses and lead data integration initiatives for a financial services client. You will be hands-on, guiding architecture, performance optimization, and cost control while collaborating with business and technology teams.

The role requires deep Snowflake expertise, strong SQL and data modeling skills, and the ability to communicate with stakeholders across functions.

Qualifications

• Strong hands-on Snowflake architecture and implementation experience.
• Advanced SQL, data warehousing, data modeling, and ETL/ELT.
• Knowledge of Snowflake warehouses, stages, streams, tasks, clustering, RBAC, and performance tuning.
• Experience building and supporting production data pipelines.
• Strong data integration and architecture experience.
• Excellent communication and stakeholder-management skills.
• Ability to work as both a hands-on engineer and technical architect.

Responsibilities

• Design and implement scalable Snowflake data warehouse architectures.
• Serve as the Snowflake SME/Architect and provide technical guidance.
• Design and optimize ETL/ELT pipelines and data models.
• Work with multiple upstream/downstream systems and applications.
• Perform Snowflake performance, workload, security, and cost optimization.
• Collaborate with data engineering, application, infrastructure, security, and business teams.
• Troubleshoot production data, pipeline, and integration issues.
• Document architecture and technical standards.

Skills

Snowflake architecture

SQL

Data warehousing

ETL/ELT

RBAC and performance tuning

Data integration

Stakeholder management

Hands-on + architect

Tools

dbt

Airflow

Fivetran

Informatica

Matillion

Job description

We are looking for a Senior Snowflake Solutions Architect to support a strategic data warehousing and integration initiative for a leading financial-services / hedge fund client.

The ideal candidate will be a hands-on Snowflake expert who can design enterprise data warehouse solutions, integrate multiple data sources, optimize performance and cost, and work directly with business and technology stakeholders.

Key Responsibilities:

• Design and implement scalable Snowflake data warehouse architectures.
• Serve as the Snowflake SME/Architect and provide technical guidance.
• Design and optimize ETL/ELT pipelines and data models.
• Work with multiple upstream/downstream systems and applications.
• Perform Snowflake performance, workload, security, and cost optimization.
• Collaborate with data engineering, application, infrastructure, security, and business teams.
• Troubleshoot production data, pipeline, and integration issues.
• Document architecture and technical standards.

Required Skills:

• Strong hands-on Snowflake architecture and implementation experience.
• Advanced SQL, data warehousing, data modeling, and ETL/ELT.
• Strong knowledge of Snowflake warehouses, stages, streams, tasks, clustering, RBAC, and performance tuning.
• Experience building and supporting production data pipelines.
• Strong data integration and architecture experience.
• Excellent communication and stakeholder-management skills.
• Ability to work as both a hands-on engineer and technical architect.

Preferred Skills:

• Experience in hedge funds, asset management, investment management, capital markets, or financial services.
• Experience with dbt, Airflow, Fivetran, Informatica, Matillion, or similar tools.
• Python and AWS/Azure experience.
• Experience with financial data such as trades, positions, securities, pricing, P&L, risk, or market data.