Snowflake Consultant

Blue Wolf Digital; United Kingdom; Remote; GBP 90,000 - 130,000; Full time

Job summary

Blue Wolf Digital is seeking a senior, client-facing data engineering expert to own the design of end-to-end data solutions – from requirements, through architecture, to delivery – while mentoring colleagues and helping shape the direction of the engineering practice.

You will lead solution design across ingestion, transformation, storage and serving layers, balance trade-offs on cost and performance, and collaborate with stakeholders on compelling data platforms in a remote UK-based setup.

Qualifications

• Extensive SQL and Python experience.
• Hands-on cloud data platform experience (Snowflake, Databricks or similar).
• Strong data modeling and data warehouse design skills.
• Proven ability to lead client-facing engagements.

Responsibilities

• Lead the delivery of customer data projects end-to-end.
• Own solution design from discovery to architecture and estimates.
• Provide technical leadership within the data engineering team.
• Configure and manage client cloud platforms (e.g. Snowflake).
• Collaborate with stakeholders and analyze requirements.
• Produce clear technical documentation and proposals.
• Mentor junior colleagues and support pre-sales activities.

Skills

SQL

Python

Data modelling

Data architecture

Leadership

Stakeholder comms

Problem solving

GenAI awareness

Tools

Snowflake

Databricks

Microsoft Fabric

Azure

GCP

dbt

Fivetran

Matillion

Azure Data Factory

Git

CI/CD

Terraform

Power BI

Job description

Remote (UK Based)

This is a senior, client-facing role that blends hands-on engineering with solution design and technical leadership. You will own the design of end-to-end data solutions – from requirements, through architecture, to delivery – while mentoring colleagues and helping to shape the direction of their engineering practice.

Key Skills & Experience

Core engineering

• Highly experienced in SQL and Python
• Strong hands-on experience with one or more cloud data platforms (e.g. Snowflake, Databricks, Microsoft Fabric, Azure, GCP)
• Experience with data integration / ELT tooling (e.g. dbt, Fivetran, Hevo, Matillion, Azure Data Factory)
• Dimensional data modelling and data warehouse / lakehouse design
• Software engineering best practice: version control (Git), CI/CD, automated testing, and modular, reusable code
• Translating business requirements into clear, end-to-end technical solution designs
• Designing scalable, secure and maintainable data architectures across ingestion, transformation, storage and serving layers
• Producing solution design documentation, architecture diagrams and technical proposals and estimates
• Evaluating and recommending platforms and tools, including build-vs-buy decisions, with clear justification
• Balancing trade-offs across cost, performance, security, scalability and time-to-value
• Running discovery and requirements workshops with both technical and non-technical stakeholders
• Data governance, security, quality and compliance (e.g. GDPR)
• Cloud cost optimisation (FinOps) and performance tuning
• DataOps: orchestration, monitoring, and reliable, repeatable deployments

AI-ready data & modern analytics

• An understanding of how well-engineered data underpins AI and analytics use cases
• Awareness of GenAI / LLM concepts and agentic AI, and an interest in building “AI-ready” data foundations (e.g. Snowflake Cortex, Databricks AI, Microsoft Fabric / Copilot) – desirable
• Awareness of downstream BI and semantic layers (e.g. Power BI, Qlik) in order to design fit-for-purpose serving layers

Consulting & personal

• Confident communicator, able to present to and build trust with client stakeholders
• Self-starter and problem solver with a strong sense of ownership
• Good time management across concurrent client engagements
• Appetite to continually learn new technologies and techniques
• Willingness to mentor and develop more junior colleagues
• Relevant certifications, e.g. SnowPro, Databricks, dbt, or Microsoft Fabric / Azure (DP-series) or equivalent
• Infrastructure as Code experience (e.g. Terraform)
• Prior consultancy or client-facing delivery experience

Responsibilities

• Lead the delivery of customer projects – both technically, and by managing the project, the client relationship and more junior colleagues
• Own solution design: run discovery, capture requirements, and design end-to-end architectures, producing solution design documents and estimates
• Provide technical leadership and expertise on data engineering within the services team, supporting the Technical Director in developing and expanding the team’s capability
• Configure and manage client cloud platforms (e.g. Snowflake)
• Collaborate with customer stakeholders and analyse user requirements
• Create clear functional and technical documentation
• Deliver solutions aligned to industry best practice, and help establish reusable standards, frameworks and accelerators
• Ensure the quality of solutions through code reviews and testing
• Mentor and support the development of more junior colleagues
• Contribute to pre-sales activity – scoping, estimating, and building and demoing PoCs to prospects (on occasion)
• Work with the support team to help resolve tickets (on occasion)
• Keep your skills current with emerging technologies, including AI and GenAI