Snowflake / AWS Engineer

Job highlights

• • Experience supporting production data warehouse or data platform environments

• Preferred / Good to Have . - Experience with cloud platforms such as AWS

• We are seeking a skilled Snowflake Data Engineer to join our team. The ideal candidate will be responsible for designing, developing, deploying, and supporting enterprise data solutions on the Snowflake platform.
• Key Responsibilities
• Snowflake Engineering & Development
• Design, develop, and maintain robust data solutions using Snowflake.
• Develop and support database objects including tables, views, streams, tasks, stored procedures, and
• dynamic SQL frameworks.
• Build scalable and performant ETL/ELT pipelines for data integration and analytics workloads.
• Optimize Snowflake query performance, storage utilization, and compute efficiency.
• Implement metadata-driven and configuration-based data processing frameworks.
• • Database Administration & Scripting
• Develop, support, and maintain database administration scripts for operational and support activities.
• Create automation scripts for database monitoring, housekeeping, deployments, validations, and
• health checks.
• Assist with Snowflake platform administration activities, including role management, access controls,
• warehouse management, and object security.
• Support operational automation across development, test, and production environments.
• Support Amazon Aurora PostgreSQL operational activities, including connectivity validation,
• performance troubleshooting, access coordination, and environment support.
• • Database Deployment & Release Management
• Utilize Liquibase for source-controlled database deployments and schema migrations.
• Develop and maintain deployment scripts and release automation processes.
• Ensure database changes are properly version-controlled, tested, and promoted through
• environments.
• Partner with development and operations teams to establish deployment standards and best
• practices.
• • Data Engineering & Operational Support
• Develop efficient data ingestion, transformation, and validation processes.
• Design, develop, and support AWS Glue jobs and workflows for data ingestion, transformation,
• cataloging, and orchestration across cloud and enterprise data platforms.
• Work with Amazon S3 for data landing, staging, archival, file organization, access patterns, and
• integration with Snowflake and AWS Glue pipelines.
• Support AWS Database Migration Service (AWS DMS) tasks for data replication, migration, validation,
• monitoring, and issue resolution across source and target platforms.
• Troubleshoot and resolve issues related to data pipelines, database performance, and application
• integrations.
• Perform root cause analysis and implement corrective actions for recurring issues.
• Monitor data loads, data quality processes, and platform performance to ensure reliability and
• availability.
• Support production incident management and operational escalations.
• • Software Engineering & Documentation
• Write clean, maintainable, and supportable code following engineering best practices.
• Design solutions with long-term maintenance, observability, and troubleshooting requirements in
• mind.
• Implement appropriate logging, exception handling, auditing, and monitoring capabilities.
• Produce comprehensive technical documentation for all solutions, processes, and deployments.
• Create and maintain operational runbooks, troubleshooting guides, architectural documentation, and
• knowledge transfer materials.
• Ensure all code deliveries are supplemented with proper and abundant documentation to support
• future maintenance and operational activities.
• • System Integration & DevOps
• Support CI/CD processes for database and data engineering solutions.
• Utilize GitHub for source code management, version control, and collaboration.
• Collaborate with application development, infrastructure, and data teams to deliver integrated
• enterprise solutions.
• Integrate Snowflake solutions with AWS services, including AWS Glue, Amazon Aurora PostgreSQL,
• Amazon S3, and AWS DMS, to support scalable enterprise data processing and interoperability.
• Participate in code reviews, deployment reviews, and technical design discussions.
• Required Skills & Experience
• • SnowFlake Engineer 4 years experience and at least 2 years of relevant data engineering
• experience, including hands-on work with cloud data platforms and production data
• environmen…