Snowflakes Developer (MDP)

6-9 Years

Save

Early Applicant

Job Description

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.

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.

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

Working Setup