Snowflake Developer (Manager)

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.

Additional Requirements & Eligibility

• Right to work in the Philippines: must hold (and maintain) the appropriate visa/work authorisation for the role and assignment length.
• Hold a current passport suitable for business travel (including the ability to obtain visas as required) and be willing to travel where needed.
• Satisfy KPMG background screening and any client-specific screening requirements (which may include identity, criminal history, qualification, professional membership and other checks).
• Provide required onboarding documentation as requested by People & Inclusion.