Senior Data Engineer (Snowflake/DBT/Python - Programming Expertise)

Prudent Globaltech Solutions; Hyderabad; On-site; INR 1,600,000 - 2,800,000; Full time

Benefits offered by this job

1-Way Cab

Job summary

Prudent Globaltech Solutions is seeking a Senior Data Engineer with deep hands-on experience in Snowflake, dbt, SQL, and data modelling to build scalable, production-grade data platforms. Proficiency with AI-assisted development tools to improve engineering productivity and data quality is essential.

The role requires 8+ years in Data Engineering with 4+ years specifically in Snowflake and dbt, and will involve creating robust data pipelines across APIs and source systems with CI/CD practices.

Qualifications

• 8+ years in Data Engineering with 4+ years in Snowflake and dbt.
• Strong SQL and Python scripting abilities.
• Experience building production-grade ETL/ELT pipelines on Snowflake.
• CI/CD with dbt models and transformations.

Responsibilities

• Design and maintain scalable ETL/ELT pipelines on Snowflake.
• Build integrations across APIs, source systems, and downstream platforms.
• Develop tested and documented dbt models and transformations with CI/CD.
• Design dimensional and Medallion architectures (Bronze/Silver/Gold).
• Optimize Snowflake performance, security, and costs.
• Mentor junior engineers and establish best practices.
• Review AI-generated outputs for production-quality code.

Skills

ETL/ELT pipelines

SQL

Python scripting

Data modelling

CI/CD workflows

AI-assisted development

AI coding assistance usage

Tools

Snowflake

dbt

Airflow/ADF

Job description

Role: Senior Data Engineer -(Snowflake / DBT/Python - Programming)

Shift: 3PM - 12AM IST (US Working Hours)

Experience: 8+ Years (4 Years Relevant in Snowflake and DBT)

Location: Hyderabad

Cab Facility: 1 -Way Cab

Salary: Industry Standards

Notice Period: 30 Days (Immediate Joiner Preferred)

Role Overview

We are looking for a Senior Data Engineer with strong hands-on expertise in Snowflake,dbt, SQL, and data modelling to build scalable, production-grade data platforms. The role also requires practical use of AI-assisted development tools to improve engineering productivity and data quality.

AI-First Mindset

Candidates should regularly use AI coding assistants in their daily workflow and demonstrate the ability to prompt effectively, validate AI-generated code, troubleshoot pipelines, and apply AI to engineering automation.

Ideal Profile

8+ years in Data Engineering with 4+ years of Snowflake and modern ELT/dbt experience, with a proven track record of delivering production-grade data pipelines at scale.

Key Responsibilities

• Design and maintain scalable ETL/ELT pipelines on Snowflake.
• Build integrations across APIs, source systems, and downstream platforms.
• Develop tested and documented dbt models and transformations with CI/CD.
• Design dimensional and Bronze/Silver/Gold data architectures.
• Optimize Snowflake performance, security, and cloud costs.
• Implement data quality, governance, testing, and documentation standards.
• Use AI tools such as ChatGPT, Claude, Cursor, or Copilot for coding, debugging, documentation, and data-quality analysis.
• Review AI-generated outputs and ensure production-quality code.
• Mentor junior engineers and contribute to engineering best practices.

Must-Have Skills

• Snowflake Data modelling, performance tuning, security & cost optimization.
• Integration pipeline development.
• dbt Models, tests, macros, dependencies & documentation.
• Strong SQL and Python/scripting experience.
• Data modelling Dimensional / Medallion architecture.
• Git-based CI/CD workflows.
• Exposure to Airflow, ADF, or similar orchestration tools.

Good to Have

• SODA, Collibra or other data-quality tools.
• AWS / Azure / GCP exposure.
• Enterprise or regulated data environments.
• Team mentoring/technical leadership.