Data Engineer–Transformation & Optimization

Role: Data Engineer–Transformation & Optimization
Location: India/Remote
Long-term Contract Opportunity
Shift Hours: Willing to work until 2 to 2:30am IST
Job Description:
Role Overview
We are looking for an experienced Data Engineer – Transformation & Optimization with strong hands-on expertise in data engineering, Snowflake, and data transformation. The ideal candidate will be responsible for designing, developing, and optimizing scalable data pipelines and data solutions to support business intelligence, analytics, and data-driven decision-making.
The candidate should have a strong understanding of modern data engineering practices, data integration, performance optimization, and cloud-based data platforms, with a particular focus on Snowflake.
Key Responsibilities
Design, develop, and maintain scalable and reliable data pipelines and ETL/ELT processes.
Build and optimize data transformation workflows using Snowflake and SQL.
Develop and maintain data models to support reporting, analytics, and business requirements.
Optimize Snowflake queries, warehouse utilization, and data processing performance.
Integrate data from multiple sources and ensure data consistency, accuracy, and quality.
Identify and resolve data pipeline issues, bottlenecks, and performance challenges.
Implement best practices for data architecture, data transformation, and pipeline optimization.
Collaborate with business stakeholders, data analysts, architects, and other engineering teams to understand requirements and deliver effective data solutions.
Monitor data workflows and troubleshoot failures to ensure reliability and timely data delivery.
Maintain technical documentation for data pipelines, transformation logic, and data models.
Required Skills and Qualifications
Strong hands-on experience in Data Engineering and Snowflake.
Excellent SQL skills, including complex queries, joins, CTEs, window functions, and query optimization.
Experience developing ETL/ELT pipelines and data transformation processes.
Strong understanding of data warehousing concepts, dimensional modeling, and database design.
Experience with Snowflake performance tuning, query profiling, and warehouse optimization.
Proficiency in data integration, data quality management, and troubleshooting.
Experience working with large datasets and building scalable data processing solutions.
Strong analytical, problem-solving, and communication skills.
Preferred Skills
Experience with cloud platforms such as AWS, Azure, or Google Cloud.
Familiarity with data orchestration tools such as Apache Airflow, Azure Data Factory, or similar platforms.
Experience with Python or other scripting languages for data processing and automation.
Knowledge of modern data stack tools and cloud-based data architectures.
Experience implementing data governance, security, and monitoring practices.
Ideal Candidate Profile
We are prioritizing candidates with strong data engineering fundamentals and proven hands-on Snowflake expertise, especially in data transformation, complex SQL development, pipeline optimization, and performance tuning.
Primary Skills: Data Engineering, Snowflake, SQL, ETL/ELT, Data Transformation, Performance Optimization.

Work arrangement
Yes