Instructions:
- 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.
- Only 2 quality pre-qualified candidates.
- 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
