Snowflake Administrator / Data Platform Engineer@Novi, MI (onsite )

Position: Snowflake Administrator / Data Platform Engineer

Location: Novi, MI (onsite )

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

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.