Data Engineer
Shubham MadneUnited StatesSENIORPosted 12d ago
SnowflakeAWSdbtSQLAirflowSnapLogicKafkaREST APIsGitCI/CDSODA
About the Role
We are seeking a Data Engineer to build and support production-grade cloud data pipelines and data products. This hands-on role focuses on Snowflake and AWS engineering, responsible for reliable delivery from source onboarding through production support.
Key Responsibilities
• Design and build scalable ingestion and transformation pipelines across Snowflake Bronze, Silver, and Gold layers
• Develop modular dbt models, advanced SQL transformations, and Airflow workflows
• Build AWS-based integrations using files, APIs, events, and cloud storage patterns
• Perform source profiling, source-to-target mapping, cleansing, standardization, reconciliation, and data validation
• Implement automated unit, integration, regression, and data quality tests using frameworks such as SODA
• Support CI/CD, production deployments, monitoring, troubleshooting, performance tuning, documentation, and hypercare
• Collaborate closely with architects, product teams, data stewards, and distributed engineering teams
Requirements
• Strong hands-on Snowflake skills, including advanced SQL, data modeling, performance tuning, and secure data access
• Strong hands-on AWS data engineering skills
• 8+ years in data engineering, ETL/ELT, or cloud data-platform development
• Production experience with dbt and Airflow
• Experience with SnapLogic or similar integration tools, Kafka, REST APIs, Git, and CI/CD
• Experience implementing data quality frameworks such as SODA, automated testing, reconciliation, and observability
• Ability to troubleshoot production pipelines and work effectively across onsite and offshore teams