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.