The Role
Designs and maintains dbt Core data models and scalable Snowflake transformation pipelines. Responsibilities include SQL development, performance tuning, testing, documentation, version control, CI/CD practices, and translating business requirements into technical schemas. The consultant collaborates with analysts, business leads, project managers, and engineers while progressively delivering work independently across client projects.
Summary Generated by Built In
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.
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:
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.
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)
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
About
Snap Analytics is a specialist data and AI consultancy that designs and engineers modern cloud data platforms for large enterprises. We’re the team of “invisible engines” that turn complex, siloed data into a trusted foundation for analytics and AI. Founded in Bristol in 2019, we’re best known for our deep SAP expertise combined with modern platforms like Snowflake, Databricks, Fivetran, dbt and AWS. We believe in creating a world where data makes sense for everyone and that technology alone doesn’t solve problems: it takes skilled people who understand business processes, working with a no-ego, customer-first mindset.We work with global enterprises in manufacturing, energy, retail and consumer goods, and financial services to bring their SAP and non-SAP data together into one governed, well-engineered platform so they can make faster decisions, cut cost and complexity, and put AI use cases into production. Our work includes high-performance engineering for elite Formula 1 racing teams, the digital transition for more than 5.8 million UK energy customers, supply chains that reach 94% of UK households, and wealth-management platforms supporting over one million families. Every engagement is delivered through Snap 360, our delivery framework, built on four pillars: Data, People, Processes and Technology.This is a genuinely exciting time to join; demand for SAP-to-cloud modernisation and enterprise AI is accelerating, and we’re scaling our teams across the UK, India and South Africa to meet it. Honestly, rapid growth also means some of our internal processes and team structures are still evolving, and as a consultancy your priorities will often be shaped by client timelines, so you’ll need to be comfortable with change.
Skills Required
- At least 2 years of experience with dbt Core
- Experience with dbt macros, packages such as dbt-utils, and Jinja templating
- Strong SQL fundamentals and practical dbt experience
- Deep understanding of Snowflake Tasks, Streams, Snowpipe, and zero-copy cloning
- Clear communication with technical and non-technical stakeholders
- Learning mindset, proactive approach, curiosity, and willingness to improve automation and processes
- Transparency, ownership, initiative, and ability to work with increasing autonomy
- Familiarity with Git or Bitbucket and awareness of CI/CD concepts
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Snap Analytics is a global data analytics and AI consultancy that designs and engineers data stacks, helping organizations unlock the full value of their data by connecting data, technology, and teams.
