Data Engineer (Snowflake, AWS)

Capgemini
Fort Mill, United States of America
2 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 130K

Job location

Fort Mill, United States of America

Tech stack

Airflow
Amazon Web Services (AWS)
Azure
Continuous Integration
Information Engineering
Data Governance
Data Integration
ETL
Data Masking
Data Security
Data Sharing
Data Warehousing
Disaster Recovery
Github
Python
Performance Tuning
Query Optimization
Role-Based Access Control
Cloud Services
Single Sign-On
SQL Stored Procedures
SQL Databases
Tokenization
Workflow Management Systems
Cloud Platform System
Data Ingestion
Snowflake
Gitlab
Database Migration
Data Lake
Information Technology
Dynamic Data
Database Replication
Terraform
Data Pipelines

Job description

We are seeking an experienced Developer with 10+ years of overall 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., * 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.

Requirements

Do you have experience in Terraform?, * 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.

Benefits & conditions

Pulled from the full job description

  • Retirement plan
  • Vision insurance
  • Dental insurance, The pay range that the employer in good faith reasonably expects to pay for this position is $39.86/hour - $62.29/hour.

About the company

Capgemini ist einer der weltweit führenden Anbieter von Management- und IT-Beratung, Technologie-Services und Digitaler Transformation. Als ein Wegbereiter für Innovation unterstützt das Unternehmen seine Kunden bei deren komplexen Herausforderungen rund um Cloud, Digital und Plattformen.

Apply for this position