Data Engineer - Snowflake
Azure
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Engineer
Cloud Native
Cloud Operations
Cloud Platform
Cloud Platforms
Cloud Platforms Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
Engineer
ETL
Google Cloud
Informatica
Information Technology (IT)
Programming Language
Programming Languages
Snowflake
Software Development
SQL
Job Description
Capgemini is hiring a Senior Data Engineer to design, build, optimize, and maintain scalable cloud-based data platforms with deep Snowflake expertise.
Responsibilities
- Design, develop, and maintain scalable data pipelines and data integration solutions
- Build and optimize data warehouse solutions using Snowflake
- Create ETL/ELT workflows to ingest, transform, and load data from multiple source systems
- Apply data modeling methods including dimensional modeling and star schema design
- Optimize Snowflake performance, storage, and cost management
- Ensure data quality, integrity, governance, and security across the platform
- Partner with business users, analysts, and architects to collect requirements and deliver data solutions
- Troubleshoot and resolve data pipeline and performance issues
- Support CI/CD deployment processes and infrastructure automation
- Mentor junior engineers and promote data engineering best practices
- Participate in architecture reviews and technology evaluations
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field
- 5+ years of experience in Data Engineering, Data Warehousing, or BI Engineering
- 3+ years of hands-on Snowflake experience
- Strong SQL development and query optimization skills
- Experience building large-scale ETL/ELT pipelines
- Ability to design and implement AI-enabled data solutions in Snowflake using Cortex for:
- natural language querying
- semantic search
- document processing
- text analytics
- generative AI applications
- Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform
- Proficiency in Python for data engineering and automation
- Experience with data modeling and warehouse design
- Strong understanding of data quality, data governance, and security principles
Technology Stack
- Snowflake
- SQL
- ETL, ELT
- Cortex (Natural language querying, Semantic search, Document processing, Text analytics, Generative AI)
- Python
- AWS, Azure, Google Cloud Platform
Benefits
- Paid time off based on employee grade (A-F) under 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 (for example, 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
Compensation
- Base compensation range: USD 76,730 - 150,800 per year (posted location)
- May be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on position and applicable laws
Location: Houston, TX (onsite)