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.
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
We're a high-growth data analytics consultancy on a mission to help enterprise businesses unlock the full potential of their data. With offices in the UK, India, and South Africa, we specialise in cutting-edge cloud analytics solutions, transforming complex data challenges into actionable business insights.We partner with some of the biggest brands worldwide to modernise their data platforms, enabling smarter decision-making through Snowflake, Databricks, Matillion, and other cloud technologies. Our approach is customer-first, innovation-driven, and results-focused, delivering impactful solutions with speed and precision.At Snap, we’re not just consultants, we’re problem-solvers, engineers, and strategists who thrive on tackling complex data challenges. Our culture is built on collaboration, continuous learning, and pushing boundaries, ensuring our people grow just as fast as our business.Join us and be part of a team that’s shaping the future of data analytics!
Similar Jobs
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead FRTB-SA and SA-CVA risk and compliance initiatives for US regulations. Gather and document business requirements, bridge business and technology teams, define testing objectives, and coordinate with testing teams. Apply Python-based independent implementation skills, financial product and trade lifecycle knowledge, and experience across regulatory reporting, trade processing, collateral management, or derivatives operations. Support process change using Agile methodologies and work across onshore and offshore teams.
Top Skills:
Agile MethodologyJupyter NotebookMS OfficePythonSoftware Development Life Cycle (Sdlc)
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead FRTB-SA and SA-CVA risk and compliance initiatives for US regulations. Gather and document business requirements, bridge business and technology teams, define testing objectives, and coordinate with testing teams. Apply Python implementation skills, financial product knowledge, trade lifecycle expertise, regulatory reporting, collateral management, and derivatives operations experience. Support process change using Agile methods across onshore and offshore teams.
Top Skills:
AgileJupyter NotebookMS OfficePythonSdlc
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead FRTB-SA and SA-CVA risk and compliance initiatives for US regulations. Gather and document business requirements, bridge business and technology teams, define testing objectives, and collaborate with onshore and offshore teams. Apply Python-based implementation skills, financial product and trade lifecycle knowledge, Agile process experience, regulatory reporting expertise, and analytical problem-solving to support financial services transformation projects.
Top Skills:
Jupyter NotebookMS OfficePython
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
