Shift Timings: US Working Hours

Job Description:

WHAT YOU'LL DO

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-based deployment
Design dimensional and/or medallion-style (Bronze/Silver/Gold) data architectures that balance performance, cost, and usability
Use AI-assisted tools to accelerate development — generating boilerplate code, drafting SQL/dbt models, writing documentation, debugging pipeline failures, and summarising data quality issues
Partner with data quality, governance, and analytics teams to ensure data is well-modelled, well-documented, and trustworthy
Optimise Snowflake warehouse performance 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.,



reviewing AI-generated code, not blindly trusting output)
Contribute to internal standards for prompt patterns, reusable AI workflows, or tooling that make the whole team faster

CORE SKILLS

Snowflake —

strong hands-on experience with data modelling, performance tuning, security/access, and cost management
SnapLogic —

building and maintaining integration pipelines and connecting heterogeneous source systems
dbt —

writing modular, tested transformations; managing dependencies, macros, and documentation
Data Modelling —

dimensional modelling, medallion/layered architectures, normalisation vs. denormalisation trade-offs
Solid SQL and at least one scripting language (Python preferred)
Familiarity with orchestration tools (Airflow, ADF, or similar)
Working knowledge of git-based CI/CD workflows

AI-AUGMENTED WORKING STYLE (WHAT WE'RE LOOKING FOR)

Regularly uses AI coding assistants (Copil

📌 Senior Data Engineer (Mumbai)
🏢 Prudent Technologies and Consulting
📍 Mumbai