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
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.
Similar Jobs
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Prepares and reviews accounting records, financial statements, management fee calculations, invoices, investor statements, capital calls, and distribution notices for private equity funds. Supports onshore teams, ensures compliance with LPAs and side letters, manages competing priorities, resolves client issues, and maintains stakeholder relationships. Requires advanced Excel and macro skills, knowledge of US GAAP or IFRS, and familiarity with Investran.
Top Skills:
Excel MacrosInvestranExcelMS Office
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Manage accounting and reporting for private equity, hedge fund, and debt fund clients. Responsibilities include maintaining complex fund structures, recording investor commitments and capital activities, booking transactions, preparing NAV workbooks, calculating management fees, carried interest, preferred returns, and performance ratios, finalizing financial records, producing investor and fund-level reports, and addressing client accounting and operational issues.
Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Provides advanced technical support for customer cloud and telecom environments, resolving incidents, analyzing logs, troubleshooting networking and storage systems, managing software updates, and meeting SLA requirements. The role coordinates critical issues, preventive actions, root-cause analysis, knowledge sharing, operational reviews, project handovers, and customer communications. It also supports pre-sales activities, identifies sales opportunities, and requires expertise in OpenStack, Kubernetes, Red Hat platforms, Ceph, cloud networking, and telecom cloud applications.
Top Skills:
3GppAmfBfdBgpCcdmCcpcCcrcCcsmCephCloud NetworkingCloud StorageEpgImsIp RoutingKubernetesMmeOpenstackOspfPccRed Hat OpenshiftRed Hat Openstack PlatformSapcSdiSdnSmf
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.


