Snowflake EDW Architect

NTT DATA•Phoenix, AZ

About The Position

Create Architecture diagrams, solution Spec, conceptual design flow map, knowledge of integration between systems (SFDC, SAP, EDW). Create EDW data pipeline strategies. Work with developers to drive optimizations. Collaborate with security teams for architecture reviews and approvals. Analyse and drive performance optimizations and tuning activities. Support dev team with UAT. Support data readiness for UAT. Over 10 years of experience in Snowflake data engineering, including data modelling, ingestion, and complex SQL development. Due to ITAR restrictions, resource should be a US Citizen and physically in US Deep expertise in Snowflake features, architecture, and performance optimization. Skilled in designing and implementing scalable Snowflake-based data solutions. Proficient in SQL development and ETL tools such as Informatica PowerCenter and IICS. Strong understanding of data warehousing principles, ETL pipelines, and data modelling best practices. Capable of designing secure Snowflake environments and implementing robust data access models. Experienced in migrating legacy systems and databases to Snowflake. Skilled in query tuning and performance optimization for large-scale data processing. Adept at configuring, maintaining, and monitoring Snowflake environments for high availability and efficiency. Provides technical leadership and strategic guidance for Snowflake adoption and modernization initiatives. Collaborates effectively with clients, stakeholders, and cross-functional teams to gather requirements and deliver end-to-end data solutions. Participates in architecture and design discussions, ensuring alignment with security and compliance standards. Excellent communication, facilitation, and stakeholder management skills in onsite-offshore delivery models. Continuously stays updated with latest Snowflake enhancements and industry trends to drive innovation.

Requirements

10+ years of experience in Snowflake data engineering, including data modelling, ingestion, and complex SQL development
US Citizen and physically in US (due to ITAR restrictions)
Deep expertise in Snowflake features, architecture, and performance optimization
Skilled in designing and implementing scalable Snowflake-based data solutions
Proficient in SQL development and ETL tools such as Informatica PowerCenter and IICS
Strong understanding of data warehousing principles, ETL pipelines, and data modelling best practices
Capable of designing secure Snowflake environments and implementing robust data access models
Experienced in migrating legacy systems and databases to Snowflake
Skilled in query tuning and performance optimization for large-scale data processing
Adept at configuring, maintaining, and monitoring Snowflake environments for high availability and efficiency
Excellent communication, facilitation, and stakeholder management skills in onsite-offshore delivery models

Nice To Haves

Knowledge of integration between systems (SFDC, SAP, EDW)
Continuously stays updated with latest Snowflake enhancements and industry trends to drive innovation

Responsibilities

Create Architecture diagrams, solution Spec, conceptual design flow map
Create EDW data pipeline strategies
Work with developers to drive optimizations
Collaborate with security teams for architecture reviews and approvals
Analyse and drive performance optimizations and tuning activities
Support dev team with UAT
Support data readiness for UAT
Configure, maintain, and monitor Snowflake environments for high availability and efficiency
Provide technical leadership and strategic guidance for Snowflake adoption and modernization initiatives
Collaborate effectively with clients, stakeholders, and cross-functional teams to gather requirements and deliver end-to-end data solutions
Participate in architecture and design discussions, ensuring alignment with security and compliance standards