Snowflake Platform Admin & Data Engineer

Job Title: Snowflake Platform Admin & Data Engineer

Job Location: Fort Mill, SC

Job Type: Contract

Job Overview:

Pay Range: $55.00hr - $60.00hr

Requirement/Must Have:

• 8+ years of IT experience with at least 4+ years of hands-on Snowflake experience.
• Strong expertise in Snowflake administration and platform management.
• Hands-on experience with AWS Glue and cloud-based data engineering solutions.
• Advanced proficiency in SQL and Python.
• Experience managing RBAC and security frameworks.
• Experience managing Snowflake account administration.
• Experience managing data replication and disaster recovery.
• Experience managing data masking and governance controls.
• Strong understanding of Snowflake architecture, virtual warehouses, storage, compute, and optimization techniques.
• Experience with AWS services such as S3, IAM, CloudWatch, Lambda, and Secrets Manager.
• Strong troubleshooting, problem-solving, and analytical skills.
• Willingness to work from Fort Mill, SC and collaborate with global teams as required.

Responsibilities:

• Administer and support enterprise Snowflake environments across development, testing, and production.
• Manage Snowflake account setup, user provisioning, roles, permissions, and Role-Based Access Control (RBAC).
• Implement and maintain security controls including SSO, MFA, dynamic data masking, row-level security, and secure data sharing.
• Configure and monitor resource monitors, virtual warehouses, and workload management to optimize platform performance and cost.
• Design and manage cross-region replication, disaster recovery, and business continuity solutions.
• Monitor platform health, troubleshoot issues, and provide proactive recommendations for improvement.
• Design, develop, and maintain scalable ETL/ELT pipelines using AWS Glue and Snowflake.
• Build and optimize data ingestion frameworks from multiple cloud and on-premises data sources.
• Develop data models, transformations, and data warehouse solutions to support analytics and reporting.
• Leverage Snowflake features including Snowpipe, Streams, Tasks, Stored Procedures, Time Travel, and Zero-Copy Cloning.
• Implement data quality, validation, and monitoring processes.
• Analyze query performance and optimize Snowflake workloads.
• Monitor warehouse utilization and implement strategies to reduce operational costs.
• Tune data pipelines, SQL queries, and storage utilization for maximum efficiency.
• Establish platform standards, governance policies, and best practices.
• Develop CI/CD pipelines for Snowflake deployments and data engineering solutions.
• Automate administrative and operational activities using Python, SnowSQL, and scripting frameworks.
• Support Infrastructure as Code (IaC) initiatives using Terraform or similar technologies.

Nice to Have:

• Experience with Apache Airflow for orchestration.
• Knowledge of Snowpark, Snowpipe, Data Sharing, and Native Applications.
• Experience with Terraform and Infrastructure as Code.
• Experience with CI/CD tools such as GitHub Actions, GitLab CI/CD, or Azure DevOps.
• SnowPro Core Certification.
• SnowPro Advanced Architect.
• SnowPro Advanced Data Engineer.
• Experience with data governance, compliance, and enterprise security frameworks.
• AWS Lambda.

Skills:

• Snowflake Administration.
• Snowflake Data Engineering.
• AWS Glue.
• SQL.
• Python.
• Strong verbal and written communication skills.
• Excellent communication and presentation skills.

Qualification And Education:

• 8+ years of IT experience.
• 4+ years of hands-on Snowflake experience.

== ==

• Medical, Dental, and Vision Insurance
• 401(k) Retirement Plan
• Health Savings Account (HSA)
• Disability Insurance (Short-Term and Long-Term)
• Life and AD&D Insurance
• Paid Sick Leave (where required by applicable state or local law)
• Supplemental Insurance Plans
• Identity Theft Protection
• Pet Insurance
• Employee Wellness Programs
• Employee Assistance Program (EAP)
• Career Growth and Professional Development Opportunities