Data Platform Consultant (DBT)
Posted
Summary
A data engineer/consultant who designs, builds, and maintains data transformation models in dbt Core on Snowflake for client projects, with responsibility for pipeline performance, testing, documentation, and CI/CD-based code quality. Works closely with analysts and business stakeholders, collaborating with India and UK teams at a data analytics consultancy.
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:
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
If you’re unsure whether your background is the “perfect fit,” we still encourage you to apply. We value potential and growth just as much as experience.
Why this role exists…
Why this role exists…
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.
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.
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:
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
We’re looking for someone who brings a mix of experience, curiosity, and collaboration.
You might be a great fit if you have:
You might be a great fit if you have:
- 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)
- 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
