Data Platform Consultant (DBT)

- 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.

- 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.

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.

We’re looking for someone who brings a mix of experience, curiosity, and collaboration. 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

- 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.

- 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)