Need Senior Snowflake Admin Data Engineer- Fort Mill, SC (Onsite)

Caliber Smart; Fort Mill (SC); On-site; USD 120,000 - 180,000; Full time

Job summary

Caliber Smart is seeking a Senior Snowflake Data Engineer to design and operate scalable Snowflake-based data solutions from Fort Mill, SC. You will administer environments across development, testing, and production, with a focus on security, performance, and cost optimization.

The role requires hands-on Snowflake, AWS Glue, SQL, Python, and governance expertise, plus experience building CI/CD for data pipelines and IaC with Terraform.

Qualifications

• 8+ years IT experience with at least 4+ years Snowflake experience.
• Strong Snowflake administration and platform management.
• Hands-on experience with AWS Glue and cloud-based data engineering solutions.
• Advanced proficiency in SQL and Python.

Responsibilities

• Administer and support enterprise Snowflake environments across development, testing, and production.
• Design, develop, and maintain scalable ETL/ELT pipelines using AWS Glue and Snowflake.
• Analyze query performance and optimize Snowflake workloads; monitor costs.
• Develop CI/CD pipelines for Snowflake deployments and automate admin activities.

Skills

Snowflake Administration

Snowflake Data Engineering

AWS Glue

SQL

Python

Tools

Terraform

Apache Airflow

GitHub Actions

GitLab CI/CD

Azure DevOps

Job description

Position: Senior Snowflake Data Engineer

Duration: 12 Months

Location: Fort Mill, SC (Onsite)

Job Summary

We are seeking a highly skilled Snowflake Platform SME / Data Engineer with strong platform administration and data engineering expertise to support and enhance our enterprise data ecosystem. The ideal candidate will have hands-on experience in Snowflake administration, AWS Glue, cloud data engineering, security, performance optimization, and data platform governance. This role will be responsible for designing scalable data solutions while ensuring operational excellence, security, and cost optimization across the Snowflake platform.

Key Responsibilities

Snowflake Platform Administration

• 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.

Data Engineering

• 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.

Performance & Cost Optimization

• 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.

Automation & DevOps

• 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.

Required Qualifications

• 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
• Snowflake account administration
• Data replication and disaster recovery
• 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.

Preferred Skills

• 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.

Snowflake Certifications Such As

• SnowPro Core Certification
• SnowPro Advanced Architect
• SnowPro Advanced Data Engineer
• Experience with data governance, compliance, and enterprise security frameworks.

Key Attributes

• Strong platform ownership and operational mindset.
• Ability to lead Snowflake architecture and administration best practices.
• Excellent stakeholder management and communication skills.
• Proven ability to work across engineering, analytics, and business teams.
• Proactive approach to performance tuning, automation, and cost optimization.
• Ability to mentor junior engineers and drive technical excellence.

Must Have Skills

• Snowflake Administration
• Snowflake Data Engineering
• AWS Glue
• SQL
• Python

Nice to Have

• AWS Lambda
• Apache Airflow
• Terraform
• CI/CD Pipelines
• Snowpark
• Data Governance & Security Controls

Location Requirement: Candidate should be willing to work from Fort Mill, SC and collaborate with global teams as required.