Snowflake Admin

Ensetu Solutions; Hyderabad, Pune District, Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Ensetu Solutions is seeking a Snowflake Admin/Architect with 5–10 years of experience to design and manage Snowflake-based data architecture for retail datasets. You will lead migration of legacy data, implement scalable database models, and optimize data extraction and integration processes.

Proficiency with SnowSQL, Snowpipe, and Snowflake architecture is required, along with hands-on OLAP/OLTP and dimensional modelling (Star schema, Snowflake schema, Data Vault).

Qualifications

• Experience as a Data Architect with SNOWFLAKE EXP is MUST.
• Good hands-on experience in Snowflake utilities SnowSQL Snowpipe.

Responsibilities

• Design and implement effective database solutions and models to store and retrieve retail data.
• Assess database implementation procedures to ensure they comply with internal and external regulations.
• Oversee the migration of data from legacy systems to new solutions.
• Recommend solutions to improve new and existing database systems.
• Realtime experience working in OLAP OLTP database models, Star schema, Snowflake schema and Data Vault modelling.
• Design and develop data extraction and integration code modules; stratify ingestion logic and testing patterns.
• Build data warehouse and data marts on Snowflake; perform data profiling and quality analysis.
• Use version control to maintain versions of data models.

Skills

Snowflake Admin

Snowflake Architect

SnowSQL

Snowpipe

Data architecture

Star schema

Snowflake schema

Data Vault

Job description

• Snowflake Admin (FTE/Contract)
• Experience: 5 to 10 years
• Location: PAN India

Any Project specific Prerequisite skills: Snowflake Admin/Architect, SnowSQL, Snowpipe

Job description

Experience as a Data Architect with SNOWFLAKE EXP is MUST

Good handson EXP in Snowflake utilities SnowSQL Snowpipe

Design and implement effective database solutions and models to store and retrieve retail data

Assess database implementation procedures to ensure they comply with internal and external regulations

Oversee the migration of data from legacy systems to new solutions

Recommend solutions to improve new and existing database systems

Realtime experience working in OLAP OLTP database models Dimensional models Comprehensive understanding of Star schema Snowflake schema and Data Vault Modelling

Design and develop data extraction and integration code modules Partner with the data engineers testing practitioners to strategize ingestion logic consumption patterns testing

Build data warehouse data marts on Snowflake while performing data profiling and quality analysis Use version control to maintain versions of data models

Enthuse to coach team members collaborate with various stakeholders across the organization and take complete ownership of deliverables

Works closely with all business units and engineering teams to develop data strategy for long term data platform architecture

Providing technical expertise in data storage structures data mining and data cleansing

Good understanding of SNOWFLAKE Architecture and its application for different kinds of Business use case across Retail Domain

Skills

Mandatory Skills : Snowflake, Snowflake Administration