Lead Data Engineer (Snowflake) Job ID: 415322

Blumetra Solutions LLC; Hyderabad; Hybrid; INR 2,800,000 - 4,200,000; Full time

Job summary

Blumetra Solutions LLC is seeking a Lead Data Engineer to design and deploy scalable data pipelines using Snowflake and dbt. The role requires hands-on skills in dbt, Snowflake features, Git integration, DevOps, CI/CD, SQL, and Python.

You will drive data pipeline development, maintain dbt models and tests, and ensure data lineage and documentation across environments from development to production.

Qualifications

• Hands-on experience with Snowflake and dbt in production data pipelines.
• Proficient in SQL and Python for data transformation and scripting.
• Experience setting up and maintaining Git-based CI/CD for data projects.
• Strong knowledge of DevOps practices and data lineage concepts.

Responsibilities

• Design, build, and deploy scalable data pipelines using Snowflake and dbt.
• Develop and maintain dbt models, tests, snapshots, and macros.
• Maintain data lineage and comprehensive documentation within dbt projects.
• Utilize Snowflake features such as Dynamic Tables and Notebooks for development.
• Implement and manage Snowflake DevOps practices and CI/CD pipelines.
• Collaborate with analytics and engineering teams to deliver reliable data solutions.

Skills

Snowflake

Python

dbt

SQL

Git integration

CI/CD

DevOps

Data pipelines

Job description

Designation: Lead Data Engineer

Work Location: Hybrid, Hyderabad (Financial District)

Experience: 8+ Years

Mandatory skills: Snowflake, Python, DBT

Job Summary

We are looking for a skilled Data Engineer with strong experience in Snowflake and dbtto design, develop, and deploy scalable data pipelines and transformation workflows. The ideal candidate should have hands-on experience with dbt development, Snowflake features, Git integration, DevOps, CI/CD, SQL, and Python.

Key Responsibilities

• Design, build, and deploy scalabledata pipelines using Snowflake and dbt.
• Develop and maintaindbt models, tests, snapshots, and macros.
• Maintain comprehensivedocumentation and data lineagewithin dbt projects.
• Work with modernSnowflake capabilities, particularlyDynamic Tables, alongside dbt models.
• UtilizeSnowflake Notebooksfor development and deployment of environment changes.
• Implement and manageSnowflake DevOpspractices and processes.
• Managedbt environments and targetsacross Development, Testing, and Production.
• ExecuteSQL scripts and dbt projects directly within Snowflakeusing Git repositories.
• Design and maintainCI/CD pipelinesusing Snowflake Git integration and dbt.
• ImplementSlim CI, state-based runs, and automated testing gatesas part of pull request workflows.
• DevelopPython scripts and dbt Python models, where appropriate, for orchestration, automation, and data processing.
• Collaborate with data engineering, analytics, and other technical teams to deliver reliable and scalable data solutions.
• Follow best practices forcode quality, version control, testing, deployment, and data engineering standards.

Required Skills

• Strong hands-on experience withSnowflake.
• Strong experience indbt (data build tool).
• ExcellentSQLskills.
• Experience developingdbt models, tests, snapshots, macros, and documentation.
• Knowledge ofSnowflake Dynamic Tables.
• Experience withSnowflake Git integrationand DevOps capabilities.
• Hands-on experience withCI/CD pipelines.
• Knowledge ofdbt Slim CI and state-based deployments.
• Experience withGit/GitHub/GitLab or similar version-control platforms.
• StrongPythonprogramming/scripting skills.
• Experience working acrossDev, Test, and Production environments.