Snowflake

Alike Thoughts; Hyderabad; Hybrid; INR 1,200,000 - 1,600,000; Full time

Job summary

Alike Thoughts is seeking a data engineer to build and optimize data pipelines for analytics and data science projects using SQL and Python. You will translate business requirements into scalable Snowflake-based architectures, with a focus on CDC-enabled ETL/ELT processes and robust data governance.

The role involves designing dimensional models, crafting complex queries, and ensuring secure, compliant data flows across cross-functional teams.

Qualifications

• Strong SQL and/or Python required.
• Experience with ETL/ELT processes and CDC.
• Data modelling for large historical datasets.
• Snowflake data warehouse and Snowpipe familiarity.
• Data pipelines and distributed architecture.

Responsibilities

• Develop and optimize ETL/ELT processes and CDC.
• Design scalable data pipelines and architectures using Snowflake.
• Create and optimize complex SQL queries for data transformation and analysis.
• Apply data modelling principles for large historical snapshot tables.
• Ensure data security, governance, and compliance.

Skills

SQL

Python

ETL/ELT

CDC

Data Modelling

Snowflake

Snowpipe

Data Pipelines

Data Transformation

Data Security

Data Governance

Tools

Snowflake Data Warehouse

Job description

Key Responsibilities

• Strong hands-on experience with SQL and/or Python for data analysis and ad hoc query development.
• Develop and optimize ETL/ELT processes, translating business requirements into dimensional models, facts, and dimensions while considering Change Data Capture (CDC).
• Design and implement scalable data pipelines and architectures using Snowflake.
• Develop complex SQL queries and scripts for data transformation, aggregation, and analysis.
• Apply strong data modelling principles, particularly for data science projects involving large historical snapshot tables and multiple features.
• Optimize data flows and solutions to support cross-functional data requirements.
• Implement data security, governance, and compliance in line with industry standards.
• Work with Snowflake architecture, data warehousing, administration, and Snowpipe.
• Evaluate emerging technologies and contribute to scalable and distributed data architecture solutions.

Required Skills

SQL and/or Python

ETL/ELT and CDC

Data Modelling

Snowflake Data Warehouse

Snowpipe

Data Pipelines & Architecture

Data Transformation & Analysis

Data Security & Governance

Preferred: Experience with cloud data warehouse technologies, particularly Snowflake.