What are the responsibilities and job description for the Snowflake Platform Admin position at Innorev Technologies, Inc?
Key Responsibilities:
Snowflake Platform Engineering
• Design, deploy, and manage enterprise-scale Snowflake environments.
• Build and maintain Snowflake platform standards, governance models, and operational procedures.
• Provision and manage databases, schemas, warehouses, integrations, roles, and security objects.
• Implement scalable and reusable Snowflake architecture patterns.
• Optimise Snowflake performance, resource utilisation, and operational costs.
Infrastructure as Code & Automation
• Develop and maintain Terraform modules for Snowflake infrastructure provisioning.
• Automate deployment of:
o Virtual Warehouses
o Databases and Schemas
o RBAC Roles
o Users and Service Accounts
o Storage Integrations
o External Stages
o Network Policies
o Resource Monitors
• Create reusable IaC frameworks that support multi-environment deployments.
• Implement GitOps principles and automated deployment pipelines.
DevOps & CI/CD
• Design and maintain CI/CD pipelines for Snowflake platform deployments.
• Integrate Snowflake infrastructure deployment with Azure DevOps, GitHub Actions, GitLab CI, or Jenkins.
• Automate change management, validation, testing, and release processes.
• Implement environment promotion strategies across Development, QA, UAT, and Production.
• Develop automated rollback and recovery procedures.
Security & Governance
• Design and implement Role-Based Access Control (RBAC) frameworks.
• Define and maintain Snowflake security standards and governance policies.
• Configure and manage:
o Network Policies
o Private Connectivity
o SSO Integration
o MFA Controls
o Data Access Governance
• Conduct security reviews and access audits.
• Ensure compliance with enterprise security and regulatory requirements.
Warehouse Management & Optimisation
• Automate warehouse provisioning and lifecycle management.
• Implement auto-scaling and auto-suspend policies.
• Monitor warehouse utilisation and recommend optimisation opportunities.
• Define resource management strategies to improve performance and control costs.
Monitoring & Operations
• Implement monitoring, alerting, and observability frameworks.
• Troubleshoot platform issues and resolve production incidents.
• Perform root cause analysis and implement preventive measures.
• Maintain platform documentation, runbooks, and operational procedures.
Collaboration
• Partner with Data Engineering, Security, Architecture, and Operations teams.
• Provide technical leadership and platform guidance.
• Participate in architecture reviews and platform governance discussions.
• Mentor junior engineers and promote automation-first practices.
Salary : $60