Snowflake Platform Admin + Data Engineer

Capgemini•Atlanta, GA

22h•$103,330 - $128,656•Hybrid

About The Position

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world. The primary focus is to help organizations design, develop, and optimize their data infrastructure and systems. They help organizations enhance data processes, and leverage data effectively to drive business outcomes.

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

Nice To Haves

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.

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.

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 like adoption assistance, surrogacy, and cryopreservation
Social well-being benefits like subsidized back-up child/elder care and tutoring
Mentoring, coaching and learning programs
Employee Resource Groups
Disaster Relief
Medical, dental, and vision coverage
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs