Data Engineer - Python & Snowflake

We are seeking an experienced Senior Data Engineer with strong, practical expertise in Python, Snowflake, SQL, and modern data engineering technologies. In this role, you will design, develop, optimize, and maintain scalable data pipelines and ETL/ELT solutions that power enterprise data platforms, analytics, and reporting needs. Experience in the banking or BFSI domain is preferred.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL/ELT workflows.
• Build Python-based solutions for data ingestion, transformation, validation, and processing.
• Create, maintain, and optimize data warehouse solutions using Snowflake.
• Write complex, efficient, performance-optimized SQL queries.
• Connect and integrate data from databases, REST APIs, files, and other enterprise data sources.
• Apply data transformations and business rules aligned to functional requirements.
• Design and manage data models for analytics, reporting, and business intelligence.
• Diagnose and resolve pipeline failures, data-quality concerns, and performance bottlenecks.
• Optimize Snowflake queries, data structures, and workloads to ensure scalability and performance.
• Build data-quality checks, reconciliation processes, logging, monitoring, and error-handling mechanisms.
• Work closely with Data Architects, Business Analysts, Data Scientists, and application teams.
• Support code reviews, testing, deployments, and production support activities.
• Adhere to engineering standards and best practices for secure and reliable data management.

Mandatory Skills

• 8+ years of experience in Data Engineering
• Strong hands-on experience in Python
• Strong hands-on experience in Snowflake
• Advanced SQL, complex queries, joins, CTEs, window functions, stored procedures, query optimization
• ETL/ELT development, data pipeline development, data ingestion, data transformation
• Data warehousing, dimensional modelling, data marts
• Large-volume data processing, data integration
• REST APIs, JSON, CSV, Parquet
• Data validation, data quality, data reconciliation
• Debugging, performance tuning, production troubleshooting
• Git, version control, CI/CD practices
• Banking / BFSI domain experience preferred