Senior Data Engineer

AlgoLeap Technologies Pvt Ltd.; Hyderabad; On-site; INR 4,000,000 - 6,500,000; Full time

Job summary

Algoleap Technologies Pvt Ltd is seeking an experienced Data Engineer to design, build, and maintain robust ETL/ELT pipelines on a Snowflake-based data platform in Hyderabad. You will connect source systems and downstream consumers via SnapLogic, and develop modular dbt models with rigorous testing and CI/CD deployment.

You will design dimensional architectures (Bronze/Silver/Gold) while optimizing performance and costs, using AI-assisted tools to accelerate development and improve data quality.

Qualifications

• 8+ years in data engineering with at least 4+ years focused on Snowflake and modern ELT tooling (dbt).
• Track record of delivering production-grade pipelines at scale.
• Experience with AI-assisted development workflows and tooling is a plus.

Responsibilities

• Design, build, and maintain robust ETL/ELT pipelines feeding a Snowflake-based data platform.
• Build and manage integrations using SnapLogic to connect source systems, APIs, and downstream consumers.
• Develop and maintain data models and transformations in dbt, including tests, documentation, and CI/CD deployment.
• Design dimensional and/or medallion-style data architectures (Bronze/Silver/Gold) balancing performance, cost and usability.
• Use AI-assisted tools to accelerate development, generate boilerplate code, draft SQL/dbt models, and document data quality issues.
• Partner with data quality, governance, and analytics teams to ensure data is well-modelled, documented, and trustworthy.
• Optimize Snowflake warehouse performance and cost through query tuning, clustering, and resource monitors.
• Write clean, tested, version-controlled code and contribute to CI/CD pipelines.
• Mentor junior engineers, including on using AI tools responsibly and effectively.
• Contribute to internal standards for prompt patterns and reusable AI workflows.

Skills

Snowflake

SnapLogic

dbt

Data modelling

SQL

Python

Airflow

Git / CI-CD

Tools

Snowflake

SnapLogic

dbt

Airflow

Git

Job description

Algoleap Technologies Pvt Ltd | Full time

• Design, build, and maintainrobust ETL/ELT pipelines feeding a Snowflake-based data platform
• Build and manage integrationsusing SnapLogic to connect source systems, APIs, and downstream consumers
• Develop and maintain data modelsand transformations in dbt, including tests, documentation, and CI/CD-baseddeployment
• Design dimensional and/ormedallion-style (Bronze/Silver/Gold) data architectures that balanceperformance, cost, and usability
• Use AI-assisted tools toaccelerate development — generating boilerplate code, drafting SQL/dbt models,writing documentation, debugging pipeline failures, and summarising dataquality issues
• Partner with data quality,governance, and analytics teams to ensure data is well-modelled,well-documented, and trustworthy
• Optimise Snowflake warehouseperformance and cost (query tuning, clustering, resource monitors)
• Write clean, tested,version-controlled code and contribute to CI/CD pipelines
• Mentor junior engineers,including on how to use AI tools responsibly and effectively (e.g., reviewingAI-generated code, not blindly trusting output)
• Contribute to internal standardsfor prompt patterns, reusable AI workflows, or tooling that make the whole teamfaster

CORESKILLS

• Snowflake — strong hands-on experience withdata modelling, performance tuning, security/access, and cost management
• SnapLogic — building and maintainingintegration pipelines and connecting heterogeneous source systems
• dbt — writing modular, tested transformations; managingdependencies, macros, and documentation
• DataModelling — dimensional modelling,medallion/layered architectures, normalisation vs. denormalisation trade-offs
• Strong SQL and at least onescripting language (Python preferred)
• Familiarity with orchestrationtools (Airflow, ADF, or similar)
• Working knowledge of git-basedCI/CD workflows

AI-AUGMENTEDWORKING STYLE (WHAT WE'RE LOOKING FOR)

• Regularly uses AI codingassistants (Copilot, Claude Code, Cursor, ChatGPT, etc.) as part of the dailyworkflow — not just for one-off snippets
• Comfortable prompting AI toolsfor tasks like generating dbt models, writing test cases, summarising dataquality issues, or drafting documentation
• Applies good judgement aboutwhen AI output needs review vs. can be trusted — treats AI as a fast firstdraft, not a final answer
• Curious about applying AI tostructural problems: pipeline debugging, anomaly detection, metadatageneration, code review support
• Comfortable working in anenvironment where AI-usage practices are still evolving, and contributes ideasto shape them

NICETO HAVE

• Experience with data qualitytooling (SODA,Collibra, or similar)
• Exposure to cloud platforms(Azure, AWS, or GCP)
• Experience in a regulated orenterprise-scale data environment
• Prior experience mentoring orleading a small pod of engineers

EXPERIENCE

• 8+ years in data engineering,with at least 4+ years focused on Snowflake and modern ELT tooling (dbt)

Track record of delivering production-grade pipelinesat scale