Snowflake Administrator / Data Platform Engineer

Instructions:

1. You / your team has to video interview candidate, and ask them to show a physical ID (masking PII information), seek consent and submit with screenshot of that photo ID.
2. Only 2 quality pre-qualified candidates.
3. Profiles should be in SF, and candidate should complete online application once recruiter send invite to apply. This is vendor's responsibility.

Position: Snowflake Administrator / Data Platform Engineer
Location: Novi, MI (onsite )
Pay rate $78/hr.

Snowflake Administrator / Data Platform Engineer
Role Summary
We are seeking a highly skilled Snowflake Administrator / Data Platform Engineer with a minimum of 4 years of hands-on Snowflake administration experience to manage, optimize, secure, and support enterprise-scale Snowflake data platforms. The candidate will be responsible for platform administration, security governance, performance tuning, user access management, automation, monitoring, and operational excellence across cloud-based data ecosystems. Responsibilities align with Snowflake administrative functions such as role management, SCIM-based provisioning, warehouse administration, security, governance, monitoring, and performance optimization
Experience

• 4+ years of Snowflake Administration experience
• 6+ years of overall Data Platform or Data Engineering experience
• Experience supporting production-critical Snowflake environments
• Experience working in Azure cloud environments

Key Responsibilities
Snowflake Platform Administration

• Administer and maintain Snowflake accounts, databases, schemas, warehouses, resource monitors, and storage integrations.
• Create and manage users, roles, grants, RBAC hierarchy, and access policies.
• Implement enterprise security controls and governance frameworks.
• Manage Snowflake account parameters and platform configurations.

Identity & Access Management

• Configure and support SSO, SCIM provisioning, and federation integrations.
• Implement role-based access control (RBAC) and least-privilege security models.
• Manage user onboarding, role assignment, and access reviews.
• Support audit and compliance requirements.

Performance & Cost Optimization

• Monitor query performance and optimize workloads.
• Manage virtual warehouses and auto-scaling configurations.
• Tune clustering, caching, data retention, and storage utilization.
• Analyze platform utilization and recommend cost-saving measures.

Monitoring & Operations

• Implement monitoring, alerting, and operational dashboards.
• Troubleshoot platform incidents and performance issues.
• Support production releases, upgrades, and platform maintenance activities.
• Conduct root-cause analysis for platform-related incidents.

Data Governance & Security

• Implement masking policies, row-level security, and data classification.
• Support governance initiatives including tagging and metadata management.
• Manage audit trails, access history, and compliance reporting.
• Collaborate with security and governance teams.

Automation & DevOps

• Develop automation scripts using Python, SnowSQL, or Terraform.
• Support CI/CD pipelines for Snowflake deployments.
• Automate user provisioning, role assignments, and operational tasks.
• Implement Infrastructure-as-Code practices for Snowflake environments.

Required Technical Skills
Snowflake

• User & Role Administration
• RBAC and Security Management
• Warehouse & Resource Monitor Administration
• Query Performance Tuning
• Streams, Tasks, Dynamic Tables
• Snowpipe
• Data Sharing
• Time Travel & Fail-safe
• Clustering and Storage Optimization
• Monitoring and Governance

Cloud Platforms

• Azure
• IAM Concepts
• Cloud Networking Fundamentals

Database Technologies

• SQL (Advanced)
• PostgreSQL / SQL Server / Oracle knowledge
• Data Warehousing Concepts
• Data Modeling (Star/Snowflake Schema)

Automation & DevOps

• Python
• Shell Scripting
• Terraform
• Git
• CI/CD Tools

Security & Governance

• SSO/SAML
• SCIM Provisioning
• Data Masking
• Row-Level Security
• Audit & Compliance

Preferred Qualifications

• SnowPro Advanced Administrator Certification.
• Experience with dbt, Airflow, Kafka, Informatica, or StreamSets.
• Experience supporting large-scale enterprise data platforms.
• Exposure to Databricks, Azure Data Factory, or AWS Data Services.
• Knowledge of Data Governance tools such as Atlan, Collibra, or Alation.

Soft Skills

• Strong troubleshooting and problem-solving abilities.
• Excellent stakeholder communication skills.
• Ability to work with global delivery teams.
• Experience supporting Production, KTLO, and operational environments.

Nice-to-Have Certifications

• SnowPro Advanced Administrator
• SnowPro Core Certification
• AWS/Azure/GCP Cloud Certification
• Terraform Associate