Senior Data Engineer with Exp in Snowflake & Amazon QuickSight(5+ Years of Exp)

Key Responsibilities

• Design, develop, and optimize scalable ETL/ELT pipelines for enterprise data platforms
• Build and maintain robust data solutions using Snowflake, Python, and AWS services
• Develop advanced SQL queries using CTEs, window functions, query tuning, and performance optimization techniques
• Work with Snowflake warehouses, tasks, streams, and data pipelines for efficient data processing
• Create and maintain data transformation workflows using dbt (data build tool)
• Develop reporting datasets and support dashboarding solutions using Amazon QuickSight
• Perform data validation, data integrity checks, and root cause analysis to ensure data accuracy and reliability
• Integrate and manage data across platforms including DynamoDB, S3, AWS Glue, Lambda, and Rockset
• Collaborate with cross-functional teams including analytics, product, and clinical stakeholders to support reporting requirements
• Monitor pipeline performance and troubleshoot production data issues

Required Skills

• Strong experience in SQL including CTEs, window functions, query optimization, and performance tuning
• Hands-on experience with Snowflake: warehouses, streams, tasks, data loading, and optimization
• Experience in Python for data processing and pipeline development
• Experience with AWS services: AWS Glue, Lambda, S3
• Good knowledge of dbt (Data Build Tool)
• Experience in creating dashboards and reports using Amazon QuickSight
• Knowledge of Rockset analytical engine
• Experience with DynamoDB and NoSQL databases
• Basic to intermediate knowledge of JavaScript