Job Description
Skill: Snowflake with DBT
Experience: 6 to 12 years
Location: AIA Gurgaon
Job Summary
Snowflake Architect - Offshore - Manager
Responsibilities
Snowflake Architecture and Design Collaborate with stakeholders data engineers and business analysts to design and architect data solutions based on the Snowflake cloud data platform. Create detailed data models and schema designs to support various business requirements.
Harness Snowparks multi-language capabilities to create efficient and modular code.
Develop custom user defined functions (UDFs) to extend Snowflakes native capabilities and optimize query performance.
Technical Leadership Lead a team of developers and data engineers providing technical guidance mentoring and support throughout the development lifecycle. Drive best practices code reviews and ensure the team follows industry standards and conventions.
Data Integration Develop and maintain data integration workflows to ingest process and transform data from various sources into Snowflake. Implement ETL ELT processes to ensure data accuracy and consistency.
Performance Optimization Optimize Snowflake database performance by tuning queries optimizing data structures and improving data loading and extraction processes. Monitor system performance and troubleshoot issues when they arise.
Security and Governance Implement and enforce data security measures access controls and data governance policies within Snowflake. Ensure compliance with data privacy regulations and industry standards.
Collaboration Collaborate with cross-functional teams including data analysts data scientists and business stakeholders to understand data requirements and deliver comprehensive solutions.
Cloud Infrastructure Work closely with cloud infrastructure teams to ensure the Snowflake environment is properly configured monitored and scaled to meet performance and availability requirements.
Continuous Improvement Stay up to date with the latest advancements in Snowflake
