Data Platform Consultant (DBT)

Snap Analytics; Jammu district; Vor Ort; INR 1.500.000 - 2.100.000; Vollzeit

Zusammenfassung

Snap Analytics in Pune is seeking a Data Platform Consultant (DBT) to design and deliver data transformations powering a high-visibility project. You’ll work with project leads, engineers and analysts to ship reliable data solutions using dbt Core and Snowflake.

The role requires 2 years’ dbt Core experience, strong SQL, and the ability to translate business needs into robust data models with good documentation and testing practices.

Qualifikationen

• 2 years’ experience in dbt Core, including macros, packages (dbt-utils), and Jinja templating.
• Strong SQL fundamentals and practical exposure to DBT.

Aufgaben

• Design, develop, and maintain data models and transformations using dbt Core.
• Build and manage scalable data pipelines in Snowflake with performance focus.
• Apply software engineering practices: version control, modularity, and CI/CD.
• Write robust dbt tests and maintain documentation via dbt docs.
• Tune Snowflake compute and storage; optimize queries and clustering keys.
• Collaborate with Analysts and Leads to translate requirements into schemas.

Kenntnisse

SQL

Clear communication

Ownership & accountability

Tools

dbt Core

dbt-utils

Jinja templating

Git/Bitbucket

CI/CD

Jobbeschreibung

Data Platform Consultant (DBT)

Department: Data Platforms

Employment Type: Permanent - Full Time

Location: Pune, India

Reporting To: Sunny Kulkarni

Description

The headlines... Immediate Joiners Preferred Location - Hybrid in our central Pune office A few application tips… We want to help you put your best foot forward. Here are a few things we look for:

• Clear, specific examples of your work and impact
• Relevant experience aligned with the role’s focus
• A thoughtful response to any application questions
• A resume that highlights both what you did and why it mattered

This role is designed to strengthen our delivery capability across our most strategic accounts in industries like Consumer Goods, Financial Services and Energy.

As the demand for data and AI-driven transformation grows, so does the need for structured, proactive project leadership. At Snap Analytics, we help clients unlock the full potential of their data, and we’re scaling fast. We’re building DBT capability on a project. As a small, agile organisation, we’re investing in people who can help us deliver quickly and grow our competency in India with support from UK colleagues. You’ll have clear impact from day one and room to move across projects as you develop.

What you’ll be doing…

You’ll play a central role in designing and delivering data transformations that power a high‑visibility project. You’ll work closely with project leads, project managers, and senior engineers to ship quality outcomes with increasing autonomy.

Your responsibilities will include:

• Data Modelling: Design, develop, and maintain complex data models using dbt Core to support various business functions.
• Pipeline Optimization: Build and manage scalable data transformation pipelines within Snowflake, ensuring high performance and cost-efficiency.
• Code Quality: Implement software engineering best practices in the data stack, including version control (Git), modularity, and CI/CD.
• Testing & Documentation: Ensure data integrity by writing robust dbt tests and maintaining comprehensive documentation via dbt docs.
• Performance Tuning: Optimize Snowflake compute and storage by managing clustering keys, materialized views, and efficient SQL querying.
• Stakeholder Collaboration: Work closely with Data Analysts and Business Leads to translate business requirements into technical data schemas.

In your first 3–6 months, success might look like:

• Delivering the majority of your assigned work independently, to a high standard (quality + on‑time)
• Demonstrating holistic project understanding - how your work fits the wider data flow and business goals
• Building healthy working relationships across the India team and, over time, with UK stakeholders

What you’ll need to succeed…

We’re looking for someone who brings a mix of experience, curiosity, and collaboration.

• 2 years’ experience in dbt Core, including macros, packages (like dbt-utils), and Jinja templating (we’re not considering freshers for this role)
• Strong SQL fundamentals and practical exposure to DBT
• Deep understanding of Snowflake‑specific features such as Tasks, Streams, Snowpipe, and Zero-copy cloning.
• Familiarity with Git/Bitbucket and awareness of CI/CD concepts (nice to have)
• Clear communication - you can articulate your thinking to technical and non‑technical partners
• A learning mindset: proactive, curious, and willing to work “a notch above” expectations (automation, generalising code, improving process)
• Transparency and ownership - comfortable asking for help early and taking accountability for outcomes

This role might not be the right fit if you’re looking for:

• Highly siloed work with very narrow task scopes (we value holistic project thinking)
• Constant step‑by‑step guidance (we expect growing autonomy and initiative)

Why choose Snap

• Impact from day one on a new, high‑visibility project
• Growth in a small, agile company with opportunities to rotate across projects as you develop
• Supportive team culture - mentorship from seniors, collaboration with India & UK colleagues, open feedback and help‑seeking encouraged