Industry Platforms - MDP Snowflake Consultant

Position Overview

Industry Platforms & Systems Integration (IP&SI) is the client's trusted delivery practise - bringing together platform expertise, systems integration, modern data foundations, and security-by-design to help clients deliver change faster, with confidence. We connect trusted data, modernise core platforms, and uplift capability to reduce cost and risk while enabling resilient, artificial intelligence (AI)-ready operations.

 The Modern Data Platform (MDP) Snowflake Architect / Consultant / Developer is responsible for designing, building, and operating modern data and analytics platforms on Snowflake. The role enables organisations to deliver scalable, secure, and cost-efficient data solutions that support analytics, reporting, data engineering, and artificial intelligence and machine learning (AI/ML) use cases.

 Depending on experience and seniority, the role may focus on hands-on development and delivery (Developer / Consultant) or on platform architecture, standards, and data strategy (Architect). The role works closely with business stakeholders, data teams, cloud and platform architects, and security teams to ensure Snowflake platforms are governed, performant, and enterprise-ready.

Key Responsibilities

Data Platform Design & Delivery

• Design and implement modern data platforms using Snowflake capabilities including data warehousing, data sharing, secure data collaboration, and (where applicable) Snowpark for data engineering.
• Build extract, load, transform (ELT) pipelines and transformations using Structured Query Language (SQL), dbt (where used), and orchestration tools aligned to client standards.
• Implement ingestion patterns including batch loads and near real-time feeds using Snowpipe, streams and tasks, and partner tooling (as applicable).
• Enable analytics, business intelligence (BI), and downstream consumption using curated models, secure views, and agreed semantic patterns.

Architecture & Platform Standards (Architect Focus)

• Define Modern Data Platform architecture on Snowflake, including account and environment strategy.
• Design scalable data warehouse and lakehouse patterns using Snowflake storage, compute, and data sharing capabilities.
• Establish standards for ingestion, modelling, cataloguing, data quality, and access using Snowflake objects (databases, schemas, roles, warehouses) and agreed delivery patterns.
• Ensure alignment with security, identity and access management (IAM), networking connectivity, and cost/performance practices (warehouses, resource monitors, query optimisation).
• Provide architectural guidance and governance across delivery teams, including design reviews and reusable accelerators.

Data Engineering & Analytics

• Develop and optimise ELT transformations, dimensional and/or Data Vault models (as applicable), and analytics datasets using Snowflake SQL and agreed tooling.
• Implement data quality, metadata, and lineage practices using platform features and enterprise tools (as applicable).
• Support advanced analytics workloads, including data preparation for AI/ML and, where applicable, Snowpark-based processing.

Operations, Governance & Optimization

• Implement monitoring, performance tuning, and cost controls using Snowflake governance features (resource monitors, query history, warehouse sizing).
• Apply data security and governance controls aligned to enterprise policies using Snowflake roles, object privileges, masking, and row-level security (where required).
• Support environment management and continuous integration and continuous delivery (CI/CD) for Snowflake objects and code, including version control, automated deployment, and release practices.
• Contribute to platform documentation, standards, and operational runbooks, including onboarding and support procedures.

Collaboration & Advisory

• Collaborate with business users, analysts, and data scientists.
• Advise stakeholders on Snowflake capabilities and design trade-offs (compute, cost, performance, security, and data sharing).
• Mentor junior engineers and consultants (Senior / Architect level).

Skills, Experience and Competencies

Technical Skills

• Strong expertise in Snowflake data platform capabilities and architecture.
• Experience with modern data warehouse and lakehouse patterns, including integration with object storage and data lakes.
• Strong Structured Query Language (SQL) and data modelling skills.
• Experience with ingestion and orchestration patterns, including batch and near real-time delivery (Snowpipe, streams and tasks, and partner tools as applicable).
• Understanding of data security, identity and access management, governance, and cost optimisation in Snowflake.

Experience (Role Level Determination)

MDP Snowflake Architect

• 10–15+ years of data and analytics experience.
• 5–8+ years designing enterprise-scale data platforms, including significant Snowflake architecture and delivery experience.
• Proven experience defining modern data strategies and cloud architectures.

MDP Snowflake Consultant

• 6–9 years of data and analytics experience.
• 3–5 years delivering modern data platforms, including Snowflake development and delivery experience.
• Strong delivery, solution design, and stakeholder engagement skills.

MDP Snowflake Developer

• 4–6 years of overall data / analytics experience.
• 1–3 years of hands-on experience with Snowflake, including SQL development and basic administration concepts.
• Strong focus on implementation and development.

Competencies

• Demonstrated ability to deliver modern data platforms on Snowflake using scalable warehouse and lakehouse patterns.
• Demonstrated ability to build and optimise ELT transformations and data models in Snowflake using strong SQL and agreed delivery patterns.
• Ability to define reference architectures, reusable patterns, and build-ready design artefacts for Snowflake delivery.
• Ability to apply security by design in Snowflake using roles, least privilege, data masking and governance controls aligned to enterprise requirements.
• Operational excellence, including query performance tuning, warehouse sizing, resource monitoring, and runbook development to support stable operations.
• Ability to collaborate with multiple stakeholders, explain Snowflake design trade-offs, and support capability uplift through coaching and knowledge transfer.

Qualifications and Certifications

• SnowPro Core Certification.
• SnowPro Advanced (Architect, Data Engineer, or other relevant speciality), where appropriate for role level.
• dbt certification and/or relevant cloud platform certifications (desirable).

What Success Looks Like

• Snowflake is implemented as a well-architected modern data platform aligned to agreed standards.
• Data pipelines are reliable, scalable, and cost efficient.
• Data is governed, secure, and trusted by business users.
• Analytics and insights are delivered quickly and consistently.
• Platform operations are stable and easy to manage.