At
ADROSONIC, we are looking for a highly skilled Senior Data Engineer - Snowflake with 5+ years of hands-on experience in designing, building, and
optimizing modern cloud-native data platforms. The ideal candidate will bring
strong expertise in Snowflake architecture, cloud data services, and
advanced data modelling practices.

The ideal candidate will bring deep expertise in Snowflake
architecture, advanced ELT design, Snowpark-based development, performance
tuning, and data modelling best practices. This role requires strong ownership of Snowflake environments, enabling high-concurrency analytics workloads,
cost-efficient compute management, and seamless BI enablement.

You will
play a key role in building scalable Snowflake data warehouse architectures, enabling seamless integration with BI tools, and ensuring efficient, secure,
and optimized ELT pipelines across projects.

Requirements
Key
Responsibilities:
- Snowflake
Data Platform Development:

· Design and
implement scalable Snowflake architectures leveraging multi-cluster Virtual
Warehouses.

· Configure




and manage auto-scaling, auto-suspend/resume, and workload isolation
strategies.

· Implement
Snowpipe for continuous ingestion and leverage Streams & Tasks for
CDC-based incremental processing.

· Utilize
Time Travel and Fail-secure for audit, recovery, and governance requirements.

· Implement
Zero-Copy Cloning for environment management (Dev / UAT / Prod).

· Design
secure access models using RBAC, Dynamic Data Masking, Row Access Policies, and
Secure Views.

· Optimize
separation of storage and compute for cost and concurrency efficiency.
- Data Modeling & Warehousing:

· Design conceptual, logical, and
physical data models.

· Implement dimensional modeling
techniques (Star Schema, Snowflake Schema).

· Develop well-structured fact
and dimension tables optimized for analytical workloads.

· Ensure data models are
optimized for BI tools such as Power BI, Tableau, or similar platforms.

· Maint

📌 Senior Data Engineer (Pune)
🏢 Adrosonic It Consultancy Services
📍 Pune