Snowflake Consultant

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