Data Engineer - Python/SQL

About the Role :

We are hiring experienced Data Engineers for an exciting opportunity.

Mandatory Skills :

• Strong expertise in Advanced SQL, Python, and PySpark
• Hands-on experience with Snowflake, Apache Spark, AWS Glue, and Airflow
• AWS services : Lambda, Glue, S3, and related data engineering services
• Strong understanding of Snowflake architecture, internal/external tables, stages, and masking policies
• Experience working with Big Data platforms
• Hands-on experience with AI-assisted development tools such as Cursor, Claude, and GitHub Copilot for code generation, debugging, SQL optimization, code reviews, and validating AI-generated code

Key Responsibilities :

• Architect and implement scalable ETL/ELT pipelines using PySpark and AWS Glue to process large-scale datasets for downstream consumption.
• Optimize complex SQL queries and database schemas within Snowflake to improve performance and reduce operational costs for business users.
• Orchestrate and monitor automated data workflows using Airflow to ensure timely delivery and data integrity across all production environments.
• Collaborate with engineering teams to integrate disparate data sources, ensuring seamless data flow and consistency throughout the enterprise data warehouse.
• Maintain high standards of code quality and documentation to facilitate long-term system maintainability and knowledge sharing within the engineering team.