Senior Data Engineer (Snowflake/DBT/Python)

Prudent Globaltech Solutions; Hyderabad; On-site; INR 3,500,000 - 6,000,000; Full time

Job summary

Prudent Globaltech Solutions is seeking a Senior Data Engineer to design and maintain scalable ETL/ELT pipelines on Snowflake, with DBT and Python proficiency. You will build integrations across APIs and source systems while optimizing performance and costs.

The role emphasizes AI-assisted development tools, CI/CD for dbt pipelines, and mentoring junior engineers to raise engineering standards. Hyderabad-based, US hours aligned.

Qualifications

• 8+ years in data engineering with Snowflake and ELT/dbt experience.
• Strong SQL and Python scripting capabilities.
• Experience with CI/CD and orchestration tools (Airflow).

Responsibilities

• Design and maintain scalable ETL/ELT pipelines on Snowflake.
• Build integrations across APIs, source systems, and downstream platforms.
• Develop 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.
• Review AI-generated outputs and ensure production-quality code.
• Mentor junior engineers and contribute to engineering best practices.

Skills

Snowflake

dbt

SQL

Python

Dimensional

Medallion architecture

CI/CD

Airflow

Job description

Role: Senior Data Engineer - Snowflake / DBT/Python

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.