Snowflake Platform Admin + Data Engineer
Automation
Aws Data Lake
Cloud
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Infrastructure
Cloud Operations
Cloud Platform
Cloud Platforms
Cloud Technology
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Pipeline
Data Platform
Data Processing
Data Security
Data Warehouse
Data Warehousing
Database
Databases
DevOps
DevSecOps
Engineer
ETL
Informatica
Infrastructure As Code
Integration
Programming
Security Automation
Snowflake
SQL
Job Description
Capgemini is hiring a Snowflake Platform Admin and Data Engineer for hybrid work in Atlanta, GA to administer enterprise Snowflake environments and deliver scalable data engineering pipelines with strong governance.
Responsibilities
- Administer and support enterprise Snowflake environments across development, testing, and production
- Handle Snowflake account setup and operations including user provisioning, roles, permissions, and RBAC
- Implement and maintain security controls: SSO, MFA, dynamic data masking, row-level security, and secure data sharing
- Configure and monitor resource monitors, virtual warehouses, and workload management to optimize 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 improvements
- Design, develop, and maintain scalable ETL/ELT pipelines using AWS Glue and Snowflake
- Build and optimize ingestion frameworks from multiple cloud and on-premises data sources
- Create data models, transformations, and data warehouse solutions for analytics and reporting
- Use Snowflake capabilities 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
Requirements
- 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
Additional Experience Managing
- RBAC and security frameworks
- Snowflake account administration
- Data replication and disaster recovery
- Data masking and governance controls
- Strong understanding of Snowflake architecture, including virtual warehouses, storage, compute, and optimization techniques
- AWS services experience including 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, including:
- SnowPro Core Certification
- SnowPro Advanced Architect
- SnowPro Advanced Data Engineer
- Experience with data governance, compliance, and enterprise security frameworks
Must Have Skills
- Snowflake Administration
- Snowflake Data Engineering
- AWS Glue
- SQL
- Python
- Nice to Have: AWS Lambda
- Nice to Have: Apache Airflow
- Nice to Have: Terraform
- CI/CD Pipelines
- Snowpark
- Data Governance & Security Controls
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
Technologies
- Snowflake, AWS Glue, AWS S3, AWS IAM, AWS CloudWatch, AWS Lambda, AWS Secrets Manager
- SQL, Python, SnowSQL
- RBAC, SSO, MFA, dynamic data masking, row-level security, Snowpipe, Streams, Tasks, Stored Procedures, Time Travel, Zero-Copy Cloning
- Snowpark, Data Sharing, Native Applications
- Terraform, Infrastructure as Code (IaC), CI/CD, GitHub Actions, GitLab CI/CD, Azure DevOps, Apache Airflow
- Snowflake certifications: SnowPro Core Certification, SnowPro Advanced Architect, SnowPro Advanced Data Engineer
Location and Salary
- Location: Atlanta, GA (hybrid)
- Salary: USD 103,330 - 128,656 per yearly
Benefits
- Flexible work
- Healthcare including dental, vision, mental health, and well-being programs
- Financial well-being programs such as 401(k) and Employee Share Ownership Plan
- Paid time off and paid holidays
- Paid parental leave
- Family building benefits including adoption assistance, surrogacy, and cryopreservation
- Social well-being benefits such as subsidized back-up child/elder care and tutoring
- Mentoring, coaching and learning programs
- Employee Resource Groups
- Disaster Relief
- Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days depending on grade, Company paid holidays, Personal Days, Sick Leave
- Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
- Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
- Life and disability insurance
- Employee assistance programs
- Other benefits as provided by local policy and eligibility