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 seeking a Senior Data Engineer to design, build, optimize, and maintain scalable cloud-based data platforms with strong Snowflake expertise. In this role, you will coordinate with business stakeholders and engineering teams to deliver dependable, high-performance data solutions across reporting, analytics, and advanced data initiatives.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines and data integration solutions.
- Build and optimize data warehouse solutions using Snowflake.
- Create ETL/ELT processes to ingest, transform, and load data from multiple source systems.
- Apply data modeling approaches, including dimensional modeling and star schema design.
- Optimize Snowflake performance, storage usage, and cost management.
- Maintain data quality, integrity, governance, and security across the data platform.
- Partner with business users, analysts, and architects to gather 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 reinforce data engineering best practices.
- Participate in architecture reviews and technology evaluations.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a 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 within Snowflake using Cortex capabilities, including natural language querying, semantic search, document processing, text analytics, and 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.
Technologies
- Snowflake
- SQL
- ETL, ELT
- Cortex
- Natural language querying
- Semantic search
- Document processing
- Text analytics
- Generative AI
- Python
- AWS, Azure, Google Cloud Platform
Location
Houston, TX (onsite)
Compensation
The base compensation range for this role in the posted location is $76,730 - $150,800 per year.
In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.
Benefits
- Paid time off based on employee grade (A-F) per company policy: Vacation 12-25 days depending on grade, company-paid holidays, Personal Days, and Sick Leave.
- Medical, dental, and vision coverage (or provincial healthcare coordination in Canada).
- Retirement savings plans such as a 401(k) in the U.S. or RRSP in Canada.
- Life and disability insurance.
- Employee assistance programs.
- Other benefits as provided by local policy and eligibility.