What you will be working on
In this role, you will:
- Engineer, administer and evolve Snowflake platform capabilities that enable secure, reliable and scalable use of the platform across application and data workloads.
- Implement security controls and platform guardrails covering role-based access control, least-privilege access, authentication, encryption, audit logging and periodic access reviews.
- Identify and remediate excessive privileges, vulnerabilities and configuration weaknesses, and strengthen platform security through automation and continuous improvement.
- Manage platform provisioning, configuration, upgrades, integrations, migrations and lifecycle activities across Snowflake and supporting Azure services.
- Monitor and optimise SQL queries, workload performance, virtual warehouse sizing, resource utilisation and credit consumption while maintaining operational resilience.
- Design and maintain Infrastructure-as-Code using Terraform, together with version control and CI/CD practices, to enable consistent, secure and auditable platform changes.
- Develop automation, monitoring and observability capabilities using scripting and platform tooling to streamline administration, identify issues early and improve platform reliability.
- Collaborate with cybersecurity, infrastructure and application teams on platform engineering, security assessments, incident investigations, audit remediation, recovery and business continuity activities.
What we are looking for
We value the diverse talents and experiences that each individual brings to the table. While mastery of every requirement may not be necessary, familiarity and expertise in some of the following areas will position you for success within this team.
- Relevant experience in hands-on administration and engineering of Snowflake environments, including databases, schemas, virtual warehouses, access controls, monitoring and operational support.
- Applied knowledge of Snowflake architecture, SQL and query optimisation, workload management, secure data sharing, resource utilisation and platform performance tuning.
- Applied knowledge of database and data security principles, including least privilege, role-based access, identity management, encryption, security hardening, auditing and sensitive data protection.
- Experience with Azure cloud services and cloud operations, including the application of security and governance controls in cloud environments.
- Experience using Terraform or equivalent Infrastructure-as-Code tools, with familiarity in version control and CI/CD practices for secure, repeatable and auditable platform changes.
- Ability to automate administration, monitoring and security-related activities using Python, PowerShell or similar scripting languages.
- Knowledge of database resilience, recovery testing and business continuity, with experience in SQL Server, PostgreSQL, MongoDB or other database platforms considered advantageous.
- Ability to identify and address security and operational risks, exercise sound judgement, take accountability for platform outcomes, and collaborate effectively across technical teams.
The seniority of appointment and actual corporate job titles will be commensurate with individual work experience.
The position is on a 2-year full-time contract directly on the payroll of CPF Board with potential for emplacement into a permanent position.