Snowflake Data Engineer-DBT

Mississippi Consultants Pune; Mumbai, Pune District, Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Mississippi Consultants Pune is seeking a technical lead with 2-3 years of hands-on Snowflake development to design scalable ETL/ELT pipelines and BI solutions. You will craft Snowflake architectures, manage Snowpipe/SnowProc/SnowSql workflows, and apply DBT for transformations, while collaborating with customers to gather requirements.

The role requires strong communication, teamwork, and willingness to travel onsite or offshore for project delivery.

Qualifications

• Mastery of SQL, esp. in Snowflake cloud data warehouses and related architecture/design.
• Hands-on Snowpipe, SnowProc, SnowSql knowledge.
• 2-3 years of development experience in Snowflake.
• Design scalable ETL/ELT processes with complex transformations.
• Knowledge of DBT for transformations.
• Experience with traditional DW and BI solutions; understand customer requirements.
• Willing to travel onsite & offshore; strong communication & teamwork.

Responsibilities

• Develop and maintain Snowflake-based data pipelines and architectures.
• Lead technical design and code reviews; ensure scalability and reliability.
• Collaborate with clients to capture requirements and deliver BI solutions.

Skills

SQL mastery

Snowflake data warehouse

Snowpipe/SnowProc/SnowSql

ETL/ELT design

DBT tool

Software engineering best practices

Communication & teamwork

Travel readiness (onsite/offshore)

Tools

Snowflake

DBT

Job description

Role & responsibilities

• Mastery of SQL, especially within cloud-based data warehouses likeSnowflake. Experience onSnowflakewith data architecture, design, analytics and Development.2.Detailed knowledge and hands-on working experience in Snowpipe/ SnowProc/ SnowSql.


• Technical lead with strong development background having 2-3 years of rich hands-on development experience insnowflake.


• Experience designing highly scalable ETL/ELT processes with complex data transformations, data formats including error handling and monitoring.Experience DBT Tool for Transformation.Good working knowledge of ETL/ELT tool.


• Analysis, design, and development of traditional data warehouse and business intelligence solutions. Work with customers to understand and execute their requirements.


• Working knowledge of software engineering best practices. Should be willing to work in implementation & support projects. Flexible for Onsite & Offshore traveling.


• Collaborate with other team members to ensure the proper delivery of the requirement. Ability to think strategically about the broader market and influence company direction.


• Should have good communication skills, team player & good analytical skills.Snowflake certification is preferable.