Data Engineer (Snowflake, AWS) (contract)

Capgemini; Fort Mill (SC); On-site; USD 54,911 - 85,810; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Retirement benefits

Job summary

Capgemini is looking for an experienced Developer based in South Carolina to design, implement, and optimize data engineering solutions. With over 10 years of IT experience, the ideal candidate will have deep expertise in Snowflake and cloud platforms including AWS and Azure.

This role involves leading database migration initiatives, managing Snowflake security, and driving performance tuning and optimization. Strong communication skills and the ability to work in a fast-paced environment are essential.

Qualifications

• 10+ years of IT experience with significant hands-on experience in the Snowflake platform.
• Strong expertise in SQL and Python.
• Experience with Infrastructure as Code, CI/CD tools, and cloud ecosystem.

Responsibilities

• Design, implement, and optimize end-to-end data engineering solutions.
• Lead database migration initiatives to Snowflake across cloud platforms.
• Manage Snowflake platform security.

Skills

SQL

Python

Snowflake architecture

Terraform

CI/CD tools

AWS

Orchestration tools (e.g., Airflow)

Tools

SnowSQL

Snowpark

Snowpipe

Job description

Overview

We are seeking an experienced Developer with 10+ years of IT experience and deep expertise in data engineering and cloud-based data platforms (Snowflake/AWS). The ideal candidate will have strong hands-on experience in designing, implementing, and optimizing scalable data solutions, along with proven experience in database migrations, security, and cost optimization on Snowflake.

Key Responsibilities

• Design, implement, and optimize end-to-end data engineering solutions including data ingestion, data lakes, data warehouses, reporting, and analytics.
• Lead database migration initiatives to Snowflake across cloud platforms such as AWS and Azure.
• Manage Snowflake platform security, including:
  • Role-Based Access Control (RBAC)
  • Single Sign-On (SSO)
  • Dynamic data masking and compliance
• Implement and manage tokenization and resolve issues related to encrypted key access in Snowflake.
• Monitor and optimize Snowflake costs by:
  • Tracking compute usage
  • Setting up resource monitors
  • Enforcing warehouse sizing best practices
• Design and manage cross-region disaster recovery, data replication, and high availability solutions.
• Develop and maintain CI/CD pipelines for Snowflake deployments.
• Utilize Snowflake utilities and features, including:
  • SnowSQL, Snowpark, Snowpipe
  • Tasks, Streams, Stored Procedures
  • Time Travel, Zero-Copy Cloning
  • Resource Monitors and Data Sharing
  • Data Masking and Data Replication
• Drive performance tuning and query optimization initiatives within Snowflake.
• Manage Snowflake account setup, cloud administration, and integration with orchestration tools.

Required Qualifications

• 10+ years of IT experience, with significant hands-on experience in the Snowflake platform.
• Strong expertise in SQL and Python.
• Experience with:
  • Infrastructure as Code (Terraform)
  • CI/CD tools (GitLab, GitHub Actions)
  • Cloud ecosystem, primarily AWS
  • Orchestration tools like Airflow
• Deep understanding of:
  • Snowflake architecture and Virtual Warehouses
  • Snowpark and data sharing capabilities
  • Snowflake cost monitoring and optimization
• Hands-on experience in:
  • Dynamic data masking
  • Tokenization
  • Secure data sharing

Preferred Skills

• Snowflake certifications such as SnowPro Core or SnowPro Advanced Architect.
• Experience in data governance, security, and regulatory compliance frameworks.
• Familiarity with ETL tools and modern data integration frameworks.
• Strong communication, stakeholder management, and project management skills.
• Ability to work in a fast-paced, global delivery environment.

Key Attributes

• Strong problem-solving and analytical skills.
• Ability to drive architecture decisions and best practices.
• Proactive in identifying cost optimization and performance improvement opportunities.
• Excellent collaboration skills across cross-functional teams.

The pay range that the employer in good faith reasonably expects to pay for this position is $39.86/hour - $62.29/hour.

Benefits and Compliance

Our offered benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.