Senior Data Engineer – Snowflake, Amazon QuickSight

This is a fully remote position, open to applicants in India.

📋 Description

• Design, create, and enhance scalable **ETL/ELT pipelines** for enterprise data platforms.

• Develop and sustain resilient data solutions utilizing **Snowflake, Python, and AWS services**.

• Craft advanced SQL queries incorporating **CTEs, window functions, query tuning, and performance optimization techniques**.

• Utilize **Snowflake warehouses, tasks, streams, and data pipelines** for effective data processing.

• Establish and oversee data transformation workflows using **dbt (data build tool)**.

• Generate reporting datasets and facilitate dashboarding solutions with **Amazon QuickSight**.

• Conduct **data validation, data integrity checks, and root cause analysis** to maintain data accuracy and reliability.

• Integrate and manage data across various platforms including **DynamoDB, S3, AWS Glue, Lambda, and Rockset**.

• Collaborate with cross-functional teams such as analytics, product, and clinical stakeholders to meet reporting needs.

• Monitor pipeline performance and resolve production data issues.

⛳️ Requirements

• Extensive experience in **SQL**, including:

• - CTEs

• - Window Functions

• - Query Optimization

• - Performance Tuning

• - Practical experience with **Snowflake**, including:

• - Warehouses

• - Streams

• - Tasks

• - Data Loading and Optimization

• - Proficiency in **Python** for data processing and pipeline development.

• - Familiarity with AWS services such as:

• - AWS Glue

• - Lambda

• - S3

• - Solid understanding of **dbt (Data Build Tool)**.

• - Experience in developing dashboards and reports using **Amazon QuickSight**.

• - Knowledge of the **Rockset** analytical engine.

• - Experience with **DynamoDB** and NoSQL databases.

• - Basic to intermediate knowledge of **JavaScript**.

🏝️ Benefits

• Competitive salary and comprehensive benefits package.

• Opportunities for professional development and career advancement.

• Collaborative and innovative work environment.

• Flexible work arrangements to promote work-life balance.