Senior Data Engineer
Susmita TripathyRemoteSENIORPosted 11d ago
AWSSnowflakeDBTPySparkDevOps-CI/CDData ModelingSQL
About the Role
We are looking for an experienced Senior Data Engineer with 10+ years of data engineering experience to join the EDH team. This role will serve as a technical resource responsible for designing, developing, supporting, and enhancing modern data pipelines built using AWS, Snowflake, and DBT.
Key Responsibilities
• Design, develop, and support enterprise data pipelines using AWS, Snowflake, and DBT
• Develop and enhance metadata-driven data ingestion and transformation frameworks
• Work with AWS services to build scalable data ingestion solutions
• Implement enterprise-scale solutions using Snowflake, including database design, data loading, data transformation, security, performance optimization, and operational support
• Build dimensional models, star schema, snowflake schema, fact and dimension tables, and data structures optimized for analytics and reporting
• Develop DBT models, macros, tests, and deployment configurations
• Troubleshoot and debug data pipeline issues across AWS, Snowflake, dbt, and PySpark, perform root cause analysis, and implement solutions
• Support EDH production deployments, monitoring, and issue resolution
• Collaborate with offshore engineering teams and provide technical guidance and code reviews
• Participate in architecture discussions and recommend improvements to platform design
• Work with DevOps teams on CI/CD processes, Git-based development, deployment automation, and release management
• Implement data quality checks, validation frameworks, logging, and operational monitoring
Requirements
• 10+ years of data engineering experience
• Strong hands-on data engineering experience with AWS data services
• Strong hands-on experience with Snowflake architecture, development, and designing data warehouse solutions using Snowflake
• Strong hands-on experience with DBT development
• Experience developing PySpark applications for data ingestion and cleansing
• Experience with deployment automation, release management, and environment promotion processes
• Experience designing dimensional data models (Facts, Dimensions), transformation, and optimization in cloud-based data platforms
• Strong SQL skills including complex queries, performance tuning, and optimization