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 accelerator.
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.
MDP Snowflake
- Manager10–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.
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.
