SDE 1 - Data Engineer

GIST Advisory Pvt. Ltd.; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

GIST Advisory Pvt. Ltd. seeks a Data Engineer with 1-2 years of experience to build and deploy data warehouse solutions on Snowflake. You will develop ETL/ELT pipelines in Python and collaborate across teams to support data strategy and governance in a fast-paced environment.

You should have strong Python coding skills, experience with Snowflake and SQL, and familiarity with data warehousing concepts (OLAP/OLTP). The role requires effective communication and agile delivery practices.

Qualifications

• 1-2 years of Data Engineer experience.
• Experience with data warehouse architectures, ETL/ELT, analytics tools, and data security.
• Expert in developing data pipelines using Python.

Responsibilities

• Modeling data, designing physical and logical schemas, and ELT/ETL using Snowflake and SQL.
• Deploy production data warehouse solutions on Snowflake.
• Support data strategy and governance design.

Skills

Snowflake

Python

ETL/ELT

SQL

Data warehousing

Problem solving

Agile / SCRUM

Communication

Tableau / Power BI

AWS

Education

BE/B Tech/M Tech/MCA in CS/IT

Tools

SnowSQL

SnowPipe

Snowflake

Tableau

Power BI

Git

Job description

Seeking a Data Engineer with 1-2 years of experience, skilled in Snowflake, Python, and data warehousing. Responsibilities include deploying data warehouse solutions, building ETL/ELT pipelines, and supporting data strategy in a fast-paced environment. Strong problem-solving skills, cloud exposure, and teamwork are essential.

Responsibilities:

Demonstrate expertise in data modelling, physical and logical schema designing, and ELT/ETL using Snowflake and SQL.

Deploy fully operational data warehouse solutions into production on Snowflake.

Support design of data strategy and governance.

Must be problem-solving and have the ability to break complex issues into manageable pieces that function successfully in a high-pressure, quick-turnaround environment.

Write a fully functioning piece of code in Python to support the various data-related workloads.

Good understanding of Data warehousing, ELT, ETL, OLTP, and OLAP

Build ETLs/ELTs to take data from various operational and transactional systems and create a unified dimensional or star schema data model for analytics, reporting and delivery.

Take an active part in all aspects of development including participation in reviewing the work done by peers.

Collaborate within and across multiple teams, as necessary.

Strong cross-functional team player and demonstrate ability to coordinate application changes in a diverse and fast-paced work environment.

Requirements

Required Skills and Abilities:

1-2 years of relevant experience in working as a Data Engineer

Experience working on data warehouse technical architectures, ETL/ELT, reporting/analytical tools, and data security

Expert knowledge of developing data pipelines using Python.

Experience working with different offerings in Snowflake (SnowSQL, SnowPipe, Bulk loading, Shares)

Experience working with structured and semi-structured data

Solid fundamental skills in data structures and algorithms

Exposure to cloud-based services (AWS preferred)

Having excellent communication skills while collaborating with cross-located Development teams

Well-versed with SCRUM / Agile delivery methodology

Knowledge of any version control system (e.g. SVN, git).

Exposure and experience with Tableau/Power BI

Required Education and Experience:

BE/B Tech/M Tech/MCA in Computer Science/Information Technology or equivalent from a reputed college with 1-2 years of experience as a Data Engineer

Prior experience working with Snowflake is mandatory

Prior coding experience in Python is mandatory

Prior experience working in Data warehousing and ETL development is mandatory

Motivated team player who goes over and above what is asked

Attitude to thrive in a fun, fast-paced start-up-like environment

You love writing and owning codes and enjoy working with people who will keep challenging you at every stage.

You have strong problem-solving, analytical, decision-making, and excellent communication and interpersonal skills.

You are self-driven and motivated with the desire to work in a fast-paced, results-driven agile environment with varied responsibilities.