Job Title : Senior Snowflake Data Engineer

Experience : 7+ Years

Location : Remote

Role Summary :

We are seeking a highly skilled Senior Snowflake Data Engineer with strong expertise in Snowflake, Python, SQL, Data Migration, AWS, and Amazon QuickSight. The ideal candidate will have hands-on experience designing and optimizing Snowflake data warehouses, building scalable ETL/ELT pipelines, migrating enterprise data to Snowflake, and developing high-performance reporting solutions. The role requires excellent problem-solving skills, deep knowledge of Snowflake features, and the ability to optimize queries and dashboards for large-scale analytics.

Key Responsibilities :

- Design, develop, and maintain scalable data pipelines using Python and SQL.

- Lead data migration projects from legacy systems to Snowflake while ensuring data quality and integrity.

- Design and optimize Snowflake data warehouse solutions for performance, scalability, and cost efficiency.

- Implement and manage Snowflake features including Streams, Snowpipe, Time Travel, Tasks, Cloning, and Data Sharing.

- Develop complex SQL queries, stored procedures, and data transformations.

- Optimize Snowflake queries, virtual warehouses, clustering, and storage utilization.

- Build and maintain interactive dashboards and analytical reports using Amazon QuickSight.

- Configure dataset refresh schedules, SPICE optimization, and dashboard performance tuning in QuickSight.

- Collaborate with business stakeholders to understand reporting requirements and translate them into scalable data solutions.

- Troubleshoot performance bottlenecks, data pipeline failures, and reporting issues.

- Follow data governance, security, and cloud best practices across the data platform.

Required Skills & Experience :

- 7+ years of experience in Data Engineering or Data Warehousing.

- Strong hands-on experience with Snowflake.

- Advanced SQL programming, query optimization, and performance tuning.

- Strong Python programming for ETL, automation, and data processing.

- Hands-on experience with Snowflake features, including :

1. Streams

2. Snowpipe

3. Time Travel

4. Tasks

5. Zero-Copy Cloning

6. Data Sharing

- Experience with enterprise data migration projects to Snowflake.

- Strong understanding of dimensional modeling, Star Schema, and Snowflake Schema.

- Experience with AWS cloud services such as S3, IAM, and related data services.

- Hands-on experience with Amazon QuickSight, including :

1. Dashboard development

2. SPICE datasets

3. Scheduled dataset refreshes

4. Dashboard optimization

5. Security and user access management

- Strong analytical, debugging, and troubleshooting skills.

Good to Have :

- AWS Glue

- Apache Airflow

- dbt

- Kafka

- CI/CD pipelines

- Data Lake/Lakehouse concepts

- Power BI or Tableau

Key Competencies :

- Snowflake Data Engineering

- Data Migration

- Python

- SQL

- Query Optimization

- Snowflake Performance Tuning

- AWS Cloud

- Amazon QuickSight

- ETL/ELT Development

- Data Warehousing

- Cloud Analytics