DataJobs.io
← Back to all jobs

Job Description

Capgemini is seeking a platform-focused Snowflake administrator and data engineer to support enterprise Snowflake environments across development, testing, and production. This hybrid role in Atlanta, GA combines Snowflake operations with hands-on data engineering, governance, and automation so the platform can run securely, efficiently, and reliably.

You will be responsible for administering Snowflake at scale while building and optimizing ETL/ELT pipelines, implementing security controls, and improving performance and cost through continuous monitoring and tuning.

Key Responsibilities

  • Administer and support enterprise Snowflake environments across development, testing, and production
  • Manage Snowflake account setup including user provisioning, roles, permissions, and RBAC
  • Implement and maintain security controls such as 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 operational issues, and share 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 for analytics and reporting
  • Use 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; tune SQL queries and storage utilization for 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 initiatives using Terraform or similar technologies

Required Qualifications

  • 8+ years of IT experience, including 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

Technologies & Skills

  • 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)
  • CI/CD, including GitHub Actions, GitLab CI/CD, and Azure DevOps
  • Apache Airflow, SnowPro Core Certification, SnowPro Advanced Architect, SnowPro Advanced Data Engineer

Experience Managing

  • RBAC and security frameworks; Snowflake account administration
  • Data replication and disaster recovery
  • Data masking and governance controls
  • Understanding of Snowflake architecture, virtual warehouses, storage, compute, and optimization techniques
  • AWS services such as S3, IAM, CloudWatch, Lambda, and Secrets Manager
  • 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, and SnowPro Advanced Data Engineer
  • Experience with data governance, compliance, and enterprise security frameworks

Key Attributes

  • Strong platform ownership and an 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

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) with policy-defined vacation ranges and additional personal and sick leave
  • Medical, dental, and vision coverage (or provincial healthcare coordination in Canada); retirement savings plans (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

Location: Atlanta, GA (hybrid)
Salary: USD 103,330 - 128,656 per year
Experience: 4+ years minimum

Similar Jobs