Senior / IT System Consultant (Database Platform)

What the role is

At #TeamCPF, you’re not just joining a team; you are embracing a culture of excellence, collaboration, and meaningful impact. You will play a pivotal role in empowering over 4 million members to secure their retirement, healthcare, housing needs and better navigate life’s uncertainties.

We thrive on sharp minds and insightful decisions. Your ability to analyse and think critically isn't just valued; it's essential. Every choice you make contributes to our collective success.

Collaboration is our way of life. We believe in the power of effective partnerships and seamless communications across teams. Together, we amplify each other’s strengths and achieve remarkable results.

Our learning never stops. We encourage your inquisitiveness and courage to embrace new challenges head-on. Your agility, readiness to challenge conventions, embrace of data-driven strategies, dedication to learning and applying new skills fuels our innovation and progress.

At the core of everything we do lies a genuine desire to make a difference. We serve our community and support each other with compassion, empathy, and unwavering dedications. Every action we take is guided by a deep sense of purpose and a commitment to those we serve.

Join us at #TeamCPF! Together, let's redefine possibilities and leave a legacy that echoes for generations.

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.

What you can expect

Being part of #TeamCPF means embarking on a challenging and rewarding career in a progressive workplace that values productivity and growth. Here’s what awaits you:

• Opportunities to engage in a mix of formal and informal training, keeping your skills sharp in our ever-evolving technological landscape.
• Promotion opportunities based on your capability and on-the-job performance.
• A vibrant community of like-minded and friendly colleagues, where collaboration and creativity thrive.
• A hybrid work model that offers flexibility for remote work, subject to exigencies of service.
• Flexible dress code that empowers you to choose your appropriate outfit for the day.
• A comprehensive rewards package that includes annual leave, pro-family leave, medical and dental benefits, and access to recreational activities.