Data Engineer - Snowflake

Job Description:

We are seeking a skilled Data Engineer with strong experience in Python, Snowflake, and AWS. The ideal candidate will be responsible for building and optimizing scalable data pipelines, integrating diverse data sources, and supporting analytics and business intelligence solutions in a cloud environment. A key focus will include designing and managing AWS Glue Jobs and enabling efficient, serverless ETL workflows.

Key Responsibilities:

• Design and implement robust data pipelines using AWS Glue, Lambda, and Python.
• Work extensively with Snowflake for data warehousing, modelling, and analytics support.
• Manage ETL/ELT jobs using AWS Glue and ensure end-to-end data reliability.
• Migrate data between CRM systems, especially from Snowflake to Salesforce, following defined business rules and ensuring data accuracy.
• Optimize SQL/SOQL queries, handle large volumes of data and maintain high levels of performance.
• Implement data normalization and data quality checks to ensure accurate, consistent, and deduplicated records.

Required Skills:

• Strong programming skills in Python .
• Hands-on experience with Snowflake Data Warehouse .
• Proficiency in AWS services : Glue, S3, Lambda, Redshift, CloudWatch.
• Experience with ETL/ELT pipelines and data integration using AWS Glue Jobs.
• Proficient in SQL and SOQL for data extraction and transformation.
• Understanding of data modelling, normalization, and performance optimization.

Nice to Have:

• Familiarity with Salesforce Data Loader, ETL mapping, and metadata-driven migration.
• Experience with CI/CD tools, DevOps, and version control (e.g., Git).
• Worked in Agile/Scrum environments.